oracle rac+adg备库恢复报错RMAN-05535和ORA-00349: failure obtaining block size for '+arc

 admin   2024-12-18 14:10   70 人阅读  23 条评论

原因是因为修改的参数文件没有修改好，主库有两路日志文件，参数文件里只修改了一处

报错信息如下

ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+arc
 
RMAN-05535: WARNING: All redo log files were not defined properly.
 
查看备库的日志文件，+arch都是没有转换成功的
MEMBER
----------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/group_2.262.1185146525
+arch
/u01/app/oracle/oradata/orcl/group_1.261.1185146523
+arch
/u01/app/oracle/oradata/orcl/group_3.265.1185146601
+arch
/u01/app/oracle/oradata/orcl/group_4.266.1185146601
+arch
/u01/app/oracle/oradata/orcl/group_11.268.1187995847
+arch
/u01/app/oracle/oradata/orcl/group_12.269.1187995901
+arch
/u01/app/oracle/oradata/orcl/group_13.270.1187995903
+arch
/u01/app/oracle/oradata/orcl/group_14.271.1187995905
+arch
/u01/app/oracle/oradata/orcl/group_15.272.1187995905
+arch
/u01/app/oracle/oradata/orcl/group_21.273.1187995913
+arch
/u01/app/oracle/oradata/orcl/group_22.274.1187995915
+arch
/u01/app/oracle/oradata/orcl/group_23.275.1187995915
+arch
/u01/app/oracle/oradata/orcl/group_24.276.1187995917
+arch
/u01/app/oracle/oradata/orcl/group_25.277.1187995919
+arch
 
查看主库的日志文件，在ARCH磁盘组里的日志组没有转换
SQL> select member from v$logfile;
 
MEMBER
--------------------------------------------------------------------------------
+DATA/rac/onlinelog/group_2.262.1185146525
+ARCH/rac/onlinelog/group_2.258.1185146525
+DATA/rac/onlinelog/group_1.261.1185146523
+ARCH/rac/onlinelog/group_1.257.1185146523
+DATA/rac/onlinelog/group_3.265.1185146601
+ARCH/rac/onlinelog/group_3.259.1185146601
+DATA/rac/onlinelog/group_4.266.1185146601
+ARCH/rac/onlinelog/group_4.260.1185146603
+DATA/rac/onlinelog/group_11.268.1187995847
+ARCH/rac/onlinelog/group_11.276.1187995847
+DATA/rac/onlinelog/group_12.269.1187995901
+ARCH/rac/onlinelog/group_12.277.1187995901
+DATA/rac/onlinelog/group_13.270.1187995903
+ARCH/rac/onlinelog/group_13.278.1187995903
+DATA/rac/onlinelog/group_14.271.1187995905
+ARCH/rac/onlinelog/group_14.279.1187995905
+DATA/rac/onlinelog/group_15.272.1187995905
+ARCH/rac/onlinelog/group_15.280.1187995905
+DATA/rac/onlinelog/group_21.273.1187995913
+ARCH/rac/onlinelog/group_21.281.1187995913
+DATA/rac/onlinelog/group_22.274.1187995915
+ARCH/rac/onlinelog/group_22.282.1187995915
+DATA/rac/onlinelog/group_23.275.1187995915
+ARCH/rac/onlinelog/group_23.283.1187995917
+DATA/rac/onlinelog/group_24.276.1187995917
+ARCH/rac/onlinelog/group_24.284.1187995917
+DATA/rac/onlinelog/group_25.277.1187995919
+ARCH/rac/onlinelog/group_25.285.1187995919
 
28 rows selected.
 
修改备库的参数文件后面加上'+ARCH/rac/onlinelog','/u01/app/oracle/oradata/orcl' 
*.log_file_name_convert='+DATA/rac/onlinelog','/u01/app/oracle/oradata/orcl','+ARCH/rac/onlinelog','/u01/app/oracle/oradata/orcl'
 
重新从参数文件启动备库，然后重新恢复
SQL> startup pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/pfile.ora' nomount;
 
SQL> create spfile from pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/pfile.ora';
 
[oracle@oracleadg:/home/oracle]$rman target sys/oracle@rac auxiliary sys/oracle@orcl
 
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Dec 18 14:08:02 2024
 
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
 
connected to target database: RAC (DBID=2773128535)
connected to auxiliary database: RAC (not mounted)
 
RMAN> duplicate target database for standby from active database nofilenamecheck;
 
本文地址：https://liuchunjie.top/?id=785
版权声明：本文为原创文章，版权归 admin 所有，欢迎分享本文，转载请保留出处！

 发表评论


表情

 评论列表