Re: Restore database : problems

About the control-file bit:

> 4) backed up the current control file (from the original database)
> with alter database backup controlfile to 'filepath' command.

So you have a BACKED UP controlfile....

> 2) When I use the recover database command, why I am being asked to
> state 'using backup control file'.

Hmm, now why would Oracle ask that..
Maybe because you are USING a backup control file?

GrtZ,
Victor.

lve3162_at_yahoo.com (lve) wrote in message news:<93096888.0303181306.434593f9_at_posting.google.com>...

> 1) cold backup of a database(Oracle 8.1.7) taken 2 weeks ago.
> 2) copied the data and log files to another machine (different from
> the backup machine) with different directory structure.
> 3) copied the init.ora file to the restore machine.
> 4) backed up the current control file (from the original database)
> with alter database backup controlfile to 'filepath' command.
> 5) moved this control file to the second machine where the database is
> being restored.
> 6) Mounted the database.
> 7) Used the alter database rename file to rename data files to point
> to new location on the restore machine.
> 8) Trying to recover the database (along with all the archive logs)
> using Recover database command.
>
> Problems:
>
> 1) A new datafile was created after the cold backup. The control file
> has the full name which points to directory structure on the old
> (backup) machine. How to create this datafile and restore it?
>
> 2) When I use the recover database command, why I am being asked to
> state 'using backup control file'. I am
> using the latest control file. Does it have something to do with log
> files which I am restoring from
> the original cold backup. What are my options.
Received on Wed Mar 19 2003 - 02:40:35 CST