Re: RMAN restore without new datafiles

Mark,

If I am not wrong, starting with 10gR2, when recover tablespace is used, RMAN automatically re-creates (media recovery) the datafiles which has no backup, as long as required archives logs and control file contains the info about those missing datafiles which has no backup. Unfortunately, Dan is on 10gR1.

Regards,

Jaffar

On Mon, Jun 16, 2008 at 10:34 AM, Bobak, Mark <Mark.Bobak_at_proquest.com> wrote:

> 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 <mark.bobak_at_il.proquest.com>
> www.proquest.com
> 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
>
>

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