The social network for Oracle people
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';
© 2013 Created by Eddie Awad.
You need to be a member of Oracle Community to add comments!
Join Oracle Community