rman备份单个数据文件报错RMAN-08132: WARNING: cannot update recovery area reclaimable file list

逃离我推掉我的手 2022-08-10 13:45 10阅读 0赞

环境：dataguard standby 库 ，两个节点的rac

执行

\[oracle@orclsty2 ~\]$ rman target /  
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Aug 15 15:31:31 2014  
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.  
connected to target database: ORCL (DBID=1381360903)  
RMAN> backup datafile 24;  
Starting backup at 15-AUG-14  
using target database control file instead of recovery catalog  
allocated channel: ORA\_DISK\_1  
channel ORA\_DISK\_1: SID=2133 instance=orcl2 device type=DISK  
channel ORA\_DISK\_1: starting full datafile backup set  
channel ORA\_DISK\_1: specifying datafile(s) in backup set  
input datafile file number=00024 name=+DATADG/orcldg/datafile/test1.307.855674051  
channel ORA\_DISK\_1: starting piece 1 at 15-AUG-14  
channel ORA\_DISK\_1: finished piece 1 at 15-AUG-14  
piece handle=+SYSTEMDG/orcldg/backupset/2014\_08\_15/nnndf0\_tag20140815t153147\_0.455.855675109 tag=TAG20140815T153147 comment=NONE  
channel ORA\_DISK\_1: backup set complete, elapsed time: 00:00:01  
Finished backup at 15-AUG-14  
ORA-00245: control file backup failed; target is likely on a local file system  
RMAN-08132: WARNING: cannot update recovery area reclaimable file list

检查发现这个点击实例只启动到mount状态，打开数据库alter database open;

再次执行备份还是报错，如下错误  
\[oracle@orclsty2 ~\]$ rman target /  
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Aug 15 15:43:22 2014  
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.  
connected to target database: ORCL (DBID=1381360903)  
RMAN> backup datafile 24;  
Starting backup at 15-AUG-14  
using target database control file instead of recovery catalog  
allocated channel: ORA\_DISK\_1  
channel ORA\_DISK\_1: SID=2986 instance=orcl2 device type=DISK  
channel ORA\_DISK\_1: starting full datafile backup set  
channel ORA\_DISK\_1: specifying datafile(s) in backup set  
input datafile file number=00024 name=+DATADG/orcldg/datafile/test1.307.855674051  
channel ORA\_DISK\_1: starting piece 1 at 15-AUG-14  
channel ORA\_DISK\_1: finished piece 1 at 15-AUG-14  
piece handle=+SYSTEMDG/orcldg/backupset/2014\_08\_15/nnndf0\_tag20140815t154332\_0.384.855675813 tag=TAG20140815T154332 comment=NONE  
channel ORA\_DISK\_1: backup set complete, elapsed time: 00:00:01  
Finished backup at 15-AUG-14  
ORA-00604: error occurred at recursive SQL level 1  
ORA-20021: database not set  
RMAN-08132: WARNING: cannot update recovery area reclaimable file list

去rac的另一个节点备份，备份能够成功

于是确定重启有问题的节点

\[oracle@orclsty2 trace\]$ sqlplus "/as sysdba"  
SQL\*Plus: Release 11.2.0.4.0 Production on Fri Aug 15 16:09:11 2014  
Copyright (c) 1982, 2013, Oracle.  All rights reserved.  
Connected to:  
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production  
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,  
Data Mining and Real Application Testing options  
SQL> shutdown immediate  
Database closed.  
Database dismounted.  
ORACLE instance shut down.  
SQL> startup       
ORACLE instance started.  
Total System Global Area 1.5667E+10 bytes  
Fixed Size                  2268632 bytes  
Variable Size            2617246248 bytes  
Database Buffers         1.3019E+10 bytes  
Redo Buffers               28127232 bytes  
Database mounted.  
Database opened.  
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE disconnect from session;  
Database altered.

再次执行备份，备份成功（此问题原因未知）

RMAN> backup datafile 24;  
Starting backup at 15-AUG-14  
using target database control file instead of recovery catalog  
allocated channel: ORA\_DISK\_1  
channel ORA\_DISK\_1: SID=1849 instance=orcl2 device type=DISK  
channel ORA\_DISK\_1: starting full datafile backup set  
channel ORA\_DISK\_1: specifying datafile(s) in backup set  
input datafile file number=00024 name=+DATADG/orcldg/datafile/test1.307.855674051  
channel ORA\_DISK\_1: starting piece 1 at 15-AUG-14  
channel ORA\_DISK\_1: finished piece 1 at 15-AUG-14  
piece handle=+SYSTEMDG/orcldg/backupset/2014\_08\_15/nnndf0\_tag20140815t161150\_0.374.855677511 tag=TAG20140815T161150 comment=NONE  
channel ORA\_DISK\_1: backup set complete, elapsed time: 00:00:01  
Finished backup at 15-AUG-14