Oracle Community

The social network for Oracle people

Duplicating a Database Without Recovery Catalog or Target Connection


1/ Take a backup of the target database (orcl)
RMAN > backup incremental level 0
database plus archivelog;
2/ Move the backup pieces to '/home/oracle/backup' of a new server using commands like scp,ftp…
3/ Copy the password file (orapworcl) from the target database to $ORACLE_HOME/dbs and rename it orapwdup
4/ Create a initialization parameter (initdup.ora) for the auxiliary instance with only one parameter DB_NAME=dup
5/ Start the auxiliary instance to nomount mode
export ORACLE_SID=dup
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
sqlplus / as sysdba
startup nomount;
exit;
6/ Connect to the auxiliary instance from RMAN and perform the rman duplicate
rman auxiliary /
DUPLICATE DATABASE TO dup
SPFILE
set CONTROL_FILES='+DATA/dup/controlfile/current.260.777510967'
set DB_FILE_NAME_CONVERT='+DATA/orcl/datafile/','+DATA/dup/datafile/','+DATA/orcl/tempfile/','+DATA/dup/tempfile/'
set LOG_FILE_NAME_CONVERT='+DATA/orcl/onlinelog/','+DATA/dup/onlinelog/','+FRA/orcl/onlinelog/','+FRA/dup/onlinelog/'
BACKUP LOCATION '/home/oracle/backup';

Views: 96

Comment

You need to be a member of Oracle Community to add comments!

Join Oracle Community

© 2013   Created by Eddie Awad.

Badges  |  Report an Issue  |  Terms of Service