Shulou(Shulou.com)06/01 Report--

Duplicate builds DG (Backup-based duplication)

Source database:

Run

{

Allocate channel ch2 device type disk

Allocate channel ch3 device type disk

Backup as compressed backupset database

Sql 'alter system archive log current'

Release channel ch2

Release channel ch3

}

Query the path of the data file

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

To use duplicate, to have the same backup directory and backup set in the standby library as the main library, run the command in the main library.

Configure pfile and standby controlfile on the slave database

Prepare the library operation:

Auxorcl is the target library tnsname.

Rman target sys/oracle@orcl auxiliary sys/oracle@auxorcl

Run

{

Set newname for datafile 1 to'/ u01qqappActionoradataActionSystem01.dbf'

Set newname for datafile 2 to'/ u01qapplash oracle.oradataActionsysaux01.dbf'

Set newname for datafile 3 to'/ u01qapplash oracle.oradataAccording to undotbs01.dbf'.

Set newname for datafile 4 to'/ u01max apppletoracleUniplicateoradataUnimax Users01.dbf'

Set newname for datafile 5 to'/ u01qqapp.oracle.oradataUniplicate.dbf'

Set newname for tempfile 1 to'/ u01qqapp.oracle.oradataAccording to temp01.dbf'.

Duplicate target database for standby

}

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.