dategurd oracle_9. Oracle DataGuard的介绍

[oracle@oracle235 admin]$ rman target sys/li0924@tns_primary auxiliary sys/li0924@tns_standbyRecovery Manager: Release11.2.0.4.0 - Production on Thu Aug 9 23:56:46 2018Copyright (c)1982, 2011, Oracle and/or its affiliates. Allrights reserved.

connectedto target database: ORA235 (DBID=2047494122)

connectedto auxiliary database: ORA235 (notmounted)

RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASEDORECOVER NOFILENAMECHECK;

Starting Duplicate Db at09-AUG-18using targetdatabase control file instead ofrecovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=20 device type=DISKcontentsofMemory Script:

{backup ascopy reuse

targetfile'/u01/app/oracle/dbs/orapwora235'auxiliary format'/u01/app/oracle/dbs/orapwora235';

}

executing Memory Script

Startingbackup at 09-AUG-18allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=26 device type=DISKFinishedbackup at 09-AUG-18contentsofMemory Script:

{backup as copy current controlfile for standby auxiliary format '/u01/app/oradata/ora235/control01.ctl';restore clone controlfile to '/u01/app/oradata/ora235/control02.ctl' from

'/u01/app/oradata/ora235/control01.ctl';

}

executing Memory Script

Startingbackup at 09-AUG-18using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

copying standby controlfileoutputfile name=/u01/app/oracle/dbs/snapcf_ora235.f tag=TAG20180809T235658 RECID=4 STAMP=983750219channel ORA_DISK_1: datafile copy complete, elapsed time:00:00:01Finishedbackup at 09-AUG-18Startingrestore at 09-AUG-18using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: copied controlfilecopy

Finishedrestore at 09-AUG-18contentsofMemory Script:

{

sql clone'alter database mount standby database';

}

executing Memory Script

sql statement:alter database mount standby databasecontentsofMemory Script:

{set newname for tempfile 1 to"/u01/app/oradata/ora235/temp01.dbf";

switch clone tempfileall;set newname for datafile 1 to"/u01/app/oradata/ora235/system01.dbf";set newname for datafile 2 to"/u01/app/oradata/ora235/sysaux01.dbf";set newname for datafile 3 to"/u01/app/oradata/ora235/undotbs01.dbf";set newname for datafile 4 to"/u01/app/oradata/ora235/users01.dbf";set newname for datafile 5 to"/data/oracle/data/lottu01.dbf";backup ascopy reuse

datafile1auxiliary format

"/u01/app/oradata/ora235/system01.dbf" datafile2auxiliary format

"/u01/app/oradata/ora235/sysaux01.dbf" datafile3auxiliary format

"/u01/app/oradata/ora235/undotbs01.dbf" datafile4auxiliary format

"/u01/app/oradata/ora235/users01.dbf" datafile5auxiliary format

"/data/oracle/data/lottu01.dbf" ;

sql'alter system archive log current';

}

executing Memory Script

executing command:SETNEWNAME

renamed tempfile1 to /u01/app/oradata/ora235/temp01.dbf in control fileexecuting command:SETNEWNAME

executing command:SETNEWNAME

executing command:SETNEWNAME

executing command:SETNEWNAME

executing command:SETNEWNAME

Startingbackup at 09-AUG-18using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafilefile number=00005 name=/data/oracle/data/lottu01.dbf

outputfile name=/data/oracle/data/lottu01.dbf tag=TAG20180809T235706

channel ORA_DISK_1: datafile copy complete, elapsed time:00:01:45channel ORA_DISK_1: starting datafile copy

input datafilefile number=00001 name=/u01/app/oradata/ora235/system01.dbf

outputfile name=/u01/app/oradata/ora235/system01.dbf tag=TAG20180809T235706

channel ORA_DISK_1: datafile copy complete, elapsed time:00:00:35channel ORA_DISK_1: starting datafile copy

input datafilefile number=00002 name=/u01/app/oradata/ora235/sysaux01.dbf

outputfile name=/u01/app/oradata/ora235/sysaux01.dbf tag=TAG20180809T235706

channel ORA_DISK_1: datafile copy complete, elapsed time:00:00:35channel ORA_DISK_1: starting datafile copy

input datafilefile number=00003 name=/u01/app/oradata/ora235/undotbs01.dbf

outputfile name=/u01/app/oradata/ora235/undotbs01.dbf tag=TAG20180809T235706

channel ORA_DISK_1: datafile copy complete, elapsed time:00:00:25channel ORA_DISK_1: starting datafile copy

input datafilefile number=00004 name=/u01/app/oradata/ora235/users01.dbf

outputfile name=/u01/app/oradata/ora235/users01.dbf tag=TAG20180809T235706

channel ORA_DISK_1: datafile copy complete, elapsed time:00:00:01Finishedbackup at 10-AUG-18sql statement:alter system archive log currentcontentsofMemory Script:

{backup ascopy reuse

archiveloglike "/data/arch/1_3_983660602.dbf" auxiliary format

"/data/arch/1_3_983660602.dbf" ;

catalog clone archivelog "/data/arch/1_3_983660602.dbf";

switch clone datafileall;

}

executing Memory Script

Startingbackup at 10-AUG-18using channel ORA_DISK_1

channel ORA_DISK_1: starting archivedlogcopy

input archivedlog thread=1 sequence=3 RECID=19 STAMP=983750428outputfile name=/data/arch/1_3_983660602.dbf RECID=0 STAMP=0channel ORA_DISK_1: archivedlog copy complete, elapsed time: 00:00:01Finishedbackup at 10-AUG-18cataloged archivedlogarchivedlog file name=/data/arch/1_3_983660602.dbf RECID=1 STAMP=983750429datafile1 switched todatafile copy

input datafile copy RECID=4 STAMP=983750429 file name=/u01/app/oradata/ora235/system01.dbf

datafile2 switched todatafile copy

input datafile copy RECID=5 STAMP=983750429 file name=/u01/app/oradata/ora235/sysaux01.dbf

datafile3 switched todatafile copy

input datafile copy RECID=6 STAMP=983750429 file name=/u01/app/oradata/ora235/undotbs01.dbf

datafile4 switched todatafile copy

input datafile copy RECID=7 STAMP=983750429 file name=/u01/app/oradata/ora235/users01.dbf

datafile5 switched todatafile copy

input datafile copy RECID=8 STAMP=983750429 file name=/data/oracle/data/lottu01.dbf

contentsofMemory Script:

{set until scn 955597;

recover

standby

clonedatabase

deletearchivelog

;

}

executing Memory Script

executing command:SETuntil clause

Starting recover at10-AUG-18using channel ORA_AUX_DISK_1

starting media recovery

archivedlog for thread 1 with sequence 3 is already on disk as file /data/arch/1_3_983660602.dbf

archivedlog file name=/data/arch/1_3_983660602.dbf thread=1 sequence=3media recovery complete, elapsed time:00:00:00Finished recover at10-AUG-18Finished Duplicate Db at10-AUG-18