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>