I only know that I got that line from Oracle Support. You had to open your
database in mount state before restoring the datafiles. The database uses
the controlfile it has, not the backed up directory. Maybe this is why you
have to state 'using backup controlfile'. All I know is, doing this
We are trying to recover a database to another server.
The backup was a hot backup. The files are all copied to the new server,
along with the archive log that was created a few seconds after the hot
backup was run. We bring the database up and apply the archive log and
Oracle says recovery
Title: RE: Please help! Recover a database on another server
sometimes the error message is a little strange...
when it comes back 'media recovery complete' you can usually just do a 'alter database open;' command and not worry about resetting the logs. If you backed up the controlfiles
Ron,
Make sure you have atleast applied the archive logs between
Archive old log sequence number before start of hot backup and
Archive current log sequence number after end of hot backup.
It may not need all of them but you need the last one for incomplete
recovery..
Mohammed Ahsanuddin
Ron,
The backup was a hot backup. The files are all copied to the
new server,
along with the archive log that was created a few seconds
after the hot
backup was run. We bring the database up and apply the
archive log and
Oracle says recovery complete. We then do an alter database
Try ' recover database until time '2000/10/24 12:00:00' using backup
controlfile;'
That should eliminate this problem.
Regards,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 24, 2001 12:40 PM
We are trying to recover a
the key is when did you create the backup controlfile?
Try using a backup controlfile as opposed to a copy of the controlfile.
yes, there is a difference.
--- Smith, Ron L. [EMAIL PROTECTED] wrote:
We are trying to recover a database to another server.
The backup was a hot backup. The
why does he need a backup control file? this appears
to be a straightforward case of moving databases(i
mean restoring to a new host). does not look like they
have done structural changes or things like that.
ron do you use rman? if not then someone earlier
suggested taking the datafiles off
The control file was backed up the same time the data files were backed up.
The control file from the backup
is what we are using.
Ron
-Original Message-
Sent: Wednesday, October 24, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
the key is when did you create the backup
Are you sure, if you don't state 'using backup controlfile' it will use the
control file you usd to startup the database.
Just a thot,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 24, 2001 3:46 PM
The control file was
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Please help! Recover a database on another server
Are you sure, if you don't state 'using backup controlfile' it will use
the
control file you usd to startup the database.
Just a thot,
Ruth
- Original Message
Aren't they the same? If I restore the control file from the backup. There
was no control file on the server
before I did the restore.
Ron
-Original Message-
Sent: Wednesday, October 24, 2001 3:06 PM
To: Multiple recipients of list ORACLE-L
Are you sure, if you don't state 'using
it depends on how you created the control file that was on the backup.
If you just copied the control file from disk, that would explain your
problem.
If you did a alter system backup controlfile to file and then
backed that one up and moved it to the other server and then did a
recover
especially if you are restoring to a new server then
typically i would issue rman -- restore controlfile
which would get the backup from tape
--- Smith, Ron L. [EMAIL PROTECTED] wrote:
Aren't they the same? If I restore the control file
from the backup. There
was no control file on the
14 matches
Mail list logo