ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 单机Linux平台Oracle 10g DataGuard Physical Standby 搭建实例(3)

单机Linux平台Oracle 10g DataGuard Physical Standby 搭建实例(3)

原创 Linux操作系统 作者:cow977 时间:2011-07-03 16:13:56 0 删除 编辑

单机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博客 ” ,链接:http://blog.itpub.net/81227/viewspace-701231/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-02

  • 博文量
    699
  • 访问量
    755254