Re: Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?
- From: Andrey Kriushin <Andrey.Kriushin@xxxxxxxx>
- To: Andrey.Kriushin@xxxxxxxx
- Date: Sun, 09 Sep 2007 08:28:21 +0400
Oopps... Some correction:
Andrey Kriushin wrote:
(Assuming you are using rman), set the UNTIL SEQUENCE to the sequence
number of the last log available +1 (or +100) and repeat
restore database;
A little bit inaccurate: when you are using incremental backup feature,
you must have all the logs, created during each incremented backup
applied to the level 0 backup. I.e. the UNTIL clause has an influence on
both commands, i.e. "restore" and "recover". What I've said in the
previous post assumes that there were no incremental backups between +1
and +100th redo log generation time. Otherwise you must be more carefull
when calculating the proper redo log sequence number.
-- Andrey
--
http://www.freelists.org/webpage/oracle-l
- References:
- Hello OCP's.
- From: Patrick O'Brien
- Re: Hello OCP's.
- From: Don Seiler
- Re: Hello OCP's.
- From: fmhabash
- Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?
- From: Jay.Miller
- Re: Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?
- From: Andrey Kriushin
Other related posts:
- » Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?
- » RE: Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?
- » Re: Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?
- » Re: Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?
- » Re: Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?
restore database;
- Hello OCP's.
- From: Patrick O'Brien
- Re: Hello OCP's.
- From: Don Seiler
- Re: Hello OCP's.
- From: fmhabash
- Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?
- From: Jay.Miller
- Re: Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?
- From: Andrey Kriushin