DATAGUARD手记（DUPLICATE）（四）

最新推荐文章于 2021-04-04 06:15:31 发布
最新推荐文章于 2021-04-04 06:15:31 发布
阅读量260 收藏
点赞数

http://zhouwf0726.itpub.net/post/9689/395349
http://zhouwf0726.itpub.net/post/9689/395350
http://zhouwf0726.itpub.net/post/9689/395437
http://zhouwf0726.itpub.net/post/9689/401874
http://zhouwf0726.itpub.net/post/9689/403401

为了测试在含有DG和STREAM环境的ORACLE升级，搭建一个测试环境，首先搭建DG环境。


一、登录主机备份数据库

db-tfusn2cn-a-r1.amazon$ sudo -H -u oracle /opt/third-party/bin/logbash --login
amazon.com authorized use only. weifengz@db-tfusn2cn-a-r1 Password:
no VLM_WINDOW_SIZE entry for DEFAULT, using default (512MB)

LD_LIBRARY_PATH=/opt/app/oracle/product/10.1.0.4/A04db/lib:/opt/third-party/lib:/usr/lib
ORACLE_SID=DEFAULT
ORACLE_HOME=/opt/app/oracle/product/10.1.0.4/A04db
SHLIB_PATH=/opt/app/oracle/product/10.1.0.4/A04db/lib
TZ=UTC
VLM_WINDOW_SIZE=
DISABLE_MAP_LOCK - 1

logbash: /opt/app/oracle: is a directory
oracle:db-tfusn2cn-a-r1.amazon.com: /opt/app/oracle> oraenvamzn yudong
no VLM_WINDOW_SIZE entry for yudong, using default (512MB)

LD_LIBRARY_PATH=/opt/app/oracle/product/10.1.0.4/A04db/lib:/opt/third-party/lib:/usr/lib
ORACLE_SID=yudong
ORACLE_HOME=/opt/app/oracle/product/10.1.0.4/A04db
SHLIB_PATH=/opt/app/oracle/product/10.1.0.4/A04db/lib
TZ=UTC
VLM_WINDOW_SIZE=
DISABLE_MAP_LOCK - 1

oracle:db-tfusn2cn-a-r1.amazon.com: /opt/app/oracle/product/10.1.0.4/A04db/dbs> $ORACLE_HOME/bin/rman target /

Recovery Manager: Release 10.1.0.4.0 - Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

connected to target database: YUDONG (DBID=404134968)

RMAN> backup tag 'fullforstandby' database include current controlfile for standby plus archivelog;


Starting backup at 30-SEP-07
current log archived
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=106 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=700 recid=2612 stamp=634132672
input archive log thread=1 sequence=701 recid=2614 stamp=634132694

..................................................................
..................................................................

input archive log thread=1 sequence=758 recid=2771 stamp=634304182
input archive log thread=1 sequence=759 recid=2774 stamp=634307781
channel ORA_DISK_1: starting piece 1 at 30-SEP-07
channel ORA_DISK_1: finished piece 1 at 30-SEP-07
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7ait70oh_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=760 recid=2777 stamp=634311381
input archive log thread=1 sequence=761 recid=2780 stamp=634314983

..................................................................
..................................................................

input archive log thread=1 sequence=802 recid=2903 stamp=634458782
input archive log thread=1 sequence=803 recid=2906 stamp=634462384
channel ORA_DISK_1: starting piece 1 at 30-SEP-07
channel ORA_DISK_1: finished piece 1 at 30-SEP-07
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7bit70oq_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=804 recid=2909 stamp=634465983
input archive log thread=1 sequence=805 recid=2912 stamp=634469582

..................................................................
..................................................................

input archive log thread=1 sequence=850 recid=3043 stamp=634618289


input archive log thread=1 sequence=851 recid=3045

stamp=634618640
channel ORA_DISK_1: starting piece 1 at 30-SEP-07
channel ORA_DISK_1: finished piece 1 at 30-SEP-07
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7cit70p2_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
Finished backup at 30-SEP-07

Starting backup at 30-SEP-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00017 name=/fs-a01-a/databases/yudong/large_idx-01.dbf
input datafile fno=00014 name=/fs-a01-a/databases/yudong/administrator-02.dbf
input datafile fno=00001 name=/fs-a01-b/databases/yudong/system-01.dbf
input datafile fno=00004 name=/fs-a01-a/databases/yudong/administrator-01.dbf
input datafile fno=00006 name=/fs-a01-b/databases/yudong/replication-01.dbf
input datafile fno=00008 name=/fs-a01-a/databases/yudong/precise_or_tab-01.dbf
input datafile fno=00002 name=/fs-a01-a/databases/yudong/undo_t1-01.dbf
input datafile fno=00003 name=/fs-a01-a/databases/yudong/sysaux-01.dbf
input datafile fno=00005 name=/fs-a01-b/databases/yudong/administrator_idx-01.dbf
input datafile fno=00009 name=/fs-a01-b/databases/yudong/system-02.dbf
input datafile fno=00010 name=/fs-a01-a/databases/yudong/large_idx-02.dbf
input datafile fno=00007 name=/fs-a01-a/databases/yudong/replication_idx-01.dbf
input datafile fno=00011 name=/fs-a01-b/databases/yudong/system-03.dbf
input datafile fno=00016 name=/fs-a01-a/databases/yudong/zwf_new.dbf
input datafile fno=00012 name=/fs-a01-a/databases/yudong/large_idx-03.dbf
input datafile fno=00013 name=/fs-a01-a/databases/yudong/sysaux-02.dbf
input datafile fno=00015 name=/fs-a01-a/databases/yudong/zwf.dbf
input datafile fno=00018 name=/fs-a01-a/databases/yudong/zwf_new_new.dbf
input datafile fno=00020 name=/fs-a01-a/databases/yudong/t_zwf.dbf
input datafile fno=00019 name=/fs-a01-a/databases/yudong/zwf_new_new_new.dbf
channel ORA_DISK_1: starting piece 1 at 30-SEP-07

channel ORA_DISK_1: finished piece 1 at 30-SEP-07
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7dit70pa_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:36

channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including standby controlfile in backupset
channel ORA_DISK_1: starting piece 1 at 30-SEP-07
channel ORA_DISK_1: finished piece 1 at 30-SEP-07
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7eit70u6_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 30-SEP-07

Starting backup at 30-SEP-07
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set


input archive log thread=1 sequence=852 recid=3047

stamp=634618825
channel ORA_DISK_1: starting piece 1 at 30-SEP-07
channel ORA_DISK_1: finished piece 1 at 30-SEP-07
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7fit70u9_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 30-SEP-07

Starting Control File Autobackup at 30-SEP-07
piece handle=/oracle-backup/db-backup/databases/yudong/c-404134968-20070930-03 comment=NONE
Finished Control File Autobackup at 30-SEP-07

二、登录从机创建STANDBY


weifengz.desktop% sudo -H -u oracle /opt/third-party/bin/logbash --login
amazon.com authorized use only. weifengz@weifengz Password:

No such sid "DEFAULT".
Using default values.
no VLM_WINDOW_SIZE entry for , using default (512MB)

LD_LIBRARY_PATH=/opt/app/oracle/product/10.1.0.4/A04db/lib:/opt/third-party/lib:/usr/lib
ORACLE_SID=
ORACLE_HOME=/opt/app/oracle/product/10.1.0.4/A04db
SHLIB_PATH=/opt/app/oracle/product/10.1.0.4/A04db/lib
TZ=UTC
VLM_WINDOW_SIZE=
DISABLE_MAP_LOCK - 1

logbash: /opt/app/oracle: is a directory
oracle:weifengz.desktop.amazon.com: /opt/app/oracle> oraenvamzn yudong
no VLM_WINDOW_SIZE entry for yudong, using default (512MB)

LD_LIBRARY_PATH=/opt/app/oracle/product/10.1.0.4/A04db/lib:/opt/third-party/lib:/usr/lib
ORACLE_SID=yudong
ORACLE_HOME=/opt/app/oracle/product/10.1.0.4/A04db
SHLIB_PATH=/opt/app/oracle/product/10.1.0.4/A04db/lib
TZ=UTC
VLM_WINDOW_SIZE=
DISABLE_MAP_LOCK - 1


oracle:weifengz.desktop.amazon.com: /opt/app/oracle/product/10.1.0.4/A04db/dbs> scp weifengz@db-tfusn2cn-a-r1.amazon.com:/opt/app/oracle/product/10.1.0.4/A04db/dbs/6oit6r09_1_1 .
Password:
Response:
6oit6r09_1_1 100% 176MB 10.1MB/s 00:16
oracle:weifengz.desktop.amazon.com: /opt/app/oracle/product/10.1.0.4/A04db/dbs> scp weifengz@db-tfusn2cn-a-r1.amazon.com:/opt/app/oracle/product/10.1.0.4/A04db/dbs/6pit6r0p_1_1 .
Password:
Response:
6pit6r0p_1_1 100% 175MB 10.0MB/s 00:16
oracle:weifengz.desktop.amazon.com: /opt/app/oracle/product/10.1.0.4/A04db/dbs> scp weifengz@db-tfusn2cn-a-r1.amazon.com:/opt/app/oracle/product/10.1.0.4/A04db/dbs/6qit6r12_1_1 .
Password:
Response:
6qit6r12_1_1 100% 175MB 10.1MB/s 00:15
oracle:weifengz.desktop.amazon.com: /opt/app/oracle/product/10.1.0.4/A04db/dbs> scp weifengz@db-tfusn2cn-a-r1.amazon.com:/opt/app/oracle/product/10.1.0.4/A04db/dbs/6rit6r1a_1_1 .
Password:
Response:
6rit6r1a_1_1 100% 1351MB 10.0MB/s 02:01
oracle:weifengz.desktop.amazon.com: /opt/app/oracle/product/10.1.0.4/A04db/dbs> scp weifengz@db-tfusn2cn-a-r1.amazon.com:/opt/app/oracle/product/10.1.0.4/A04db/dbs/6sit6r67_1_1 .
Password:
Response:
6sit6r67_1_1 100% 9248KB 9.0MB/s 00:01
oracle:weifengz.desktop.amazon.com: /opt/app/oracle/product/10.1.0.4/A04db/dbs> scp weifengz@db-tfusn2cn-a-r1.amazon.com:/opt/app/oracle/product/10.1.0.4/A04db/dbs/6tit6r69_1_1 .
Password:
Response:
6tit6r69_1_1 100% 188KB 0.0KB/s 00:00


oracle:weifengz.desktop.amazon.com: /opt/app/oracle/product/10.1.0.4/A04db/dbs> $ORACLE_HOME/bin/rman target sys/sys@yudong_a auxiliary sys/sys@yudong_b

Recovery Manager: Release 10.1.0.4.0 - Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

connected to target database: YUDONG (DBID=404134968)
connected to auxiliary database (not started)

RMAN> startup auxiliary nomount;

Oracle instance started

Total System Global Area 490733568 bytes

Fixed Size 779456 bytes
Variable Size 407771968 bytes
Database Buffers 81920000 bytes
Redo Buffers 262144 bytes

RMAN> run{
2> set until sequence=851 thread=1;
3> duplicate target database for standby dorecover nofilenamecheck;
4> }

executing command: SET until clause
using target database controlfile instead of recovery catalog

Starting Duplicate Db at 30-SEP-07
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=141 devtype=DISK

contents of Memory Script:
{
set until scn 260704166;
restore clone standby controlfile;
sql clone 'alter database mount standby database';
}
executing Memory Script

executing command: SET until clause

Starting restore at 30-SEP-07
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring controlfile
ORA-19624: operation failed, retry possible
ORA-19505: failed to identify file "/opt/app/oracle/product/10.1.0.4/A04db/dbs/73it70b7_1_1"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring controlfile
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/6sit6r67_1_1 tag=TAG20070930T011938
channel ORA_AUX_DISK_1: restore complete
output filename=/ctl-01/databases/yudong/control.ctl
output filename=/ctl-02/databases/yudong/control.ctl
Finished restore at 30-SEP-07

sql statement: alter database mount standby database

contents of Memory Script:
{
set until scn 260704166;
set newname for datafile 1 to
"/fs-a01-b/databases/yudong/system-01.dbf";
set newname for datafile 2 to
"/fs-a01-a/databases/yudong/undo_t1-01.dbf";
set newname for datafile 3 to
"/fs-a01-a/databases/yudong/sysaux-01.dbf";
set newname for datafile 4 to
"/fs-a01-a/databases/yudong/administrator-01.dbf";
set newname for datafile 5 to
"/fs-a01-b/databases/yudong/administrator_idx-01.dbf";
set newname for datafile 6 to
"/fs-a01-b/databases/yudong/replication-01.dbf";
set newname for datafile 7 to
"/fs-a01-a/databases/yudong/replication_idx-01.dbf";
set newname for datafile 8 to
"/fs-a01-a/databases/yudong/precise_or_tab-01.dbf";
set newname for datafile 9 to
"/fs-a01-b/databases/yudong/system-02.dbf";
set newname for datafile 10 to
"/fs-a01-a/databases/yudong/large_idx-02.dbf";
set newname for datafile 11 to
"/fs-a01-b/databases/yudong/system-03.dbf";
set newname for datafile 12 to
"/fs-a01-a/databases/yudong/large_idx-03.dbf";
set newname for datafile 13 to
"/fs-a01-a/databases/yudong/sysaux-02.dbf";
set newname for datafile 14 to
"/fs-a01-a/databases/yudong/administrator-02.dbf";
set newname for datafile 15 to
"/fs-a01-a/databases/yudong/zwf.dbf";
set newname for datafile 16 to
"/fs-a01-a/databases/yudong/zwf_new.dbf";
set newname for datafile 17 to
"/fs-a01-a/databases/yudong/large_idx-01.dbf";
set newname for datafile 18 to
"/fs-a01-a/databases/yudong/zwf_new_new.dbf";
set newname for datafile 19 to
"/fs-a01-a/databases/yudong/zwf_new_new_new.dbf";
set newname for datafile 20 to
"/fs-a01-a/databases/yudong/t_zwf.dbf";
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 30-SEP-07
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /fs-a01-b/databases/yudong/system-01.dbf
restoring datafile 00002 to /fs-a01-a/databases/yudong/undo_t1-01.dbf
restoring datafile 00003 to /fs-a01-a/databases/yudong/sysaux-01.dbf
restoring datafile 00004 to /fs-a01-a/databases/yudong/administrator-01.dbf
restoring datafile 00005 to /fs-a01-b/databases/yudong/administrator_idx-01.dbf
restoring datafile 00006 to /fs-a01-b/databases/yudong/replication-01.dbf
restoring datafile 00007 to /fs-a01-a/databases/yudong/replication_idx-01.dbf
restoring datafile 00008 to /fs-a01-a/databases/yudong/precise_or_tab-01.dbf
restoring datafile 00009 to /fs-a01-b/databases/yudong/system-02.dbf
restoring datafile 00010 to /fs-a01-a/databases/yudong/large_idx-02.dbf
restoring datafile 00011 to /fs-a01-b/databases/yudong/system-03.dbf
restoring datafile 00012 to /fs-a01-a/databases/yudong/large_idx-03.dbf
restoring datafile 00013 to /fs-a01-a/databases/yudong/sysaux-02.dbf
restoring datafile 00014 to /fs-a01-a/databases/yudong/administrator-02.dbf
restoring datafile 00015 to /fs-a01-a/databases/yudong/zwf.dbf
restoring datafile 00016 to /fs-a01-a/databases/yudong/zwf_new.dbf
restoring datafile 00017 to /fs-a01-a/databases/yudong/large_idx-01.dbf
restoring datafile 00018 to /fs-a01-a/databases/yudong/zwf_new_new.dbf
restoring datafile 00019 to /fs-a01-a/databases/yudong/zwf_new_new_new.dbf
restoring datafile 00020 to /fs-a01-a/databases/yudong/t_zwf.dbf
ORA-19624: operation failed, retry possible
ORA-19505: failed to identify file "/opt/app/oracle/product/10.1.0.4/A04db/dbs/72it706b_1_1"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /fs-a01-b/databases/yudong/system-01.dbf
restoring datafile 00002 to /fs-a01-a/databases/yudong/undo_t1-01.dbf
restoring datafile 00003 to /fs-a01-a/databases/yudong/sysaux-01.dbf
restoring datafile 00004 to /fs-a01-a/databases/yudong/administrator-01.dbf
restoring datafile 00005 to /fs-a01-b/databases/yudong/administrator_idx-01.dbf
restoring datafile 00006 to /fs-a01-b/databases/yudong/replication-01.dbf
restoring datafile 00007 to /fs-a01-a/databases/yudong/replication_idx-01.dbf
restoring datafile 00008 to /fs-a01-a/databases/yudong/precise_or_tab-01.dbf
restoring datafile 00009 to /fs-a01-b/databases/yudong/system-02.dbf
restoring datafile 00010 to /fs-a01-a/databases/yudong/large_idx-02.dbf
restoring datafile 00011 to /fs-a01-b/databases/yudong/system-03.dbf
restoring datafile 00012 to /fs-a01-a/databases/yudong/large_idx-03.dbf
restoring datafile 00013 to /fs-a01-a/databases/yudong/sysaux-02.dbf
restoring datafile 00014 to /fs-a01-a/databases/yudong/administrator-02.dbf
restoring datafile 00015 to /fs-a01-a/databases/yudong/zwf.dbf
restoring datafile 00016 to /fs-a01-a/databases/yudong/zwf_new.dbf
restoring datafile 00017 to /fs-a01-a/databases/yudong/large_idx-01.dbf
restoring datafile 00018 to /fs-a01-a/databases/yudong/zwf_new_new.dbf
restoring datafile 00019 to /fs-a01-a/databases/yudong/zwf_new_new_new.dbf
restoring datafile 00020 to /fs-a01-a/databases/yudong/t_zwf.dbf

channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/6rit6r1a_1_1 tag=TAG20070930T011938
channel ORA_AUX_DISK_1: restore complete
Finished restore at 30-SEP-07

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafilecopy recid=37 stamp=634621649 filename=/fs-a01-b/databases/yudong/system-01.dbf
datafile 2 switched to datafile copy
input datafilecopy recid=38 stamp=634621649 filename=/fs-a01-a/databases/yudong/undo_t1-01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=39 stamp=634621649 filename=/fs-a01-a/databases/yudong/sysaux-01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=40 stamp=634621649 filename=/fs-a01-a/databases/yudong/administrator-01.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=41 stamp=634621649 filename=/fs-a01-b/databases/yudong/administrator_idx-01.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=42 stamp=634621649 filename=/fs-a01-b/databases/yudong/replication-01.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=43 stamp=634621649 filename=/fs-a01-a/databases/yudong/replication_idx-01.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=44 stamp=634621649 filename=/fs-a01-a/databases/yudong/precise_or_tab-01.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=45 stamp=634621650 filename=/fs-a01-b/databases/yudong/system-02.dbf
datafile 10 switched to datafile copy
input datafilecopy recid=46 stamp=634621650 filename=/fs-a01-a/databases/yudong/large_idx-02.dbf
datafile 11 switched to datafile copy
input datafilecopy recid=47 stamp=634621650 filename=/fs-a01-b/databases/yudong/system-03.dbf
datafile 12 switched to datafile copy
input datafilecopy recid=48 stamp=634621650 filename=/fs-a01-a/databases/yudong/large_idx-03.dbf
datafile 13 switched to datafile copy
input datafilecopy recid=49 stamp=634621650 filename=/fs-a01-a/databases/yudong/sysaux-02.dbf
datafile 14 switched to datafile copy
input datafilecopy recid=50 stamp=634621650 filename=/fs-a01-a/databases/yudong/administrator-02.dbf
datafile 15 switched to datafile copy
input datafilecopy recid=51 stamp=634621650 filename=/fs-a01-a/databases/yudong/zwf.dbf
datafile 16 switched to datafile copy
input datafilecopy recid=52 stamp=634621650 filename=/fs-a01-a/databases/yudong/zwf_new.dbf
datafile 17 switched to datafile copy
input datafilecopy recid=53 stamp=634621650 filename=/fs-a01-a/databases/yudong/large_idx-01.dbf
datafile 18 switched to datafile copy
input datafilecopy recid=54 stamp=634621650 filename=/fs-a01-a/databases/yudong/zwf_new_new.dbf
datafile 19 switched to datafile copy
input datafilecopy recid=55 stamp=634621650 filename=/fs-a01-a/databases/yudong/zwf_new_new_new.dbf
datafile 20 switched to datafile copy
input datafilecopy recid=56 stamp=634621650 filename=/fs-a01-a/databases/yudong/t_zwf.dbf

contents of Memory Script:
{
set until scn 260704166;
recover
standby
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 30-SEP-07
using channel ORA_AUX_DISK_1

starting media recovery

archive log thread 1 sequence 846 is already on disk as file /arch-01/databases/yudong/redolog/-846-1-632058350.arc
archive log filename=/arch-01/databases/yudong/redolog/-846-1-632058350.arc thread=1 sequence=846
channel ORA_AUX_DISK_1: starting archive log restore to default destination
channel ORA_AUX_DISK_1: restoring archive log
archive log thread=1 sequence=847
channel ORA_AUX_DISK_1: restoring archive log
archive log thread=1 sequence=848
channel ORA_AUX_DISK_1: restoring archive log
archive log thread=1 sequence=849
channel ORA_AUX_DISK_1: restoring archive log
archive log thread=1 sequence=850
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7cit70p2_1_1 tag=FULLFORSTANDBY
channel ORA_AUX_DISK_1: restore complete
archive log filename=/arch-01/databases/yudong/redolog/-847-1-632058350.arc thread=1 sequence=847
channel clone_default: deleting archive log(s)
archive log filename=/arch-01/databases/yudong/redolog/-847-1-632058350.arc recid=1 stamp=634621653
archive log filename=/arch-01/databases/yudong/redolog/-848-1-632058350.arc thread=1 sequence=848
channel clone_default: deleting archive log(s)
archive log filename=/arch-01/databases/yudong/redolog/-848-1-632058350.arc recid=3 stamp=634621655
archive log filename=/arch-01/databases/yudong/redolog/-849-1-632058350.arc thread=1 sequence=849
channel clone_default: deleting archive log(s)
archive log filename=/arch-01/databases/yudong/redolog/-849-1-632058350.arc recid=2 stamp=634621655
archive log filename=/arch-01/databases/yudong/redolog/-850-1-632058350.arc thread=1 sequence=850
channel clone_default: deleting archive log(s)
archive log filename=/arch-01/databases/yudong/redolog/-850-1-632058350.arc recid=4 stamp=634621655
media recovery complete
Finished recover at 30-SEP-07
Finished Duplicate Db at 30-SEP-07


RMAN> exit


Recovery Manager complete.
oracle:weifengz.desktop.amazon.com: /redo-04-a/databases/yudong> sqlplus "/as sysdba"

SQL*Plus: Release 10.1.0.4.0 - Production on Sun Sep 30 03:55:03 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select database_role,switchover_status,protection_mode,protection_level from v$database;

DATABASE_ROLE SWITCHOVER_STATUS PROTECTION_MODE PROTECTION_LEVEL
---------------- -------------------- -------------------- --------------------
PHYSICAL STANDBY NOT ALLOWED MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE

SQL> select process from v$managed_standby;

PROCESS
---------
ARCH
ARCH
RFS

SQL> select sequence#,applied from v$archived_log;

SEQUENCE# APP
---------- ---
847 YES
849 YES
848 YES
850 NO
851 NO
852 NO
853 NO

7 rows selected.


三、登录到主机

SYS.YUDONG>select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
853

1 row selected.

SYS.YUDONG>alter system switch logfile;

System altered.

SYS.YUDONG>select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
854

1 row selected.

四、登录到从机

SQL> select process from v$managed_standby;

PROCESS
---------
ARCH
ARCH
RFS
RFS
RFS

SQL> select sequence#,applied from v$archived_log;

SEQUENCE# APP
---------- ---
847 YES
849 YES
848 YES
850 NO
851 NO
852 NO
853 NO
854 NO

8 rows selected.


SQL> recover managed standby database disconnect from session;
Media recovery complete.
SQL> select process from v$managed_standby;

PROCESS
---------
ARCH
ARCH
RFS
RFS
RFS
MRP0

6 rows selected.

注意这里增加了MRP0进程。

SQL> select sequence#,applied from v$archived_log;

SEQUENCE# APP
---------- ---
847 YES
849 YES
848 YES
850 NO
851 NO
852 NO
853 NO
854 NO

8 rows selected.

SQL> /

SEQUENCE# APP
---------- ---
847 YES
849 YES
848 YES
850 YES
851 NO
852 NO
853 NO
854 NO

8 rows selected.

SQL> /

SEQUENCE# APP
---------- ---
847 YES
849 YES
848 YES
850 YES
851 YES
852 NO
853 NO
854 NO

8 rows selected.

SQL> /

SEQUENCE# APP
---------- ---
847 YES
849 YES
848 YES
850 YES
851 YES
852 NO
853 NO
854 NO

8 rows selected.

SQL> /

SEQUENCE# APP
---------- ---
847 YES
849 YES
848 YES
850 YES
851 YES
852 NO
853 NO
854 NO

8 rows selected.

SQL> /

SEQUENCE# APP
---------- ---
847 YES
849 YES
848 YES
850 YES
851 YES
852 YES
853 NO
854 NO

8 rows selected.

SQL> /

SEQUENCE# APP
---------- ---
847 YES
849 YES
848 YES
850 YES
851 YES
852 YES
853 YES
854 YES

8 rows selected.

/***************************************一个需要注意的问题***********************************/

大家注意到上边duplicate过程中的一个错误：

ORA-19624: operation failed, retry possible
ORA-19505: failed to identify file "/opt/app/oracle/product/10.1.0.4/A04db/dbs/73it70b7_1_1"
ORA-27037: unable to obtain file status

这个错误产生原因是我们指定了:

set until sequence=851 thread=1;

来进行不完全恢复，我们指定的sequence比备份的控制文件要早，所以在恢复的过程报错，不过本次案例幸好存在一个比较早的备份文件可用，所以RMAN自动使用了上一次的备份来进进行DUPLICATE。如果我们是在一套新的环境执行，一定要记住行不完全恢复的时候，一定要指定until sequence大于等于备份集中的max(seq)+1，

按照上边的备份max(sequence)为852（input archive log thread=1 sequence=852 recid=3047 stamp=634618825），所以我们就该指定set until sequence=853 thread=1;

否则，如果不是我们的系统中存在一个旧版本的可用备份而是在新环境执行不完全恢复，我们会收到以下错误：


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/30/2007 06:29:51
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the controlfile found to restore


或者我们也可以直接按照下边的例子做就可以了（不指定until）。


DUPLICATE过程：

RMAN> duplicate target database for standby dorecover nofilenamecheck;

Starting Duplicate Db at 30-SEP-07
using channel ORA_AUX_DISK_1

contents of Memory Script:
{
set until scn 260772926;
restore clone standby controlfile;
sql clone 'alter database mount standby database';
}
executing Memory Script

executing command: SET until clause

Starting restore at 30-SEP-07
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring controlfile
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7lit7eh5_1_1 tag=FULLFORSTANDBY
channel ORA_AUX_DISK_1: restore complete
output filename=/ctl-01/databases/yudong/control.ctl
output filename=/ctl-02/databases/yudong/control.ctl
Finished restore at 30-SEP-07

sql statement: alter database mount standby database

contents of Memory Script:
{
set until scn 260772926;
set newname for datafile 1 to
"/fs-a01-b/databases/yudong/system-01.dbf";
set newname for datafile 2 to
"/fs-a01-a/databases/yudong/undo_t1-01.dbf";
set newname for datafile 3 to
"/fs-a01-a/databases/yudong/sysaux-01.dbf";
set newname for datafile 4 to
"/fs-a01-a/databases/yudong/administrator-01.dbf";
set newname for datafile 5 to
"/fs-a01-b/databases/yudong/administrator_idx-01.dbf";
set newname for datafile 6 to
"/fs-a01-b/databases/yudong/replication-01.dbf";
set newname for datafile 7 to
"/fs-a01-a/databases/yudong/replication_idx-01.dbf";
set newname for datafile 8 to
"/fs-a01-a/databases/yudong/precise_or_tab-01.dbf";
set newname for datafile 9 to
"/fs-a01-b/databases/yudong/system-02.dbf";
set newname for datafile 10 to
"/fs-a01-a/databases/yudong/large_idx-02.dbf";
set newname for datafile 11 to
"/fs-a01-b/databases/yudong/system-03.dbf";
set newname for datafile 12 to
"/fs-a01-a/databases/yudong/large_idx-03.dbf";
set newname for datafile 13 to
"/fs-a01-a/databases/yudong/sysaux-02.dbf";
set newname for datafile 14 to
"/fs-a01-a/databases/yudong/administrator-02.dbf";
set newname for datafile 15 to
"/fs-a01-a/databases/yudong/zwf.dbf";
set newname for datafile 16 to
"/fs-a01-a/databases/yudong/zwf_new.dbf";
set newname for datafile 17 to
"/fs-a01-a/databases/yudong/large_idx-01.dbf";
set newname for datafile 18 to
"/fs-a01-a/databases/yudong/zwf_new_new.dbf";
set newname for datafile 19 to
"/fs-a01-a/databases/yudong/zwf_new_new_new.dbf";
set newname for datafile 20 to
"/fs-a01-a/databases/yudong/t_zwf.dbf";
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 30-SEP-07
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /fs-a01-b/databases/yudong/system-01.dbf
restoring datafile 00002 to /fs-a01-a/databases/yudong/undo_t1-01.dbf
restoring datafile 00003 to /fs-a01-a/databases/yudong/sysaux-01.dbf
restoring datafile 00004 to /fs-a01-a/databases/yudong/administrator-01.dbf
restoring datafile 00005 to /fs-a01-b/databases/yudong/administrator_idx-01.dbf
restoring datafile 00006 to /fs-a01-b/databases/yudong/replication-01.dbf
restoring datafile 00007 to /fs-a01-a/databases/yudong/replication_idx-01.dbf
restoring datafile 00008 to /fs-a01-a/databases/yudong/precise_or_tab-01.dbf
restoring datafile 00009 to /fs-a01-b/databases/yudong/system-02.dbf
restoring datafile 00010 to /fs-a01-a/databases/yudong/large_idx-02.dbf
restoring datafile 00011 to /fs-a01-b/databases/yudong/system-03.dbf
restoring datafile 00012 to /fs-a01-a/databases/yudong/large_idx-03.dbf
restoring datafile 00013 to /fs-a01-a/databases/yudong/sysaux-02.dbf
restoring datafile 00014 to /fs-a01-a/databases/yudong/administrator-02.dbf
restoring datafile 00015 to /fs-a01-a/databases/yudong/zwf.dbf
restoring datafile 00016 to /fs-a01-a/databases/yudong/zwf_new.dbf
restoring datafile 00017 to /fs-a01-a/databases/yudong/large_idx-01.dbf
restoring datafile 00018 to /fs-a01-a/databases/yudong/zwf_new_new.dbf
restoring datafile 00019 to /fs-a01-a/databases/yudong/zwf_new_new_new.dbf
restoring datafile 00020 to /fs-a01-a/databases/yudong/t_zwf.dbf


channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7kit7ec9_1_1 tag=FULLFORSTANDBY
channel ORA_AUX_DISK_1: restore complete
Finished restore at 30-SEP-07

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafilecopy recid=37 stamp=634672246 filename=/fs-a01-b/databases/yudong/system-01.dbf
datafile 2 switched to datafile copy
input datafilecopy recid=38 stamp=634672246 filename=/fs-a01-a/databases/yudong/undo_t1-01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=39 stamp=634672246 filename=/fs-a01-a/databases/yudong/sysaux-01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=40 stamp=634672246 filename=/fs-a01-a/databases/yudong/administrator-01.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=41 stamp=634672246 filename=/fs-a01-b/databases/yudong/administrator_idx-01.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=42 stamp=634672246 filename=/fs-a01-b/databases/yudong/replication-01.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=43 stamp=634672246 filename=/fs-a01-a/databases/yudong/replication_idx-01.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=44 stamp=634672246 filename=/fs-a01-a/databases/yudong/precise_or_tab-01.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=45 stamp=634672246 filename=/fs-a01-b/databases/yudong/system-02.dbf
datafile 10 switched to datafile copy
input datafilecopy recid=46 stamp=634672246 filename=/fs-a01-a/databases/yudong/large_idx-02.dbf
datafile 11 switched to datafile copy
input datafilecopy recid=47 stamp=634672246 filename=/fs-a01-b/databases/yudong/system-03.dbf
datafile 12 switched to datafile copy
input datafilecopy recid=48 stamp=634672246 filename=/fs-a01-a/databases/yudong/large_idx-03.dbf
datafile 13 switched to datafile copy
input datafilecopy recid=49 stamp=634672246 filename=/fs-a01-a/databases/yudong/sysaux-02.dbf
datafile 14 switched to datafile copy
input datafilecopy recid=50 stamp=634672246 filename=/fs-a01-a/databases/yudong/administrator-02.dbf
datafile 15 switched to datafile copy
input datafilecopy recid=51 stamp=634672246 filename=/fs-a01-a/databases/yudong/zwf.dbf
datafile 16 switched to datafile copy
input datafilecopy recid=52 stamp=634672246 filename=/fs-a01-a/databases/yudong/zwf_new.dbf
datafile 17 switched to datafile copy
input datafilecopy recid=53 stamp=634672246 filename=/fs-a01-a/databases/yudong/large_idx-01.dbf
datafile 18 switched to datafile copy
input datafilecopy recid=54 stamp=634672246 filename=/fs-a01-a/databases/yudong/zwf_new_new.dbf
datafile 19 switched to datafile copy
input datafilecopy recid=55 stamp=634672246 filename=/fs-a01-a/databases/yudong/zwf_new_new_new.dbf
datafile 20 switched to datafile copy
input datafilecopy recid=56 stamp=634672246 filename=/fs-a01-a/databases/yudong/t_zwf.dbf

contents of Memory Script:
{
set until scn 260772926;
recover
standby
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 30-SEP-07
using channel ORA_AUX_DISK_1

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/fs-a01-b/databases/yudong/system-01.dbf'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/30/2007 17:50:48
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 868 lowscn 260768306 found to restore
RMAN-06025: no backup of log thread 1 seq 867 lowscn 260763636 found to restore
RMAN-06025: no backup of log thread 1 seq 866 lowscn 260758927 found to restore
RMAN-06025: no backup of log thread 1 seq 865 lowscn 260750826 found to restore
RMAN-06025: no backup of log thread 1 seq 864 lowscn 260746255 found to restore
RMAN-06025: no backup of log thread 1 seq 863 lowscn 260741667 found to restore
RMAN-06025: no backup of log thread 1 seq 862 lowscn 260737009 found to restore
RMAN-06025: no backup of log thread 1 seq 861 lowscn 260732431 found to restore
RMAN-06025: no backup of log thread 1 seq 860 lowscn 260727834 found to restore
RMAN-06025: no backup of log thread 1 seq 859 lowscn 260723155 found to restore

RMAN> exit


Recovery Manager complete.
oracle:weifengz.desktop.amazon.com: /arch-01/databases/yudong/redolog> sqlplus "/as sysdba"

SQL*Plus: Release 10.1.0.4.0 - Production on Sun Sep 30 17:52:14 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

SQL> select sequence#,applied from v$archived_log;

no rows selected

SQL> select process from v$managed_standby;

PROCESS
---------
ARCH
ARCH
RFS
RFS

SQL> recover managed standby database disconnect;
Media recovery complete.
SQL> select process from v$managed_standby;

PROCESS
---------
ARCH
ARCH
RFS
RFS
RFS
MRP0

6 rows selected.

SQL> select sequence#,applied from v$archived_log;

SEQUENCE# APP
---------- ---
869 NO

SQL> /

SEQUENCE# APP
---------- ---
869 NO
859 NO
860 NO
861 NO
862 NO
864 NO

6 rows selected.

SQL> /

SEQUENCE# APP
---------- ---
869 NO
859 NO
860 NO
861 NO
862 NO
864 NO
865 NO
866 NO
867 NO

9 rows selected.

SQL> /

SEQUENCE# APP
---------- ---
869 NO
859 NO
860 NO
861 NO
862 NO
864 NO
865 NO
866 NO
867 NO
868 NO

10 rows selected.

SQL> /

SEQUENCE# APP
---------- ---
869 NO
859 YES
860 YES
861 YES
862 YES
864 NO
865 NO
866 NO
867 NO
868 NO
858 YES

SEQUENCE# APP
---------- ---
863 NO

12 rows selected.

SQL> /

SEQUENCE# APP
---------- ---
869 YES
859 YES
860 YES
861 YES
862 YES
864 YES
865 YES
866 YES
867 YES
868 YES
858 YES

SEQUENCE# APP
---------- ---
863 YES

12 rows selected.


该过程我们会看到如下警告提示，这个不会影响我们的创建过程：


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/fs-a01-b/databases/yudong/system-01.dbf'

如果想回避这个警告，我们可以执行不完全恢复，但是一定要记得set until sequence = max(备份集sequence) + 1

过程示例如下：

备份过程：

RMAN> backup tag 'fullforstandby' database include current controlfile for standby plus archivelog;


Starting backup at 30-SEP-07
current log archived
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=127 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=700 recid=2612 stamp=634132672
input archive log thread=1 sequence=701 recid=2614 stamp=634132694

..................................................................
..................................................................

input archive log thread=1 sequence=759 recid=2774 stamp=634307781
input archive log thread=1 sequence=760 recid=2777 stamp=634311381
channel ORA_DISK_1: starting piece 1 at 30-SEP-07
channel ORA_DISK_1: finished piece 1 at 30-SEP-07
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7hit7eb7_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:17
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=761 recid=2780 stamp=634314983
input archive log thread=1 sequence=762 recid=2783 stamp=634318581

..................................................................
..................................................................

input archive log thread=1 sequence=808 recid=2921 stamp=634480383
input archive log thread=1 sequence=809 recid=2924 stamp=634483985
channel ORA_DISK_1: starting piece 1 at 30-SEP-07
channel ORA_DISK_1: finished piece 1 at 30-SEP-07
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7iit7ebo_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=810 recid=2927 stamp=634487584
input archive log thread=1 sequence=811 recid=2930 stamp=634491183

..................................................................
..................................................................

input archive log thread=1 sequence=856 recid=3063 stamp=634629391


input archive log thread=1 sequence=857 recid=3065

stamp=634632550
channel ORA_DISK_1: starting piece 1 at 30-SEP-07
channel ORA_DISK_1: finished piece 1 at 30-SEP-07
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7jit7ec0_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
Finished backup at 30-SEP-07

Starting backup at 30-SEP-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00017 name=/fs-a01-a/databases/yudong/large_idx-01.dbf
input datafile fno=00014 name=/fs-a01-a/databases/yudong/administrator-02.dbf
input datafile fno=00001 name=/fs-a01-b/databases/yudong/system-01.dbf
input datafile fno=00004 name=/fs-a01-a/databases/yudong/administrator-01.dbf
input datafile fno=00006 name=/fs-a01-b/databases/yudong/replication-01.dbf
input datafile fno=00008 name=/fs-a01-a/databases/yudong/precise_or_tab-01.dbf
input datafile fno=00002 name=/fs-a01-a/databases/yudong/undo_t1-01.dbf
input datafile fno=00003 name=/fs-a01-a/databases/yudong/sysaux-01.dbf
input datafile fno=00005 name=/fs-a01-b/databases/yudong/administrator_idx-01.dbf
input datafile fno=00009 name=/fs-a01-b/databases/yudong/system-02.dbf
input datafile fno=00010 name=/fs-a01-a/databases/yudong/large_idx-02.dbf
input datafile fno=00007 name=/fs-a01-a/databases/yudong/replication_idx-01.dbf
input datafile fno=00011 name=/fs-a01-b/databases/yudong/system-03.dbf
input datafile fno=00016 name=/fs-a01-a/databases/yudong/zwf_new.dbf
input datafile fno=00012 name=/fs-a01-a/databases/yudong/large_idx-03.dbf
input datafile fno=00013 name=/fs-a01-a/databases/yudong/sysaux-02.dbf
input datafile fno=00015 name=/fs-a01-a/databases/yudong/zwf.dbf
input datafile fno=00018 name=/fs-a01-a/databases/yudong/zwf_new_new.dbf
input datafile fno=00020 name=/fs-a01-a/databases/yudong/t_zwf.dbf
input datafile fno=00019 name=/fs-a01-a/databases/yudong/zwf_new_new_new.dbf
channel ORA_DISK_1: starting piece 1 at 30-SEP-07
channel ORA_DISK_1: finished piece 1 at 30-SEP-07
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7kit7ec9_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:35
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including standby controlfile in backupset
channel ORA_DISK_1: starting piece 1 at 30-SEP-07
channel ORA_DISK_1: finished piece 1 at 30-SEP-07
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7lit7eh5_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 30-SEP-07

Starting backup at 30-SEP-07
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set


input archive log thread=1 sequence=858 recid=3067

stamp=634632748
channel ORA_DISK_1: starting piece 1 at 30-SEP-07
channel ORA_DISK_1: finished piece 1 at 30-SEP-07
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7mit7ehc_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 30-SEP-07

Starting Control File Autobackup at 30-SEP-07
piece handle=/oracle-backup/db-backup/databases/yudong/c-404134968-20070930-04 comment=NONE
Finished Control File Autobackup at 30-SEP-07

DUPLICATE过程：

RMAN> run{
2> set until sequence=859 thread=1;3> duplicate target database for standby dorecover nofilenamecheck;
4> }

executing command: SET until clause

Starting Duplicate Db at 01-OCT-07
using channel ORA_AUX_DISK_1

contents of Memory Script:
{
set until scn 260723155;
restore clone standby controlfile;
sql clone 'alter database mount standby database';
}
executing Memory Script

executing command: SET until clause

Starting restore at 01-OCT-07
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring controlfile
channel ORA_AUX_DISK_1: restored backup piece 1


piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7lit7eh5_1_1 tag=FULLFORSTANDBY


channel ORA_AUX_DISK_1: restore complete
output filename=/ctl-01/databases/yudong/control.ctl
output filename=/ctl-02/databases/yudong/control.ctl
Finished restore at 01-OCT-07

sql statement: alter database mount standby database

contents of Memory Script:
{
set until scn 260723155;
set newname for datafile 1 to
"/fs-a01-b/databases/yudong/system-01.dbf";
set newname for datafile 2 to
"/fs-a01-a/databases/yudong/undo_t1-01.dbf";
set newname for datafile 3 to
"/fs-a01-a/databases/yudong/sysaux-01.dbf";
set newname for datafile 4 to
"/fs-a01-a/databases/yudong/administrator-01.dbf";
set newname for datafile 5 to
"/fs-a01-b/databases/yudong/administrator_idx-01.dbf";
set newname for datafile 6 to
"/fs-a01-b/databases/yudong/replication-01.dbf";
set newname for datafile 7 to
"/fs-a01-a/databases/yudong/replication_idx-01.dbf";
set newname for datafile 8 to
"/fs-a01-a/databases/yudong/precise_or_tab-01.dbf";
set newname for datafile 9 to
"/fs-a01-b/databases/yudong/system-02.dbf";
set newname for datafile 10 to
"/fs-a01-a/databases/yudong/large_idx-02.dbf";
set newname for datafile 11 to
"/fs-a01-b/databases/yudong/system-03.dbf";
set newname for datafile 12 to
"/fs-a01-a/databases/yudong/large_idx-03.dbf";
set newname for datafile 13 to
"/fs-a01-a/databases/yudong/sysaux-02.dbf";
set newname for datafile 14 to
"/fs-a01-a/databases/yudong/administrator-02.dbf";
set newname for datafile 15 to
"/fs-a01-a/databases/yudong/zwf.dbf";
set newname for datafile 16 to
"/fs-a01-a/databases/yudong/zwf_new.dbf";
set newname for datafile 17 to
"/fs-a01-a/databases/yudong/large_idx-01.dbf";
set newname for datafile 18 to
"/fs-a01-a/databases/yudong/zwf_new_new.dbf";
set newname for datafile 19 to
"/fs-a01-a/databases/yudong/zwf_new_new_new.dbf";
set newname for datafile 20 to
"/fs-a01-a/databases/yudong/t_zwf.dbf";
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 01-OCT-07
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /fs-a01-b/databases/yudong/system-01.dbf
restoring datafile 00002 to /fs-a01-a/databases/yudong/undo_t1-01.dbf
restoring datafile 00003 to /fs-a01-a/databases/yudong/sysaux-01.dbf
restoring datafile 00004 to /fs-a01-a/databases/yudong/administrator-01.dbf
restoring datafile 00005 to /fs-a01-b/databases/yudong/administrator_idx-01.dbf
restoring datafile 00006 to /fs-a01-b/databases/yudong/replication-01.dbf
restoring datafile 00007 to /fs-a01-a/databases/yudong/replication_idx-01.dbf
restoring datafile 00008 to /fs-a01-a/databases/yudong/precise_or_tab-01.dbf
restoring datafile 00009 to /fs-a01-b/databases/yudong/system-02.dbf
restoring datafile 00010 to /fs-a01-a/databases/yudong/large_idx-02.dbf
restoring datafile 00011 to /fs-a01-b/databases/yudong/system-03.dbf
restoring datafile 00012 to /fs-a01-a/databases/yudong/large_idx-03.dbf
restoring datafile 00013 to /fs-a01-a/databases/yudong/sysaux-02.dbf
restoring datafile 00014 to /fs-a01-a/databases/yudong/administrator-02.dbf
restoring datafile 00015 to /fs-a01-a/databases/yudong/zwf.dbf
restoring datafile 00016 to /fs-a01-a/databases/yudong/zwf_new.dbf
restoring datafile 00017 to /fs-a01-a/databases/yudong/large_idx-01.dbf
restoring datafile 00018 to /fs-a01-a/databases/yudong/zwf_new_new.dbf
restoring datafile 00019 to /fs-a01-a/databases/yudong/zwf_new_new_new.dbf
restoring datafile 00020 to /fs-a01-a/databases/yudong/t_zwf.dbf


channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7kit7ec9_1_1 tag=FULLFORSTANDBY
channel ORA_AUX_DISK_1: restore complete
Finished restore at 01-OCT-07

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafilecopy recid=37 stamp=634789706 filename=/fs-a01-b/databases/yudong/system-01.dbf
datafile 2 switched to datafile copy
input datafilecopy recid=38 stamp=634789706 filename=/fs-a01-a/databases/yudong/undo_t1-01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=39 stamp=634789706 filename=/fs-a01-a/databases/yudong/sysaux-01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=40 stamp=634789706 filename=/fs-a01-a/databases/yudong/administrator-01.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=41 stamp=634789706 filename=/fs-a01-b/databases/yudong/administrator_idx-01.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=42 stamp=634789706 filename=/fs-a01-b/databases/yudong/replication-01.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=43 stamp=634789706 filename=/fs-a01-a/databases/yudong/replication_idx-01.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=44 stamp=634789706 filename=/fs-a01-a/databases/yudong/precise_or_tab-01.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=45 stamp=634789706 filename=/fs-a01-b/databases/yudong/system-02.dbf
datafile 10 switched to datafile copy
input datafilecopy recid=46 stamp=634789706 filename=/fs-a01-a/databases/yudong/large_idx-02.dbf
datafile 11 switched to datafile copy
input datafilecopy recid=47 stamp=634789706 filename=/fs-a01-b/databases/yudong/system-03.dbf
datafile 12 switched to datafile copy
input datafilecopy recid=48 stamp=634789707 filename=/fs-a01-a/databases/yudong/large_idx-03.dbf
datafile 13 switched to datafile copy
input datafilecopy recid=49 stamp=634789707 filename=/fs-a01-a/databases/yudong/sysaux-02.dbf
datafile 14 switched to datafile copy
input datafilecopy recid=50 stamp=634789707 filename=/fs-a01-a/databases/yudong/administrator-02.dbf
datafile 15 switched to datafile copy
input datafilecopy recid=51 stamp=634789707 filename=/fs-a01-a/databases/yudong/zwf.dbf
datafile 16 switched to datafile copy
input datafilecopy recid=52 stamp=634789707 filename=/fs-a01-a/databases/yudong/zwf_new.dbf
datafile 17 switched to datafile copy
input datafilecopy recid=53 stamp=634789707 filename=/fs-a01-a/databases/yudong/large_idx-01.dbf
datafile 18 switched to datafile copy
input datafilecopy recid=54 stamp=634789707 filename=/fs-a01-a/databases/yudong/zwf_new_new.dbf
datafile 19 switched to datafile copy
input datafilecopy recid=55 stamp=634789707 filename=/fs-a01-a/databases/yudong/zwf_new_new_new.dbf
datafile 20 switched to datafile copy
input datafilecopy recid=56 stamp=634789707 filename=/fs-a01-a/databases/yudong/t_zwf.dbf

contents of Memory Script:
{
set until scn 260723155;
recover
standby
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 01-OCT-07
using channel ORA_AUX_DISK_1

starting media recovery

channel ORA_AUX_DISK_1: starting archive log restore to default destination
channel ORA_AUX_DISK_1: restoring archive log
archive log thread=1 sequence=858
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/opt/app/oracle/product/10.1.0.4/A04db/dbs/7mit7ehc_1_1 tag=FULLFORSTANDBY
channel ORA_AUX_DISK_1: restore complete
archive log filename=/arch-01/databases/yudong/redolog/-858-1-632058350.arc thread=1 sequence=858
channel clone_default: deleting archive log(s)
archive log filename=/arch-01/databases/yudong/redolog/-858-1-632058350.arc recid=1 stamp=634789708
media recovery complete
Finished recover at 01-OCT-07
Finished Duplicate Db at 01-OCT-07


oracle:weifengz.desktop.amazon.com: /opt/app/oracle> sqlplus "/as sysdba"

SQL*Plus: Release 10.1.0.4.0 - Production on Mon Oct 1 02:31:14 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select process from v$managed_standby;

PROCESS
---------
ARCH
ARCH
RFS

SQL> select sequence#,applied from v$archived_log;

SEQUENCE# APP
---------- ---
858 NO
859 NO
860 NO
861 NO
862 NO
863 NO
864 NO
865 NO
866 NO
867 NO
868 NO

SEQUENCE# APP
---------- ---
869 NO
870 NO
871 NO
872 NO
873 NO
874 NO
875 NO
876 NO
877 NO

20 rows selected.

SQL> recover managed standby database disconnect;
Media recovery complete.
SQL> select process from v$managed_standby;

PROCESS
---------
ARCH
ARCH
RFS
MRP0

SQL> select sequence#,applied from v$archived_log;

SEQUENCE# APP
---------- ---
858 YES
859 YES
860 YES
861 YES
862 YES
863 YES
864 YES
865 NO
866 NO
867 NO
868 NO

SEQUENCE# APP
---------- ---
869 NO
870 NO
871 NO
872 NO
873 NO
874 NO
875 NO
876 NO
877 NO

20 rows selected.

SQL> /

SEQUENCE# APP
---------- ---
858 YES
859 YES
860 YES
861 YES
862 YES
863 YES
864 YES
865 YES
866 YES
867 YES
868 YES

SEQUENCE# APP
---------- ---
869 YES
870 YES
871 YES
872 YES
873 YES
874 YES
875 NO
876 NO
877 NO

20 rows selected.

SQL> /

SEQUENCE# APP
---------- ---
858 YES
859 YES
860 YES
861 YES
862 YES
863 YES
864 YES
865 YES
866 YES
867 YES
868 YES

SEQUENCE# APP
---------- ---
869 YES
870 YES
871 YES
872 YES
873 YES
874 YES
875 YES
876 YES
877 YES

20 rows selected.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/756652/viewspace-242469/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/756652/viewspace-242469/

congnen9588
关注
（第42天）DataGuard 搭建之使用 Duplicate 复制
LuciferLiu_DBA
12-12 91
使用 Duplicate 在线复制的方式无需 RMAN 备份，可以通过 RMAN Duplicate 直接在线从主库拷贝文件。等待 RMAN duplicate 复制完成即可。参数，备库生成参数文件时需要把这个参数删除。至此，ADG 搭建完成，备库可用于报表查询。
Oracle OMF特性导致的DataGuard Duplicate构建备库的Datafiles命名问题
ltc1183705927的博客
01-22 1151
今天凌晨数据库系统做架构变更，构建DataGuard Max Availability主备模式。由于之前已经在自己新构建的测试环境下进行了多次的演练，本以为会在半个小时结束搭建Dg的战斗，支援其它战线。然而..... 事情是这样的。 当我波澜不惊有条不紊的修改完主库pfile文件、备库pfile文件、创建好standb control file、密码文件等一系列准备工作后，执行最关键的一步du
Oracle 11g Dataguard 物理备库配置(一)之Duplicate配置
weixin_33670786的博客
08-16 210
Oracle11gDataguardDuplicate物理备库配置(一)之物理备库创建配置#ver:1.5第五次修改#modify:2013.8.16#author:koummOracle11gDataguard物理备库配置系列文档Oracle11gDataguard物理备库配置(一)之duplicate创建Oracle11gDatagua...
【DG】在Linux平台上搭建单实例的dataguard--duplicate
coco3600的博客
08-28 323
【DG】在Linux平台上搭建单实例的dataguard--duplicate 一 ： 实验环境介绍 *** 鉴于生产环境均采用 64 位系统和数据库软件，本实验也将采用这个标准 **...
使用duplicate创建dataguard
cong20089的专栏
11-12 795
晚上花了很长时间用duplicate创建了一个DG。其实真个过程都是比较容易的，只是自己有些地方因为经常不小心搞错，导致花了比较久，简单记录下：    要注意db_name必须要一样。其中主库是orcl，备库是orcm。主库的listener.ora设置LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (
通过 RMAN DUPLICATE...FROM ACTIVE DATABASE创建dataguard(for oracle 11g)
云计算?
08-06 177
oracle 10g可以通过基于备份的rman DUPLICATE实现dataguard，通过步骤需要对数据库进行备份，并在standby侧进行数据库的恢复。而到了11g，oracle推出了Duplicate From Active Database技术，不需要再对数据库进行rman备份恢复，一切动作都通过网络自动完成。 下面是具体的实现例子： primary db：hrdbprim st...
Oracle 11gR2 dataguard搭建说明 --- duplicate方式.txt
04-09
Oracle 11gR2 dataguard搭建说明
通过duplicate搭建oracle dataguard环境
10-08
#### 四、使用RMAN进行Duplicate操作 接下来是使用RMAN工具来执行Duplicate操作的关键步骤： 1. **启动RMAN命令行工具**：首先，需要通过命令行方式启动RMAN工具。 2. **连接到目标数据库**：使用`CONNECT ...
【12c】DataGuard构建物理备用数据库（DUPLICATE方式）
个人公众号：Alen的数据库学习笔记
04-21 603
1 软件环境 Oracle Linux 6.9 Oracle 12.1.0.2 主库：sz.oracle.com，IP：192.168.1.102 备库：sh.oracle.com，IP：192.168.1.103 2 主数据库配置 2.1 检查并设置数据库 1）首先，主数据库必须处于强制日志（Force Logging）模式下运行，这是要防止主数据库中存在直接的数据修改而不记录日志的...
ORACLE 10G DATAGUARD 配置物理STANDBY 手记
02-22
ORACLE 10G DATAGUARD 配置物理STANDBY 手记
oracle dataguard in-memory,Oracle 11g Dataguard 物理备库配置(一)之Duplicate配置
weixin_42467411的博客
04-04 592
Oracle11gDataguardDuplicate物理备库配置(一)之物理备库创建配置#ver:1.5第五次修改#modify:2013.8.16#author:koummOracle11gDataguard物理备库配置系列文档Oracle11gDataguard配置学习小结说明：本文安装配置了Oracle11gDataguard通过duplicate方式创建...
Oracle dataGuard专题：Rman通过duplicate创建standby
weixin_33866037的博客
08-31 137
rman提供了更便捷的方式来创建standby，方法就是通过duplicate命令，下面做一个详细介绍： 1. 试验环境 [oracle@gaojf orcl]$ sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 6 08:54:45 2006 Copyright (c) 1982, 2005...
Oracle 11g Data Guard 使用duplicate from active database 创建物理DG
kexianmiao的专栏
10-16 2151
直接把原数据库进行复制,11g的RMANduplicate 可以通过Active databaseduplicate和Backup-based duplicate两种方法实现,这里用Activedatabase duplicate这种方式来搭建DG,主库的停机时间很少,只需要重启一下,使参数生效。也可以用这种方法进行DB迁移。DG搭建好，然后把备库激活就可以了,这样整个迁移中宕机时间也比
Data guard 11g 用Duplicate恢复Data Guard 备库详细过程
cuanlielian4510的博客
05-19 177
1、先查找备库控制文件路径 先在备库上找出控制文件的路径，通过和主库一样，不过为了以防万一，还是check为好。 SQL> select name...
oracle 11g dataguard 推荐asm,Oracle 11g Dataguard Duplicate物理备库配置
weixin_39634579的博客
04-03 132
本文采用Oracle 11g Dataguard broker fastfailover测试Oracle 11g Dataguard fast failover配置，需要主备数据库开启闪回功能，闪回功能开启本文略过。闪回开启需要启动到mount状态时，主备库的监听不要随意关闭。1. dgmgrl查看主备库状态$ dgmgrl sys/oracleDGMGRL for Linux: Version ...
Oracle 11gR2 dataguard搭建说明 --- duplicate方式
木苒的博客
09-30 1574
Oracle 11gR2 dataguard 介绍 Oracle 11gR2 dataguard搭建说明 --- rman方式 1.配置参数文件 主库参数文件 dg.__db_cache_size=26709327872 dg.__java_pool_size=134217728 dg.__large_pool_size=134217728 dg.__oracle_base='/o...
duplicate STANDBY时候的dorecover 的疑问？
cuibi2350的博客
06-02 409
想问下DUPLICATESTANDBY时候的dorecover 是什么意思? 还有就是我rman备份数据库的时候，将rman的备份传到备机的时候，主库又生成了些归档，这些对方在 DUPLICATE的时候会被 S...
RMAN-06024: no backup or copy of the control file found to restore
冰刀(skate)
06-26 6375
time: 2008/06/26 author:skaterman在两台主机实现备份,一台是主库,一台是备库,备库和主库是目录完全相同的 ,备库通过resync来实现主备库的数据同步,然后在备库实现rman恢复来实现主备库的数据同步.这两天给新来的dba做培训,发现不能同步,现象与解决步骤如下:在备库:RMAN>  run { 2> allocate channel ch1 t
利用duplicate搭建Oracle DataGuard实例教程
本文档主要介绍了如何利用Oracle DataGuard的duplicate功能在RHEL Linux 7.4（64位）环境中搭建数据库镜像。首先，环境背景设定为两个Oracle 11g R2 (11.2.0.4)数据库，主库和备库的目录、SID（orcl）以及db_unique_...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值