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.

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

Satishbabu Gunukula, Oracle ACE


  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.

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

    cat mario  | geometry dash | run 3

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

  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

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

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

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


  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


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


  11. Before you use a free Windows 7 Ultimate product key from the list below, it’s important to turn off the Windows Updates feature. These keys won’t work if the Windows Update feature is turned on. Your key might be detected as a duplicate windows 10 product key and verification might fail. Follow the steps below to disable automatic Windows Updates.

  12. Whether your house is small or big, in today’s time, every person wants to completely clean their home and cleaning in the shortest possible time.
    Because he has to do many tasks in everyday life. But cleanliness is also an important task.
    best bagless vacuum cleaner in india
    best vacuum cleaner for home under 10000
    top 5 bagged vacuum cleaners
    best vacuum cleaner for home under 5000
    top 10 bagged vacuum cleaners
    best vacuum cleaner in india for home

  13. you will get all the information related to this IPL season 2021 like Who Will Win IPL 2021 Predictions Astrology, Bhavishyavani, Today IPL Match Winner prediction
    The report and the answers to all those questions are coming to your mind. This year was going to give a lot of patience to the people who wanted or waiting for this
    IPL ipl match Prediction
    today ipl toss prediction
    tomorrow ipl match prediction
    ipl prediction