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
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... Therefore,
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
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
Jay,
It is reasonable to assume that your hot backup is NOT ok ;-)
This is *possibly* because this particular file (or maybe more files to
come) wasn't backed up for a while. Can you look at the timestamp of this
file (and other files) in the backup that you restored? That should give you
a
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
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
Looks like to me you want to put a until cancel on your recover clause.
Or until time or until scn. Tell it to stop at a particular spot
otherwise it expects a full recovery.
-Original Message-
Sent: Thursday, October 25, 2001 4:55 PM
To: Multiple recipients of list ORACLE-L
Jay,
It
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
Sent by: Subject: RE: Unable to rebuild database
from hot backup
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
-Original
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] wrote:
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 SCN... You can
12 matches
Mail list logo
