Date - APR 2009
Affected Product & Version - NVBU 8.2.1
Affected Module & Version - Oracle APM 5.5 and 6.0
OS Version - N/A
Application Information - Oracle 9i, 10g, 11g
Symptoms:
Information 2009/04/06 13:42:51 245 Data Plugin rhel47_oracle6_vm2 RMAN-00571: ===========================================================
Information 2009/04/06 13:42:51 245 Data Plugin rhel47_oracle6_vm2 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
Information 2009/04/06 13:42:51 245 Data Plugin rhel47_oracle6_vm2 RMAN-00571: ===========================================================
Information 2009/04/06 13:42:51 245 Data Plugin rhel47_oracle6_vm2 RMAN-03002: failure of restore command at 04/06/2009 13:40:48
Information 2009/04/06 13:42:51 245 Data Plugin rhel47_oracle6_vm2 RMAN-06026: some targets not found - aborting restore
Information 2009/04/06 13:42:51 245 Data Plugin rhel47_oracle6_vm2 RMAN-06023: no backup or copy of datafile 12 found to restore
Information 2009/04/06 13:42:51 245 Data Plugin rhel47_oracle6_vm2 RMAN-06023: no backup or copy of datafile 11 found to restore
Information 2009/04/06 13:42:51 245 Data Plugin rhel47_oracle6_vm2 Recovery Manager complete.
Warning 2009/04/06 13:42:51 245 Data Plugin rhel47_oracle6_vm2 Failed with exit code 1
Error 2009/04/06 13:42:51 245 Data Plugin rhel47_oracle6_vm2 RMAN returned exit code 1
When selecting the whole database node to restore using RMAN, if there have been tablespaces created since the last backup, the restore will fail. You must select the individual tablespaces instead of selecting the whole database node for the restore to succeed, if tablespaces have been added since the last backup. After adding a tablespace you must perform a backup so that there will be a baseline copy of its datafile.
It is also possible to drop the new tablespaces and then do the restore, however you will not be able to recover past where the tablespaces were created. If you do a point in time recovery keep in mind that when you do a PIT recovery of the database, it will require that you reset the logs, which will make RMAN discard all current backups. You will want to do a new full backup after a PIT recovery.
