Rman-06023 no backup of datafile -- when restoring from full backup

[engiri]

Hi All

We have rman full backup (Level 0) of a 7 TB database taken before 3 months and we are in the need of restoring it in a different locaition.

During the backup, we have created one datafile and it is not allowing us to proceed further with below error.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/09/2008 22:17:14
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 2141 found to restore


We are using until scn option -- the scn of the full backup completion time.

We tried adding the datafile with alter database create datafile option too, then also the same is failing.

We have also the following incremental backup available during that backup also we created some more files due to the database growth.

Please suggest the available option to complete the recovery.

We have already restored the controlfile and mounted the database.

Thanks
Giri

[davey23uk]

the file doesnt exist, cant restore what isnt there

[engiri]

Is there an option to skip that file?

If I select the until scn option prior to the creation of the file, the restore asks for the prior full backup which is not available with us.

Please Let me know how to proceed to restore.

Thanks
Venkatagiri

[hrishy]

Hi

Whats the output of
list backup of datafile 2141 summary

regards
Hrishy

[engiri]

Hi

RMAN> list backup of datafile 2141 summary;

RMAN>


No output. Because this file was created after 75% of the completion of the database. I also restored the controlfile which is the scn of the backup completion!.

Thanks
Venkatagiri

[davey23uk]

restore the controlfile used when the backup was taken

[engiri]

I have restored the latest available control file and now the backup is listed.

RMAN> list backup of datafile 2141 summary;



List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Tag
------- -- -- - ----------- --------------- ------- ------- ---
2406874 B 2 A SBT_TAPE 06-NOV-07 1 1 INCREMENTAL_ORACLE_BACKUP

Can I start the restore/recovery with until scn (Upto the backup of this piece) ?

THanks
Venkatagiri

[hrishy]

Hi

Its not the latest controlfile rather the control file which was backed up as part of the full backup when you took it.

see daveys reply

regards
Hrishy

[BV1963]

Do you have all archived logs since datafiles were added?
If this is the case I think you can still recover.

Another possibility is to restore only tablespaces which were not effected by adding datafiles and rebuilding control file.

[davey23uk]

Do you have all archived logs since datafiles were added?
If this is the case I think you can still recover.

Another possibility is to restore only tablespaces which were not effected by adding datafiles and rebuilding control file.

or do the correct thing of restoring the correct control file and doing the restore normally