| Distinction between restore & recovery [message #143645] |
Fri, 21 October 2005 06:07  |
rajendran
Messages: 2
Registered: October 2005
|
Junior Member |
|
|
Hi all,
I want to know the distinction between restore & recovery in case of incremental backing up scenario...
in general restore will create/replace the target db datafile with the backed up one from secondary storage...
and recover will make the restored datafiles usable...
If i am taking level 0 incremental backups once in every friday evening & lev 1 inc backups daily..
then if i want to restore & recover to a particular point in time what will restore & recover will do??
|
|
|
|
| Re: Distinction between restore & recovery [message #143651 is a reply to message #143645] |
Fri, 21 October 2005 06:23  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Level 0 --- Every Friday
Level 1 --- daily
So suppose DB failed on Wednesday then you will have backup for
Saturday, Sunday, Monday, Tuesday -- All level 1 backup.
So when RMAN's Restore command will restore
--level 0 first and then applies level 1 ( saturday) , level 1 (sunday) , level 1(monday), level 1(tuesday)
Recover command then
-- apply archivelogs as on wednesday, synchronise checkpoints on the datafiles and make the database ready to work .
[For others: If there is anything else then do let us know ]
|
|
|
|
| Re: Distinction between restore & recovery [message #143677 is a reply to message #143651] |
Fri, 21 October 2005 07:33 |
rajendran
Messages: 2
Registered: October 2005
|
Junior Member |
|
|
thanks for your reply...
it sounds acceptable, but did you see this in any site or book..
do see the below link that specifies recovery uses incremental backup on restored datafiles...
| Quote: |
The concept of datafile media recovery is the application of online or archived redo logs or incremental backups to a restored datafile in order to update it to the current time or some other specified time.
|
http://oraclesvca2.oracle.com/docs/cd/B14117_01/server.101/b10734/rcmconc2.htm#1007756
if this is the case then the restore operation doesn't require those lev 1 incremental backup files right...
and the lev 1 incremental files can be made available only during recovery operation right...
could you please explain on this???
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
