RMAN restore without new datafiles
- From: Daniel Fink <daniel.fink@xxxxxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 16 Jun 2008 10:07:04 -0600
Oracle 10gr1 on AIX.
RMAN backups using Recovery catalog and CommVault
Using a full backup, we are trying to refresh a database on another
server (something done quite frequently without problems).
Unfortunately, the backup we are trying to use has an issue. During the
backup, two datafiles were added to the source database. When we try to
restore the backup, the following error messages are reported and the
restore terminates.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/14/2008 08:09:22
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 76 found to restore
RMAN-06023: no backup or copy of datafile 75 found to restore
select FILE_NAME,RELATIVE_FNO from dba_data_files on PROD, the files are
there:
FILE_NAME RELATIVE_FNO
-----------------------------------------------------------
---------------------------
/db2/oradata/prod/d57.dbf 75
/db2/oradata/prod/d58.dbf 76
The DB_FILE_CONVERT on REG is OK:
db_file_name_convert=("/db2/oradata/prod","/db5/oradata/REG")
log_file_name_convert=(
"/db3/oradata/prod","/db5/oradata/REG",
"/db2/oradata/prod","/db5/oradata/REG"
Time in script MAY 17 2008 02:31:41 same as end time in
CommVault. Verified the STD291 & 292 are the correct media tape no.s
From the Alert Log:
Fri May 16 23:00:06 2008
alter tablespace d add datafile '/db2/oradata/prod/d57.dbf' size 512M
autoextend on next 100M ma
xsize 10G
Fri May 16 23:00:08 2008
Starting control autobackup
Control autobackup written to DISK device
handle '/db1/apps/oracle/admin/prod/udump/c-668007365-20080516-04'
Completed: alter tablespace d add datafile '/db2/oradata/qm
Fri May 16 23:00:43 2008
alter tablespace d add datafile '/db2/oradata/prod/d58.dbf' size 512M
autoextend on next 100M ma
xsize 10G
I've done a quick look at the doc, books and google and I am not finding
a way to exclude specific files from this type of recovery and/or issue
a command before starting the recovery to add the datafiles.
Any help is greatly appreciated.
Regards,
Daniel Fink
--
Daniel Fink
Oracle Performance, Diagnosis, Data Recovery and Training
OptimalDBA http://www.optimaldba.com
Oracle Blog http://optimaldba.blogspot.com
Lost Data? http://www.ora600.nl/introduction.htm
Other related posts:
