DanBrother的部落格

[PRIMARY SITE]
rman target / nocatalog
RMAN> backup current controlfile for standby;

[STANDBY SITE]
sqlplus / as sysdba
SQL> shut immediate;
# remove all standby data files, control files as redo log files.
SQL> startup nomount;

# Copy latest RMAN backupset from Primary DB
scp -r oracle@10.1.0.2:/u01/oracle/rman_backup/20100526 /u01/oracle/rman_backup

rman TARGET sys/pwd@PrimaryDB AUXILIARY sys/pwd@StandbyDB

RMAN> duplicate target database for standby dorecover nofilenamecheck;

SQL> alter database recover managed standby database disconnect from session;

SQL> archive log list;