RAC节点系统: linux EL 5.3 oracle 10.2.0.4
双节点:racdb1,racdb2;共享数据ASM存储
standby系统:linux EL 5.3 oracle 10.2.0.4
实例名:racdg; exts文件系统
问题:做RMAN备份的主库复制不能正常结束,吊死在RMAN>duplicate database for standby;步骤;
查看复制数据文件全部完成。重做过多次,均停在这个地方。
1、在复制过程中,可以在primary 中可以查到会话RMAN@RACDB;查询到该会话不存在后;
看到停留在duplicate 执行语句步骤,没有正常完成。
2、 手工停止RMAN; shutdown 已经mount standby database ;
3、重复RMAN>duplicate database for standby; skip restore datafile ...
执行到switch clone all;
Finished duplicate
4、alter database managed recover standby database disconnect from session'
alert 告警报如下错误:没有在racdb1建立standby log group 之前。能够在[/oradata2/racdg/onlinelog看到确实有文件恢复了。
但是还是报错:
ALTER DATABASE RECOVER CONTINUE DEFAULT
Wed Aug 12 22:03:38 2009
Media Recovery Log /arch/arch_1_2100_693877541.arc
Errors with log /arch/arch_1_2100_693877541.arc
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Wed Aug 12 22:03:38 2009
ALTER DATABASE RECOVER CANCEL
Signalling error 1152 for datafile 1!
ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL ...
Wed Aug 12 22:05:17 2009
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
Wed Aug 12 22:05:17 2009
Attempt to start background Managed Standby Recovery process (racdg)
MRP0 started with pid=23, OS id=7730
Wed Aug 12 22:05:17 2009
MRP0: Background Managed Standby Recovery process started (racdg)
Managed Standby Recovery not using Real Time Apply
parallel recovery started with 7 processes
Wed Aug 12 22:05:22 2009
Waiting for all non-current ORLs to be archived...
Wed Aug 12 22:05:22 2009
Errors in file /opt/app/oracle/admin/racdg/bdump/racdg_mrp0_7730.trc:
ORA-00313: Message 313 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [/oradata2/racdg/onlinelog/group_1.256.693877541]
ORA-27037: Message 27037 not found; No message file for product=RDBMS, facility=ORA
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [/oradata2/racdg/onlinelog/group_1.284.693877541]
ORA-27037: Message 27037 not found; No message file for product=RDBMS, facility=ORA
Linux Error: 2: No such file or directory5、查看v$logfile中存在各onlinelog文件信息,但是在/oradata2/racdg/onlinelog 中确实不存在。
为什么复制online不成功呀?我在主库建立standby log group后出现这个现象。
-- Connected User is Valid
RFS[3]: Assigned to RFS process 14639
RFS[3]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Primary database is in MAXIMUM PERFORMANCE mode
Fri Aug 14 13:32:43 2009
Errors in file /opt/app/oracle/admin/racdg/udump/racdg_rfs_14639.trc:
ORA-00313: open failed for members of log group 15 of thread 2
ORA-00312: online log 15 thread 2: '/oradata2/racdg/onlinelog/group_15.268.694818713'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 15 thread 2: '/oradata/racdg/onlinelog/group_15.1240.694818711'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Aug 14 13:32:43 2009
Errors in file /opt/app/oracle/admin/racdg/udump/racdg_rfs_14639.trc:
ORA-00313: open failed for members of log group 15 of thread 2
ORA-00312: online log 15 thread 2: '/oradata2/racdg/onlinelog/group_15.268.694818713'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 15 thread 2: '/oradata/racdg/onlinelog/group_15.1240.694818711'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
RFS[3]: Unable to open standby log 15: 313
Fri Aug 14 13:32:43 2009
Errors in file /opt/app/oracle/admin/racdg/udump/racdg_rfs_14639.trc:
ORA-00313: open failed for members of log group 16 of thread 2
ORA-00312: online log 16 thread 2: '/oradata2/racdg/onlinelog/group_16.269.694818717'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 16 thread 2: '/oradata/racdg/onlinelog/group_16.300.694818717'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
双节点:racdb1,racdb2;共享数据ASM存储
standby系统:linux EL 5.3 oracle 10.2.0.4
实例名:racdg; exts文件系统
问题:做RMAN备份的主库复制不能正常结束,吊死在RMAN>duplicate database for standby;步骤;
查看复制数据文件全部完成。重做过多次,均停在这个地方。
1、在复制过程中,可以在primary 中可以查到会话RMAN@RACDB;查询到该会话不存在后;
看到停留在duplicate 执行语句步骤,没有正常完成。
2、 手工停止RMAN; shutdown 已经mount standby database ;
3、重复RMAN>duplicate database for standby; skip restore datafile ...
执行到switch clone all;
Finished duplicate
4、alter database managed recover standby database disconnect from session'
alert 告警报如下错误:没有在racdb1建立standby log group 之前。能够在[/oradata2/racdg/onlinelog看到确实有文件恢复了。
但是还是报错:
ALTER DATABASE RECOVER CONTINUE DEFAULT
Wed Aug 12 22:03:38 2009
Media Recovery Log /arch/arch_1_2100_693877541.arc
Errors with log /arch/arch_1_2100_693877541.arc
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Wed Aug 12 22:03:38 2009
ALTER DATABASE RECOVER CANCEL
Signalling error 1152 for datafile 1!
ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL ...
Wed Aug 12 22:05:17 2009
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
Wed Aug 12 22:05:17 2009
Attempt to start background Managed Standby Recovery process (racdg)
MRP0 started with pid=23, OS id=7730
Wed Aug 12 22:05:17 2009
MRP0: Background Managed Standby Recovery process started (racdg)
Managed Standby Recovery not using Real Time Apply
parallel recovery started with 7 processes
Wed Aug 12 22:05:22 2009
Waiting for all non-current ORLs to be archived...
Wed Aug 12 22:05:22 2009
Errors in file /opt/app/oracle/admin/racdg/bdump/racdg_mrp0_7730.trc:
ORA-00313: Message 313 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [/oradata2/racdg/onlinelog/group_1.256.693877541]
ORA-27037: Message 27037 not found; No message file for product=RDBMS, facility=ORA
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [/oradata2/racdg/onlinelog/group_1.284.693877541]
ORA-27037: Message 27037 not found; No message file for product=RDBMS, facility=ORA
Linux Error: 2: No such file or directory5、查看v$logfile中存在各onlinelog文件信息,但是在/oradata2/racdg/onlinelog 中确实不存在。
为什么复制online不成功呀?我在主库建立standby log group后出现这个现象。
-- Connected User is Valid
RFS[3]: Assigned to RFS process 14639
RFS[3]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Primary database is in MAXIMUM PERFORMANCE mode
Fri Aug 14 13:32:43 2009
Errors in file /opt/app/oracle/admin/racdg/udump/racdg_rfs_14639.trc:
ORA-00313: open failed for members of log group 15 of thread 2
ORA-00312: online log 15 thread 2: '/oradata2/racdg/onlinelog/group_15.268.694818713'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 15 thread 2: '/oradata/racdg/onlinelog/group_15.1240.694818711'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Aug 14 13:32:43 2009
Errors in file /opt/app/oracle/admin/racdg/udump/racdg_rfs_14639.trc:
ORA-00313: open failed for members of log group 15 of thread 2
ORA-00312: online log 15 thread 2: '/oradata2/racdg/onlinelog/group_15.268.694818713'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 15 thread 2: '/oradata/racdg/onlinelog/group_15.1240.694818711'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
RFS[3]: Unable to open standby log 15: 313
Fri Aug 14 13:32:43 2009
Errors in file /opt/app/oracle/admin/racdg/udump/racdg_rfs_14639.trc:
ORA-00313: open failed for members of log group 16 of thread 2
ORA-00312: online log 16 thread 2: '/oradata2/racdg/onlinelog/group_16.269.694818717'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 16 thread 2: '/oradata/racdg/onlinelog/group_16.300.694818717'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
解决方案 »
- ORA-12514:TNS:无法解析指定的连接标识符(怎么解决)
- oracle提示找不到表
- 一个关于序列参数的问题
- 我想知道:使用索引有什么好处????????/
- 如何让一个存储过程像在sql server中那样返回一个结果集,谢谢帮助,在线等.....
- 在oralce中如何一次性清除重复记录(重复记录仅保留一条),而且效率较高!谢谢指教!
- OracleOraHome81ManagementServer 总是启动失败了
- 高分求助
- ASP通过Microsoft ODBC连接Oracle数据库如何使用连接池?
- 宝贝女儿出生!!(散分)
- 跪求有关财务科目记账的触发器写法
- regexp_like用法有点儿问题
后来,发现onlinelog目录下已经复制过来了。但是再查v$logfile
却没有发现standby 类型的日志文件,这是怎么回事?如果不去管他?不能应用redo日志呀?
也不能
alter database recover managed standby database disconnect from session;接下来我怎么转逻辑Dataguard呢?
如何clear log 呢?我在select * from v$log
发现log的状态clearing 和clearing current 是不是表明已经clear standby log呢?
recreate standby log怎么做?是不是在standby 将报错的那几个文件(都是standby log)
增加呢?
alter database add standby logfile group 15 (
'/oradata2/racdg/onlinelog/group_15.268.694818713',
'/oradata/racdg/onlinelog/group_15.1240.694818711') size 50M;谢谢!