RE: RMAN backup with KEEP option not restorable
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <dedba@xxxxxxxxxx>
- Date: Wed, 11 Jun 2014 13:05:35 -0400
start and end should be listed tablespace by tablespace in the alert log.
IF that turns out to be the root cause you should be able to specify end
backup on the recovery file(s); none should be able to have fractured blocks
created via RMAN, which reads Oracle database blocks rather than operating
system sectors.
I am a little puzzled by the statement "with RMAN as a full hot backup"
since the term "hot backup" was a synonym for physical backup as long as I
can remember (and it predates RMAN.) If those words appear in some
operations instructions it could well confuse someone into issuing begin
backup commands before moving on to RMAN. That would not be the plan.
Good luck. Please do let us know if you find the root cause; any unexplained
troubles with recovering Oracle tend to make the hair stand up on the back
of my neck.
Were you in fact recovering with RMAN as well?
If you used RMAN to produce images of the files, but then used physical
recovery rather than RMAN to start up a physical standby and were testing to
see that you could open it, then you would need to specify "using backup
controlfile" or a controlfile that was synchronous with the vintage of the
files which it seems unlikely to produce without the database at least
quiesced.
Clearly I am a bit confused about what you are trying to accomplish and the
methods you are using.
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of De DBA
Sent: Wednesday, June 11, 2014 2:36 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: RMAN backup with KEEP option not restorable
(repost due to overquoting)
I should hope not.. this DB is normally backed up with RMAN as a full hot
backup on the AD standby. The live production database has only the control
and spfiles backed up on a daily basis. There is no reason for any part of
it to be in backup mode at any time. If it was, then it should still be in
that mode - I don't have access to it currently but will check. Perhaps a
silly question (never used that feature in 20 years..), is the start/end
backup mode registered in the alert log?
Cheers,
Tony
On 11/06/14 16:23, Chitale, Hemant K wrote:
> Had the SYSTEM tablespace been put in BEGIN BACKUP mode on Friday 6th
> and not taken out of BACKUP mode since then ? Query V$BACKUP.
>
> Hemant K Chitale
>
>
> -----Original Message-----
<snip>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
