Thursday, January 19, 2017

RMAN-06023 and Specification does not match any backup

If you come across a situation that you want to use RMAN to restore but there is a backup without using RMAN.

When you try to restore using RMAN you will receive the error message as below
RMAN-06023: no backup or copy of datafile xx found to restore

When you query catalog you will get below message as no backups in repository.

RMAN> LIST BACKUP OF DATABASE;
Specification does not match any backup in the repository

If you want to use the backups taken using HOT backup mode or copy, you must register all data files, archive logs into RMAN catalog.

Use below command to register.
RMAN> catalog start with '/ora-backup/ORCL/arch-bkp/' noprompt;
RMAN> catalog start with '/ora-backup/ORCL/data-bkp/' noprompt;

If your archive logs and data files are in same location then you need to run only once.

Once all backup copies are registered in RAM you can follow below link to restore
 http://www.oracleracexpert.com/2009/11/how-to-restore-database-to-point-in.html

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com


Posted by at
Labels: , , , , , ,

13 comments:

  1. This is one of the great articles you can discover in the net clarifying everything in insight with respect to the theme. I thank you for taking as much time as necessary sharing your considerations and thoughts to a ton of readers out there. visit here.

    ReplyDelete

  2. Thanks for all your information, Website is very nice and informative content.

    cat mario  | geometry dash | run 3

    ReplyDelete

  3. free happy wheels at happywheelsdemo.in free total jerkface
    happywheelsgame.inPlus
    Play Free sudoku hearts minesweeper freecell spades yahtzee
    freecell Play minesweeper freecell spades Free games

    ReplyDelete

  4. I've read all your information that you shares in your article and I really love it. Thank you for sharing this post. I appreciate it.
    * Street view

    ReplyDelete

  5. Also receive the error message when trying to restore using RMAN! Thanks for the trick! translate spanish to english

    ReplyDelete

  6. Use below command to register.
    RMAN> catalog start hotmail with '/ora-backup/ORCL/arch-bkp/' noprompt;

    ReplyDelete

  7. Thanks for sharing! It’s very useful! slope

    ReplyDelete


  8. Thank you for sharing such a informative information with us. Keep on sharing the blog like this.

    PhD Thesis Writing Services, Dissertation Writing Services & Research Paper Writing

    Services

    ReplyDelete

  11. I have more useful information from this article. Thanks for sharing.
    skin care tips

    ReplyDelete

  13. http://www.oracleracexpert.com/2017/01/rman-06023-and-specification-does-not.html

    ReplyDelete

Subscribe to: Post Comments (Atom)