單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(3)

單機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