| Recovery from Previous Backups(RMAN) [message #429040] |
Sun, 01 November 2009 10:09  |
chetanaZ
Messages: 46
Registered: October 2009
Location: UK |
Member |
|
|
Hi,
I am taking RMAN hot backups every night with redundancy level 2
Now I want to recover backup which was taken to 2 days back
for example-> On 25 I have rman backups taken on 23rd and 24th evening
on 25th I want to recover backup that was taken on 23rd
How can I restore that backup?
Do I need to use
'recover database until SCN'?
Do i need to restore controlfile too with 'until SCN' in both of following cases?
1) File structure was changed after rman backup on 23rd evening
2) File structure was Not changed after rman backup on 23rd evening
How I can get the particular SCN?
I issued 'list Backup' command but not sure whether and how to use the output for above purpose
Thanks and Regards,
Chetana
|
|
|
|
| Re: Recovery from Previous Backups(RMAN) [message #429180 is a reply to message #429040] |
Mon, 02 November 2009 07:55  |
chetanaZ
Messages: 46
Registered: October 2009
Location: UK |
Member |
|
|
Ebrian,
Many thanks for the reply.
The link is specific to 10g moreover my case differs in following points
1) There is no Incarnation refrence I need in case below
2) I do not have access to database from whose backups, I will clone database on another server
My question is simple
I have complete RMAN backup of database db1 taken at 21:00 on 23/11/09
I have complete RMAN backup of database db1 taken at 21:00 on 24/11/09
These backups are stored on /shared_drive_backup which can be accessed from another server where we want to clone db1
Now On 25/11/09 I want restore and recover database as db1 till 12:00:00 of 24/11/09
It is obvisous that I will need to restore backup taken at 21:00 of 23/11/09 and apply archive logs till 12:00 of 24/11/09 over it
Since by default RMAN takes latest backup to restore (in our case 21:00 of 24/11/09), How do I tell it to take previous backup to restore (i.e. 21:00 of 23/11/09)
Thanks and Regards,
Chetana
|
|
|
| Re: Recovery from Previous Backups(RMAN) [message #429181 is a reply to message #429180] |
Mon, 02 November 2009 08:01 |
Michel Cadot
Messages: 29416
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Quote:Since by default RMAN takes latest backup to restore (in our case 21:00 of 24/11/09), How do I tell it to take previous backup to restore (i.e. 21:00 of 23/11/09)
Uncatalog the next one.
Or use UNTIL on the RESTORE command.
Regards
Michel
[Updated on: Mon, 02 November 2009 08:02]
|
|
|
| Re: Recovery from Previous Backups(RMAN) [message #429182 is a reply to message #429180] |
Mon, 02 November 2009 08:05 |
Michel Cadot
Messages: 29416
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
By the way, it is an answer I already gave you in a previous topic:
chetanaZ wrote on Tue, 20 October 2009 10:16...
Thus 'Set Until' must not matter for 'Restore' but for 'Recover' since we can rollback hours of data during recover after completing restore till 17:05:00
...
Michel Cadot wrote on Tue, 20 October 2009 10:50It matters on restore if you want to restore datafiles from a date before the last backup. In your example, if you want to recover at 16:05 you have to give UNTIL before restore to tell Oracle to search for previous backup otherwise it will take the last one which is too late.
Regards
Michel
|
|
|
| Re: Recovery from Previous Backups(RMAN) [message #429193 is a reply to message #429040] |
Mon, 02 November 2009 08:29 |
chetanaZ
Messages: 46
Registered: October 2009
Location: UK |
Member |
|
|
Thanks Michel
For your first reply today :
Unfortunately I am not using 'Recovery Catalog'
Your Second answer exactly satisfies my requirement. Thanks
(donno i could not catch it from last thread)
I assume I will execute following in my case
<copy backup of controlfile taken using
alter database backup controlfile to trace
<after startup nomount>
SQL> alter session set nls_date_format='dd-mm-yyyy hh24:mi:ss';
SQL> restore database till '24-11-2009 12:00:00';
SQL> recover automatic DATABASE until time '24-11-2009
12:00:00'USING BACKUP CONTROLFILE;
This if this looks OK. I have 2 queries
Apart from the controlfile backup taken using 'alter database', I do have rman backup of controlfile as well
1) Do i need to restore controlfile too using condition 'until time' in any of the cases
a) datafile structure is changed after backup on 23/11/09 finished at say 03:00:00 of 24/11/09
b) datafile structure is Not changed after backup on 23/11/09 finished at say 03:00:00 of 24/11/09
Can SCN be used in this case?how I can get it if I do not have access to source database?
Thanks and Regards,
Chetana
|
|
|
] 
Members
Search
Help
Register
Login
Home
