Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle Duplicate build DataGuard     - MongoDB study notes - polymerization (Database)

- MD5 and simple to use (Linux)

- Dialogue UNIX:! $ # @ *% (Linux)

- Linux compiler of GCC (Linux)

- MySQL separation Amoeba achieve literacy (Database)

- Ubuntu install Vendetta Online 14.04 (Linux)

- Windows 8.1 and Ubuntu 14.04 dual system uninstall Ubuntu Tutorial (Linux)

- Try the command ip, ifconfig is obsolete under Linux (Linux)

- Linux, Apache Web site security settings (Linux)

- About Hibernate cache, you want the latest data have trouble even session.clear (Database)

- Mount NFS network file system (Linux)

- Git use and interpretation of common commands (Linux)

- Nine trick to let you speed up the old machine running Ubuntu Linux (Linux)

- Linux upgrade Glibc (Linux)

- Linux Regular expressions grep and egrep (Linux)

- Use JMS listener Oracle AQ, trigger the execution of Java programs in the database changes (Database)

- WebLogic 12c Configuration Node Manager Managed Server (Database)

- Linux simple commands (Linux)

- Linux system find command Detailed (Linux)

- redis configuration in detail (English) (Database)

 
         
  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:      
 
- Sort sql MySQL 5.6 upgrade slow Cause Analysis (Database)
- Use the top command (Linux)
- Perl loop (Programming)
- How to use Xmanager Remote Desktop and VNC Log (Linux)
- Python format string (Programming)
- Android and OpenCV2.4.4 build an image processing framework (2013 edition) (Linux)
- Gentoo: startx problem appears Failed to load module (Linux)
- Use top to monitor the remote server (Server)
- Linux / CentOS 7.0 installation and configuration under Tomcat 8.0 (Server)
- Function Getting the Linux shell (Programming)
- Python, and / or (Programming)
- Vim configuration instructions (Linux)
- How to remove the Linux memory Cache, Buffer and swap space (Linux)
- Linux dual physical network card set to a virtual NIC (Linux)
- ApacheDS configuration of users and user groups to achieve SSO (Server)
- Swift notes - let you two hours to learn Swift (Programming)
- Python context managers (Programming)
- AngularJS achieve picture upload feature (Programming)
- Using Python multithreaded mistakes summary (Programming)
- Vim highlight lookup operation (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.