ITPub博客

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

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

原创 Linux操作系统 作者:cow977 时间:2011-07-04 12:12:28 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

单机Linux平台Oracle 10g DataGuard Physical Standby 搭建实例(3)http://space.itpub.net/81227/viewspace-701231

 

这一部分讲述备库启动

 

1. 复制结束后的Standby只启动到mount standby的状态。并没有启动MRP的应用归档程序。 所以这个时候查询主备库,归档是不同步的。需要手动的启动MRP进程。

SQL> alter database recover managed standby database disconnect from session;

2. 备库Online Redo Log问题

由于RMAN duplicate命令不会在从Primary数据库复制文件时复制Online Redologs,因此物理Standby数据库在第一次启动REDO应用时,会在Alert文件中报Online Redo Logfile文件不存在,没有关系,物理Standby会自动重建这批文件,同时也不用担心会丢失数据,Online Redologs中的数据会以归档文件的形式从Primary端接收。

alert_stby.log:

Fri Jul  1 15:43:47 2011

alter database recover managed standby database disconnect from session

Fri Jul  1 15:43:47 2011

Attempt to start background Managed Standby Recovery process (stby)

MRP0 started with pid=16, OS id=30427

Fri Jul  1 15:43:47 2011

MRP0: Background Managed Standby Recovery process started (stby)

Managed Standby Recovery not using Real Time Apply

 parallel recovery started with 3 processes

Fri Jul  1 15:43:52 2011

Waiting for all non-current ORLs to be archived...

Fri Jul  1 15:43:52 2011

Errors in file …/bdump/stby_mrp0_30427.trc:

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: '…/stby/redo01.log'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

Clearing online redo logfile 1 …/stby/redo01.log

Clearing online log 1 of thread 1 sequence number 37

Fri Jul  1 15:43:55 2011

Clearing online redo logfile 1 complete

Fri Jul  1 15:43:55 2011

Errors in file …/bdump/stby_mrp0_30427.trc:

ORA-00313: open failed for members of log group 2 of thread 1

ORA-00312: online log 2 thread 1: '…/stby/redo02.log'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

Clearing online redo logfile 2 …/stby/redo02.log

Clearing online log 2 of thread 1 sequence number 38

Clearing online redo logfile 2 complete

Fri Jul  1 15:43:58 2011

Errors in file …/bdump/stby_mrp0_30427.trc:

ORA-00313: open failed for members of log group 3 of thread 1

ORA-00312: online log 3 thread 1: '…/stby/redo03.log'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

Clearing online redo logfile 3 …/stby/redo03.log

Clearing online log 3 of thread 1 sequence number 39

Clearing online redo logfile 3 complete

 

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

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

注册时间:2011-03-02

  • 博文量
    699
  • 访问量
    755116