If i take a backup on sunday of level0 and monday of level1 if i have to restore database on tues morning.and i issue command restore database ,recover database will it restore full or only have changes from level0.
Printable View
If i take a backup on sunday of level0 and monday of level1 if i have to restore database on tues morning.and i issue command restore database ,recover database will it restore full or only have changes from level0.
Hi,
If your database crashes on Tuesday morning,RMAN will first apply the level 0 backup taken on sunday.Then it will apply the monday level 1 backup(level 1 backup will contain all the changes made between Tuesday and Monday) and then till the time of the database crash RMAN will apply all the archivelog files on the datafiles to bring it to the point of crash.
Regards,
ROhit Nirkhe,Oracle/Apps DBA,OCP 8i
oracle-support@indiatimes.com
I believe you meant "changes between Sunday and Monday"Quote:
Originally posted by rohitsn
(level 1 backup will contain all the changes made between Tuesday and Monday)
Sanjay