RE: RMAN restore without new datafiles

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Mon, 16 Jun 2008 13:34:28 -0400
Message-ID: <667C10D184B2674A82068E06A78382B51F890ACC@AAPQMAILBX01V.proque.st>

Dan,

I think this may cover your scenario?
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen003.htm#sthref1851

--

Mark J. Bobak
Senior Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak_at_proquest.com<mailto:mark.bobak_at_il.proquest.com> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com>

ProQuest...Start here.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Daniel Fink Sent: Monday, June 16, 2008 12:07 PM
To: oracle-l
Subject: RMAN restore without new datafiles

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jun 16 2008 - 12:34:28 CDT