/ Assorted Errors on 11.2.0.2 if cursor sharing is enabled Note 9877980.8
Alert: Note 1472116.1 RMAN backup fails with Assorted Errors on 11.2.0.2 if cursor sharing is enabled
2. Bug 8482162: SNAPSHOT CONTROLFILE STILL NEED NOAC ON NFS MOUNT POINT
如果控制文件自动备份目标文件系统为 NFS，则要求使用“NOAC”选项装载该文件系统；否则将报错 ORA-27054
症状：
如果 snapshot（快照）控制文件定位到 NFS 文件系统并且不是使用选项“NOAC”装载的，则 RMAN 备份将失败，并出现 ORA-27054 错误。根据 Bug 5064356 的修复，如果运行的是 10.2.0.4.0 或更高版本，则不再需要 NFS 装载点的 NOAC 选项。但是，此修复似乎仅适用于特定文件类型，也就是：联机重做日志、归档重做日志、备份片（例如：RMAN）和跟踪文件。
?
Starting Control File and SPFILE Autobackup at 07-APR-12
RMAN-571: ===========================================================
RMAN-569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-571: ===========================================================
RMAN-3009: failure of Control File and SPFILE Autobackup command on
ORA_DISK_1 channel at 04/07/2012 10:29:17
ORA-1580: error creating control backup file
/oracle/product/10.2.0/db_1/dbs/snapcf_COPA1.f
ORA-27054: NFS file system where the file is created or resides is not
mounted with correct options
Additional information: 3
在 alert.log 文件中
Starting control autobackup
WARNING:NFS file system /oracle/product mounted with incorrect options
WARNING:Expected NFS mount options:
rsize>=32768,wsize>=32768,hard, actimeo=0
Autobackup failed with following error
ORA-1580: error creating control backup file
/oracle/product/10.2.0/db_1/dbs/snapcf_COPA1.f
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
出现此问题是因为 Bug 8482162: SNAPSHOT CONTROLFILE STILL NEED NOAC ON NFS MOUNT POINT. 此 Bug 已在 11.2.0.2 中修复
Workaround:
1) 对于保存snapshot（快照）控制文件的 NFS 文件系统，使用 NOAC 选项装载。
或者
2) 将 snapshot（快照）控制文件的位置更改到非 NFS。
Ref: Bug 8482162 Snapshot controlfile still needs "noac" on NFS mount points (ORA-27054) Note 8482162.8
3. Bug 9577583: FALSE ORA-942 OR OTHER ERRORS WITH MULTIPLE SCHEMAS HAVING IDENTICAL OBJECTS
当 RMAN 目录数据库（catalog）保存了多个 RMAN 目录 schema（方案）时，目录数据库上将提醒出现错误 ORA-00942。
症状：
用户发现多个 ORA-942 错误
任何在多个 schema（方案）下有同名对象的数据库都可能会遇到此问题。
这是间歇性问题，无法重现，但会多次出现。
这是通用的 Bug，主要影响 RMAN 目录备份。影响 11.2.0.1，在 11.2.0.2 中已提供了修复。?
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script incremental_level0
RMAN-03002: failure of backup command at 06/25/2010 13:21:22
RMAN-06004: ORACLE error from recovery catalog database: ORA-00942: table or view does not exist
RMAN-06031: could not translate database keyword
Debug跟踪信息显示
DBGSQL: EXEC SQL AT RCVCAT begin dbms_rcvman . translateDatabase ; end ; [13:21:22.794]
DBGSQL: sqlcode=-942 [13:21:22.795]
DBGMISC: krmksqlerror called from file krmk.c, line 12649 [13:21:22.796]
DBGRCVMAN: ENTERING translateDatabase
DBGRCVMAN: ENTERING validateState
DBGRCVMAN: EXITING validateState validateState
DBGRCVMAN: OPENING cursor translateDatabase_c in translateDatabase
DBGMISC: krmicomp: error 6004 signalled during compilation [13:21:22.797]
DBGMISC: ENTERED krmkmrsr [13:21:22.797]
RMAN-06004: ORACLE error from recovery catalog database: ORA-00942: table or view does not exist
ORA-06512: at "CALYPP.DBMS_RCVMAN", line 4590
ORA-06512: at "CALYPP.DBMS_RCVMAN", line 16168
ORA-06512: at line 1
RMAN-0609