Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

question on RMAN incremental backup 1

Status
Not open for further replies.

maswien

Technical User
Sep 24, 2003
1,286
CA

I backuped the database using level 0 incremental and level 1 incremental, then I wanted to restore it, but the rman doesn't pick up the latest change which I believe included in the level 1 incremental.

What I missed? Thanks

 
Are you certain you did both a "restore" and a "recover"? The rman restore command will replace datafiles using the level 0 backup. In order to get changes that happened after the level 0 backup, you have to perform a forward recovery.
 
Thanks Karluk,

Yes, u r right. I ahve to use "recover database noredo" within the restore script.

One more question about the restore, since I want manage the backups from RMAN, so I want run following cmd in RMAN:

delete obsolete

The retention policy is set to redundency 1, so I expected the latest level0 backup set won't be touched and the previous backupset will be deleted. But the thing is the control file backup for the latest backupset was deleted as well. I don't know why.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top