本文共 6058 字,大约阅读时间需要 20 分钟。
sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 6 21:05:43 2015Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.SQL> startup nomountORACLE instance started.Total System Global Area 1068937216 bytesFixed Size 2220200 bytesVariable Size 624955224 bytesDatabase Buffers 436207616 bytesRedo Buffers 5554176 bytesSQL> quitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@DB200 ~]$ rman target sys/Aa7788123@dadifilma auxiliary sys/Aa7788123@dadifilmbRecovery Manager: Release 11.2.0.1.0 - Production on Fri Feb 6 21:05:57 2015Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.connected to target database: DADIFILM (DBID=4240448887)connected to auxiliary database: DADIFILM (not mounted)RMAN> duplicate target database for standby nofilenamecheck from active database;Starting Duplicate Db at 06-FEB-15using target database control file instead of recovery catalogallocated channel: ORA_AUX_DISK_1channel ORA_AUX_DISK_1: SID=156 device type=DISKcontents of Memory Script:{ backup as copy reuse targetfile '/data/DBSoftware/app/oracle/product/11.2.0/dbhome_1/dbs/orapwdadifilm' auxiliary format '/data/DBSoftware/app/oracle/product/11.2.0/dbhome_1/dbs/orapwdadifilm' ;}executing Memory ScriptStarting backup at 06-FEB-15allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=128 device type=DISKFinished backup at 06-FEB-15contents of Memory Script:{ backup as copy current controlfile for standby auxiliary format '/data/DBData/oradata/dadifilm/control01.ctl'; restore clone controlfile to '/data/DBSoftware/app/oracle/flash_recovery_area/dadifilm/control02.ctl' from '/data/DBData/oradata/dadifilm/control01.ctl';}executing Memory ScriptStarting backup at 06-FEB-15using channel ORA_DISK_1channel ORA_DISK_1: starting datafile copycopying standby control fileoutput file name=/data/DBSoftware/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_dadifilm.f tag=TAG20150206T210609 RECID=2 STAMP=870987969channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01Finished backup at 06-FEB-15Starting restore at 06-FEB-15using channel ORA_AUX_DISK_1channel ORA_AUX_DISK_1: copied control file copyFinished restore at 06-FEB-15contents of Memory Script:{ sql clone 'alter database mount standby database';}executing Memory Scriptsql statement: alter database mount standby databasecontents of Memory Script:{ set newname for tempfile 1 to "/data/DBData/oradata/dadifilm/temp01.dbf"; switch clone tempfile all; set newname for datafile 1 to "/data/DBData/oradata/dadifilm/system01.dbf"; set newname for datafile 2 to "/data/DBData/oradata/dadifilm/sysaux01.dbf"; set newname for datafile 3 to "/data/DBData/oradata/dadifilm/undotbs01.dbf"; set newname for datafile 4 to "/data/DBData/oradata/dadifilm/users01.dbf"; set newname for datafile 5 to "/data/DBData/oradata/dadifilm/example01.dbf"; backup as copy reuse datafile 1 auxiliary format "/data/DBData/oradata/dadifilm/system01.dbf" datafile 2 auxiliary format "/data/DBData/oradata/dadifilm/sysaux01.dbf" datafile 3 auxiliary format "/data/DBData/oradata/dadifilm/undotbs01.dbf" datafile 4 auxiliary format "/data/DBData/oradata/dadifilm/users01.dbf" datafile 5 auxiliary format "/data/DBData/oradata/dadifilm/example01.dbf" ; sql 'alter system archive log current';}executing Memory Scriptexecuting command: SET NEWNAMErenamed tempfile 1 to /data/DBData/oradata/dadifilm/temp01.dbf in control fileexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEStarting backup at 06-FEB-15using channel ORA_DISK_1channel ORA_DISK_1: starting datafile copyinput datafile file number=00001 name=/data/DBData/oradata/dadifilm/system01.dbfoutput file name=/data/DBData/oradata/dadifilm/system01.dbf tag=TAG20150206T210617channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15channel ORA_DISK_1: starting datafile copyinput datafile file number=00002 name=/data/DBData/oradata/dadifilm/sysaux01.dbfoutput file name=/data/DBData/oradata/dadifilm/sysaux01.dbf tag=TAG20150206T210617channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15channel ORA_DISK_1: starting datafile copyinput datafile file number=00003 name=/data/DBData/oradata/dadifilm/undotbs01.dbfoutput file name=/data/DBData/oradata/dadifilm/undotbs01.dbf tag=TAG20150206T210617channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03channel ORA_DISK_1: starting datafile copyinput datafile file number=00005 name=/data/DBData/oradata/dadifilm/example01.dbfoutput file name=/data/DBData/oradata/dadifilm/example01.dbf tag=TAG20150206T210617channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03channel ORA_DISK_1: starting datafile copyinput datafile file number=00004 name=/data/DBData/oradata/dadifilm/users01.dbfoutput file name=/data/DBData/oradata/dadifilm/users01.dbf tag=TAG20150206T210617channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01Finished backup at 06-FEB-15sql statement: alter system archive log currentcontents of Memory Script:{ switch clone datafile all;}executing Memory Scriptdatafile 1 switched to datafile copyinput datafile copy RECID=2 STAMP=870988015 file name=/data/DBData/oradata/dadifilm/system01.dbfdatafile 2 switched to datafile copyinput datafile copy RECID=3 STAMP=870988015 file name=/data/DBData/oradata/dadifilm/sysaux01.dbfdatafile 3 switched to datafile copyinput datafile copy RECID=4 STAMP=870988015 file name=/data/DBData/oradata/dadifilm/undotbs01.dbfdatafile 4 switched to datafile copyinput datafile copy RECID=5 STAMP=870988015 file name=/data/DBData/oradata/dadifilm/users01.dbfdatafile 5 switched to datafile copyinput datafile copy RECID=6 STAMP=870988015 file name=/data/DBData/oradata/dadifilm/example01.dbfFinished Duplicate Db at 06-FEB-15
转载地址:http://kfnpo.baihongyu.com/