Re: RMAN restore without new datafiles

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Mon, 16 Jun 2008 10:45:57 -0700
Message-ID: <97b7fd2f0806161045p292b3dddm339266521e7a643b@mail.gmail.com>


How about reading ML : 29430.1

If you were on 10gR2, you would have been more lucky.

Jaffar

On Mon, Jun 16, 2008 at 9:07 AM, Daniel Fink <daniel.fink_at_optimaldba.com> wrote:

> 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
>
>

-- 
Best Regards,

Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA
RAC Certified Expert

Official Oracle RAC SIG Representative for Saudi Arabian region (
http://www.oracleracsig.org/)
http://jaffardba.blogspot.com/
http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:126
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."

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

Original text of this message