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