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

来源：互联网发布：睡眠工作知乎编辑：程序博客网时间：2024/06/07 00:43

RMAN> restore controlfile from '/home/oracle/rmanbak/orcl_inc_03qkjtr5_1_1';Starting restore at 21-OCT-15using channel ORA_DISK_1channel ORA_DISK_1: restoring control fileRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 10/21/2015 22:46:01ORA-19870: error while restoring backup piece /home/oracle/rmanbak/orcl_inc_03qkjtr5_1_1ORA-19504: failed to create file "/u02/oradata/orcl/control01.ctl,/u02/oradata/orcl/control02.ctl"ORA-27040: file create error, unable to create fileLinux-x86_64 Error: 2: No such file or directoryAdditional information: 1RMAN> 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 controlNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------control_file_record_keep_time        integer     7control_files                        string      /u01/app/oracle/oradata/test/c                                                 ontrol01.ctl, /u01/app/oracle/                                                 oradata/test/control02.ctlcontrol_management_pack_access       string      DIAGNOSTIC+TUNING

异常的：

SQL> show parameter control NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------control_file_record_keep_time        integer     7control_files                        string      /u02/oradata/orcl/control01.ct                                                 l,/u02/oradata/orcl/control02.                                                 ctlcontrol_management_pack_access       string      DIAGNOSTIC+TUNINGSQL>

改正之后：

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 mountedORACLE instance shut down.SQL> startup nomount;ORACLE instance started.Total System Global Area  897740800 bytesFixed Size                  2258440 bytesVariable Size             633342456 bytesDatabase Buffers          255852544 bytesRedo Buffers                6287360 bytesSQL> show parameter controlNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------control_file_record_keep_time        integer     7control_files                        string      /u02/oradata/orcl/control01.ct                                                 l, /u02/oradata/orcl/control02                                                 .ctlcontrol_management_pack_access       string      DIAGNOSTIC+TUNINGSQL>

0 0