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
Regards,
Satishbabu Gunukula, Oracle ACE
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.
ReplyDeleteThanks for all your information, Website is very nice and informative content.
ReplyDeletecat mario | geometry dash | run 3
free happy wheels at happywheelsdemo.in free total jerkface
ReplyDeletehappywheelsgame.inPlus
Play Free sudoku hearts minesweeper freecell spades yahtzee
freecell Play minesweeper freecell spades Free games
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.
ReplyDelete* Street view
Also receive the error message when trying to restore using RMAN! Thanks for the trick! translate spanish to english
ReplyDeleteUse below command to register.
ReplyDeleteRMAN> catalog start hotmail with '/ora-backup/ORCL/arch-bkp/' noprompt;
Thanks for sharing! It’s very useful! slope
ReplyDelete
ReplyDeleteThank 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
Thank you for sharing information hotmail sign
ReplyDeletejoke on facebook
skin care tips
شركة نقل عفش بالدمام
ReplyDeleteشركة نقل عفش بالطائف
شركة تنظيف خزانات بالمدينة المنورة
I have more useful information from this article. Thanks for sharing.
ReplyDeleteskin care tips
This information is very useful. thank you for sharing. and I will also share information about health through the website
ReplyDeleteCara Menyembuhkan Nyeri Punggung
Pengobatan Alami untuk Tipes
Cara Mengobati Kuku Cantengan
Solusi atasi sakit kepala Vertigo
Cara Menyembuhkan Sakit Maag Kronis
Obat Penghilang Stretch mark
Cara Mengobati Epilepsi
http://www.oracleracexpert.com/2017/01/rman-06023-and-specification-does-not.html
ReplyDeleteBefore 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.
ReplyDeleteThis publication is excellent. Karina
ReplyDelete