Re: Recovery database problem

Hope I remember this correctly...

First, you must know if your backups are full offline, full offline plus archive logs, or full online plus archive logs (note that full online without archive logs is useless).

1. Make sure all archive log files, starting with the first from the time of the backup are in the archive directory.
2. Make sure the backup control file script is ready (see below for an example script. For an example of what your original control file looked like, there is some server command you can use to produce this info *if your original control file is intact*).
3. Start svrmgr23 and issue the following commands: SVRMGR> connect internal SVRMGR> startup nomount SVRMGR> @<path_of_create_backup_controlfile_script> SVRMGR> alter database mount; SVRMGR> set autorecovery on SVRMGR> recover database using backup controlfile SVRMGR> alter database open resetlogs;

example control file script for database named P01 with four logfile groups on drives D and E, and data on raid drive H: CREATE CONTROLFILE REUSE DATABASE 'P01' RESETLOGS ARCHIVELOG     MAXLOGFILES 255
    MAXLOGMEMBERS 3
    MAXDATAFILES 254
    MAXINSTANCES 50
    MAXLOGHISTORY 1000
LOGFILE
  GROUP 11 (
    'D:\ORACLE\P01\ORIGLOGA\LOG_TG101_M1.DBF',     'E:\ORACLE\P01\MIRRLOGA\LOG_TG101_M2.DBF'   ) SIZE 20M,
  GROUP 12 (
    'E:\ORACLE\P01\ORIGLOGB\LOG_TG102_M1.DBF',     'D:\ORACLE\P01\MIRRLOGB\LOG_TG102_M2.DBF'   ) SIZE 20M,
  GROUP 13 (
    'D:\ORACLE\P01\ORIGLOGA\LOG_TG103_M1.DBF',     'E:\ORACLE\P01\MIRRLOGA\LOG_TG103_M2.DBF'   ) SIZE 20M,
  GROUP 14 (
    'E:\ORACLE\P01\ORIGLOGB\LOG_TG104_M1.DBF',     'D:\ORACLE\P01\MIRRLOGB\LOG_TG104_M2.DBF'   ) SIZE 20M
DATAFILE
  'H:\ORACLE\P01\DATA1\SYSTEM_1\SYSTEM.DATA1',

	¡P
	¡P
	¡P

On Tue, 10 Aug 1999 01:57:56 GMT, "Kamel Hamard" <hamard_at_iro.umontreal.ca> wrote:

>Hi,
>
>I want to recover a database following to a media failure. I have a backup
>of the database (datafiles, controlfile (binary and text format) and a
>backup of archive log file made with Recovery manager under oracle 8i under
>windows NT.
>
>Any body can help me?
>
>I'm looking on the steps to follow to restore the database on a new host.
>
>For the moment a cant restore the archive log files and the error message
>is as follow:
>
>RMAN> run {
>2> allocate channel c1 type disk
>3> format 'd:\orant\oradata\wcdb\archive';
>4> restore (archivelog all);
>5> }
>
>RMAN-03022: compiling command: allocate
>RMAN-03023: executing command: allocate
>RMAN-08030: allocated channel: c1
>RMAN-08500: channel c1: sid=14 devtype=DISK
>
>RMAN-03022: compiling command: restore
>
>RMAN-03022: compiling command: IRESTORE
>RMAN-06050: archivelog thread 1 sequence 352 is already on disk as file
>D:\ORANT\ORADATA\WCDB\ARCHIVE\%WCDB%T001S00352.A
>RC
>RMAN-03026: error recovery releasing channel resources
>RMAN-08031: released channel: c1
>RMAN-00571: ===========================================================
>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ============
>RMAN-00571: ===========================================================
>RMAN-03002: failure during compilation of command
>RMAN-03013: command type: restore
>RMAN-03002: failure during compilation of command
>RMAN-03013: command type: IRESTORE
>RMAN-06026: some targets not found - aborting restore
>RMAN-06025: no backup of log thread 1 seq 15 scn 205182 found to restore
>RMAN-06025: no backup of log thread 1 seq 14 scn 204484 found to restore
>RMAN-06025: no backup of log thread 1 seq 13 scn 203201 found to restore
>RMAN-06025: no backup of log thread 1 seq 12 scn 181901 found to restore
>
>thanks for any help.
>
>Kamel
>
>
>
>
Received on Tue Aug 10 1999 - 02:34:45 CDT