一次控制文件参数设置错误导致的restore controlfile 失败。

最新推荐文章于 2022-07-02 15:21:31 发布

msdnchina

最新推荐文章于 2022-07-02 15:21:31 发布

阅读量2.8k

点赞数

分类专栏： Oracle DB

本文链接：https://blog.csdn.net/msdnchina/article/details/49443693

版权

Oracle DB 专栏收录该内容

773 篇文章 3 订阅

订阅专栏

RMAN> restore controlfile from '/home/oracle/rmanbak/orcl_inc_03qkjtr5_1_1';

Starting restore at 21-OCT-15
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/21/2015 22:46:01
ORA-19870: error while restoring backup piece /home/oracle/rmanbak/orcl_inc_03qkjtr5_1_1
ORA-19504: failed to create file "/u02/oradata/orcl/control01.ctl,/u02/oradata/orcl/control02.ctl"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1

RMAN> exit

从spfile生成的pfile中看，正常情况（其他db的pfile）：

*.control_files='/u01/app/oracle/oradata/test/control01.ctl','/u01/app/oracle/oradata/test/control02.ctl'

错误的pfile的内容：

*.control_files='/u02/oradata/orcl/control01.ctl,/u02/oradata/orcl/control02.ctl'

show parameter control看不出差异，其实还是有一点差异的（,后边的空格）

正常的：

SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      /u01/app/oracle/oradata/test/c
                                                 ontrol01.ctl, /u01/app/oracle/
                                                 oradata/test/control02.ctl
control_management_pack_access       string      DIAGNOSTIC+TUNING

异常的：

SQL> show parameter control 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      /u02/oradata/orcl/control01.ct
                                                 l,/u02/oradata/orcl/control02.
                                                 ctl
control_management_pack_access       string      DIAGNOSTIC+TUNING
SQL>

改正之后：

SQL> alter system set control_files='/u02/oradata/orcl/control01.ctl','/u02/oradata/orcl/control02.ctl' scope=spfile;

System altered.

SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area  897740800 bytes
Fixed Size                  2258440 bytes
Variable Size             633342456 bytes
Database Buffers          255852544 bytes
Redo Buffers                6287360 bytes
SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      /u02/oradata/orcl/control01.ct
                                                 l, /u02/oradata/orcl/control02
                                                 .ctl
control_management_pack_access       string      DIAGNOSTIC+TUNING
SQL>