Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle Duplicate build DataGuard     - Zabbix monitors Nginx status (Server)

- Zabbix monitoring Oracle Database use Orabbix plug (Enhanced Edition) (Database)

- Find details block device with Linux blkid command (Linux)

- OpenGL Superb Learning Notes - New Patterns (Programming)

- MySQL event table to achieve timing build a small note (Database)

- How to install Bugzilla 4.4 on Ubuntu / CentOS 6.x (Linux)

- Linux - use chroot command (Linux)

- How to add any of a Linux distribution beautiful fonts (Linux)

- TeamCity continuous integration in the Linux installation (Linux)

- CentOS 7 update source - the use of domestic sources 163 yum (Linux)

- RabbitMQ Getting Started Tutorial (Linux)

- UUID in Java (Programming)

- RHEL7 unattended automatic installation DHCP + TFTP + SYSLINUX + TFTP + Kickstart (Linux)

- Using open source software to build XWiki Wiki system installed within the company (Linux)

- Oracle inline view updates problems encountered (Database)

- namespace mechanism Linux kernel analysis (Linux)

- Spring classic face questions Share (Programming)

- Use innobackupex full realization of MySQL hot backup (Database)

- Java memory analysis tool uses detailed MAT (Programming)

- CentOS installation pycurl (Linux)

 
         
  Oracle Duplicate build DataGuard
     
  Add Date : 2017-04-13      
         
       
         
  Duplicate build DataGuard:

Source Library:

run
{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
backup as compressed backupset database;
sql 'alter system archive log current';
release channel ch1;
release channel ch2;
}

Check out the data file path
select 'set newname for datafile' || FILE_ID || 'to' || file_name || ';' from dba_data_files;


select 'set newname for datafile' || FILE_ID || 'to' || file_name || ';' from dba_TEMP_files;

Use duplicate, to be prepared in the library have been working with the main library the same backup directory and have a backup set on the inside, run the command in the main library.

On the standby database configured pfile and standby controlfile

Preparation of library operation:
auxorcl target library tnsname.

rman target sys / Oracle @ cai auxiliary sys / oracle @ auxorcl;

run
{
set newname for datafile 1 to '/u01/app/oracle/oradata/cai/system01.dbf';
set newname for datafile 2 to '/u01/app/oracle/oradata/cai/sysaux01.dbf';
set newname for datafile 3 to '/u01/app/oracle/oradata/cai/undotbs01.dbf';
set newname for datafile 4 to '/u01/app/oracle/oradata/cai/users01.dbf';
set newname for datafile 5 to '/u01/app/oracle/oradata/cai/test.dbf';
set newname for tempfile 1 to '/u01/app/oracle/oradata/cai/temp01.dbf';
duplicate target database for standby;
}
     
         
       
         
  More:      
 
- Linux RHCS basic maintenance commands (Linux)
- Upload the project to GitHub, synchronous remote repository Github (Linux)
- Talk about the Linux ABI compatibility Application (Linux)
- 25 Git Usage Tips (Linux)
- Search Linux commands and files - which, whereis, locate, find (Linux)
- Security Knowledge: redirection command application security (Linux)
- Linux `dirname $ 0` (Linux)
- Java memory analysis tool uses detailed MAT (Programming)
- The difference between IPython and Python (Linux)
- Use Ansible efficient delivery Docker container (Server)
- Binary tree traversal recursive and non-recursive (cyclic) traversal achieve (Programming)
- Install JDK 1.7 + Eclipse in CentOS 6.4 in (Linux)
- Getting the Linux shell expr use (Programming)
- Install NetBeans IDE 8.0 on Ubuntu, Linux Mint, Elementary OS, and Debian (Linux)
- Use OpenSSL for RSA encryption and decryption (Linux)
- MNIST presentation and database conversion (Database)
- Docker Private Registry Installation Guide at CentOS6.X (Linux)
- Linux System Administrator common interview questions and answers 30 (Linux)
- How to restart after a crash Cinnamon (Linux)
- The maximum subsequence algorithm and optimization problems (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.