Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Restore database : problems

Restore database : problems

From: lve <lve3162_at_yahoo.com>
Date: 18 Mar 2003 13:06:24 -0800
Message-ID: <93096888.0303181306.434593f9@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 Tue Mar 18 2003 - 15:06:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US