This content has been marked as final. Show 6 replies
just a DBA wrote:Rman performs backups according to current incarnation. You can't do L1 based on abandoned L0. Even if you use the same tag, rman will create new L0. But rman can use any backups for restore/recover. Abandoned backups are also subject to the same retension policy.
I want to know how rman will handle backups after resetlogs. For example, I have made first level 0 on 10th and second level 0 on 20th. Each day I perform L1 for both L0. On 23th I performed Point-in-time recovery to 15th. Will rman consider second L0 and all L1 that were made after 15th as obsolete ?
Hi1 person found this helpful
check "RESET DATABASE TO INCARNATION"
after reset logs you are in a new database incarnation.
Hello;1 person found this helpful
Remember what a resetlogs does :
In theory from Oracle 10 on there's no need to perform a full backup after an incomplete recovery, but I always to a full after a database incarnation change. ( do you know anybody who lost data from having too many full backups ? )
Archives the current online redo logs (if they are accessible) and then erases the contents of the online redo logs and resets the log sequence number to 1. Updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp. Creates the online redo log files if they do not currently exist.
Rman performs backups according to current incarnation. You can't do L1 based on abandoned L0. Even if you use the same tag, rman will create new L0. But rman can use any backups for restore/recover. Abandoned backups are also subject to the same retension policy.what are "abandoned backups" ?
1 person found this helpful
what are "abandoned backups" ?Backups made after resetlog scn in non-current incarnation are abandoned. Such L0 backups can't be used for new L1. Backups made before this scn can be used. But mseberg doesn't like them. :)
Good to see you have a sense of humor. I won't say I don't like them, I'm just not sure I'm willing to bet my job on them! With a full backup I sleep better.
To each his own.