Sorry I never got back to people on this (since I got my restore to work
using the standby controlfile I didn't pursue it for a while and then I
forgot to respond until I was cleaning up old messages). The issue was
adding the "until cancel" clause.
Thanks to everyone who suggested it and special
Luckily I have never had this situation in production,
and what I have read also suggests using the ascii
file created from 'BACKUP CONTROLFILE TO TRACE' for
recovery. I just had a little time on my hands and
decided to give it a try. As I stated, I am by no
means an expert in recovery (more lik
Is this recovery method valid? The loss of controlfiles is supposed to be
recovered using the trace file generated from a previous BACKUP CONTROLFILE
TO TRACE, isn't it? At least according to the Oracle8 Backup and Recovery
class it is.
The part that concerns me is that you are recovering using
Tim,
> You can not simply cancel a "recover
> database using backup
> controlfile" since Oracle is expecting you perform a
> complete recovery (
> since your not using the UNTIL CANCEL/TIME/CHANGE )
> and canceling a complete
> recovery leaves the stop SCN in the controlfile at
> infinity... The
Title: RE: Unable to rebuild database from hot backup
My understanding the when you perform a "recover database using backup controlfile", the stop SCN in the controlfile is set to infinity... Therefore, you never "finish" media recovery since you never encounter the stop
maybe the problem was never in the file but in the controlfile in the
backup?
standby assumes that the scn in the datafile header will be out of date
and that you will be recovering up to or past the scn in the standby
controlfile and that that is okay.
--- "Miller, Jay" <[EMAIL PROTECTED]> wro
Title: RE: Unable to rebuild database from hot backup
Hi Jay,
When you perform a "recover database using backup controlfile" you are performing an incomplete recovery... Do a recover database using backup controlfile until cancel... Cancel... Then open resetlogs...
Tim
---
Kanagaraj
[EMAIL PROTECTED]> cc:
Sent by: Subject: RE: Unable to rebuild database
from hot backup
[EM
st ORACLE-L
> Subject: Unable to rebuild database from hot backup
>
>
> Okay, this is weird.
>
> I'm trying to rebuilding my QC database from a hot backup.
> As always, I
> copied all the hot backup files, all the archive logs from
> the period of the
> hot back
Another piece of information:
On the basis of "it couldn't hurt to try" I recopied everything but instead
of using the regular control file I used the standby control file. I then
mounted it in standby mode, issued the recover standby database command,
activated the standby, shutdown, and opened
I think you have to alter the old database backup the control file to trace
file and then use this trace file after modification and editing to open the
new database.
-Original Message-
Sent: Thursday, October 25, 2001 7:05 PM
To: Multiple recipients of list ORACLE-L
Okay, this is weird
ients of list ORACLE-L
> Subject: Unable to rebuild database from hot backup
>
>
> Okay, this is weird.
>
> I'm trying to rebuilding my QC database from a hot backup.
> As always, I
> copied all the hot backup files, all the archive logs from
> the period of th
Okay, this is weird.
I'm trying to rebuilding my QC database from a hot backup. As always, I
copied all the hot backup files, all the archive logs from the period of the
hot backup and the control files.
After doing
recover database using backup controlfile;
I got
SVRMGR> alter database open
13 matches
Mail list logo