单机Linux平台Oracle 10g DataGuard Physical Standby 搭建实例(1):http://space.itpub.net/81227/viewspace-701181
单机Linux平台Oracle 10g DataGuard Physical Standby 搭建实例(2):http://space.itpub.net/81227/viewspace-701198
这一部分讲述standby库的创建。
$ export ORACLE_SID=orcl
$ rman target / auxiliary sys/password@stby
RMAN> duplicate target database for standby;
很简单,通过RMAN同时连接primary库和standby库,一条duplicate命令就可以了。
alert_stby.log:
Fri Jul 1 15:38:50 2011
Successful mount of redo thread 1, with mount id 1283104645
Fri Jul 1 15:38:50 2011
Physical Standby Database mounted.
Completed: alter database mount standby database
Fri Jul 1 15:39:05 2011
Full restore complete of datafile 5 …/fda_data_01.dbf. Elapsed time: 0:00:01
checkpoint is 5791040
last deallocation scn is 2202399
Full restore complete of datafile 9 …/fda_idx_02.dbf. Elapsed time: 0:00:09
checkpoint is 5791040
Fri Jul 1 15:39:22 2011
Full restore complete of datafile 8 …/fda_idx_01.dbf. Elapsed time: 0:00:15
checkpoint is 5791040
last deallocation scn is 2208345
Full restore complete of datafile 6 …/oratext01.dbf. Elapsed time: 0:00:27
checkpoint is 5791040
last deallocation scn is 5624097
Full restore complete of datafile 7 …/fda_data_02.dbf. Elapsed time: 0:00:27
checkpoint is 5791040
last deallocation scn is 2202405
Full restore complete of datafile 4 …/users_01.dbf. Elapsed time: 0:00:18
checkpoint is 5791040
Fri Jul 1 15:39:45 2011
Full restore complete of datafile 2 …/undotbs01.dbf. Elapsed time: 0:00:45
checkpoint is 5791040
last deallocation scn is 5788495
Fri Jul 1 15:40:27 2011
Full restore complete of datafile 3 …/sysaux01.dbf. Elapsed time: 0:01:29
checkpoint is 5791040
last deallocation scn is 5781269
Full restore complete of datafile 1 …/system01.dbf. Elapsed time: 0:01:34
checkpoint is 5791040
last deallocation scn is 4895438
Fri Jul 1 15:40:41 2011
Switch of datafile 1 complete to datafile copy
checkpoint is 5791040
Switch of datafile 2 complete to datafile copy
checkpoint is 5791040
Switch of datafile 3 complete to datafile copy
checkpoint is 5791040
Switch of datafile 4 complete to datafile copy
checkpoint is 5791040
Switch of datafile 5 complete to datafile copy
checkpoint is 5791040
Switch of datafile 6 complete to datafile copy
checkpoint is 5791040
Switch of datafile 7 complete to datafile copy
checkpoint is 5791040
Switch of datafile 8 complete to datafile copy
checkpoint is 5791040
Switch of datafile 9 complete to datafile copy
checkpoint is 5791040
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-701231/ ,如需转载,请注明出处,否则将追究法律责任。