| rman cold backups no catalog [message #614554] |
Fri, 23 May 2014 05:25  |
 |
smac
Messages: 16
Registered: August 2013
|
Junior Member |
|
|
My scenarios is I am taking cold rman backups with archivelogs daily.
I run backup mon/tue/wed and then have a failure I restore database to latest security
rman target /
restore database
recover database until cancel
<CANCEL> ( point I require )
alter database open resetlogs;
I then find we need to go back further to say Mondays cold/archivelog security...at time the cold backup was taken.
what is best way to achieve this ?
rman auxiliary sys/password
duplicate database to <dbname> backup location = '.......' NOREDO;
when I have used duplicate database I have appropriate params set in init.ora file and control files in backup location.
I am concerned at how I get back to previous days security's which then also gives me options to restore further back or if required go to any days security I have on disk.
Is it that once I have auctioned a reset logs the only way I can restore database to OLD backups is to use the duplicate option.
thanks
|
|
|
|
|
|
|
|
|
|
| Re: rman cold backups no catalog [message #614800 is a reply to message #614793] |
Tue, 27 May 2014 07:52  |
 |
Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Quote:I can restore back to any point in time by setting the SCN number and calling a restore database,recover database and as its a cold backup no further action is required, I just open resetlogs from this point.
You can do the same thing with a hot backup and without downtime and decrease in performances: each time you stop the instance you loose what is in the difference caches (buffer, SQL, dictionary...) which has a cost to refill them.
Quote:If I then need to go further back to a previous security I need to first restore the relevant control file
No, you don't need to restore the control file, you can do the same way than in the previous case.
Quote:I can also use TIME or SEQUENCE to recover database to the correct point in time.
UNTIL TIME, UNTIL SEQUENCE or UNTIL SCN, yes.
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
