Rman-06023 no backup of datafile -- when restoring from full backup
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

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

Hybrid View

  1. #1
    Join Date
    Apr 2003
    Posts
    353

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

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    the file doesnt exist, cant restore what isnt there

  3. #3
    Join Date
    Apr 2003
    Posts
    353
    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

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Whats the output of
    list backup of datafile 2141 summary

    regards
    Hrishy

  5. #5
    Join Date
    Apr 2003
    Posts
    353
    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

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    restore the controlfile used when the backup was taken

  7. #7
    Join Date
    Apr 2003
    Posts
    353
    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

  8. #8
    Join Date
    Jan 2001
    Posts
    2,828
    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

  9. #9
    Join Date
    Nov 2001
    Posts
    335
    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.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by 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.
    or do the correct thing of restoring the correct control file and doing the restore normally

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width