Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
Restore database : problems
Restore database : problems
- cold backup of a database(Oracle 8.1.7) taken 2 weeks ago.
- copied the data and log files to another machine (different from
the backup machine) with different directory structure.
- copied the init.ora file to the restore machine.
- backed up the current control file (from the original database)
with alter database backup controlfile to 'filepath' command.
- moved this control file to the second machine where the database is
being restored.
- Mounted the database.
- Used the alter database rename file to rename data files to point
to new location on the restore machine.
- Trying to recover the database (along with all the archive logs)
using Recover database command.
Problems:
- 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?
- 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 Tue Mar 18 2003 - 15:06:24 CST
Original text of this message