Recovery question

From: Eugene <epipko_at_gmail.com>
Date: 22 May 2007 10:03:35 -0700
Message-ID: <1179853415.591851.173970@n15g2000prd.googlegroups.com>

Hi all,
I am running Oracle 8.1.6.3 on WinNT and trying to recreate test d/b from prod.
First, I ran alter database backup control file to trace; Second, I shutdown immediate prod d/b and copied all datafiles, redo, arch files to test server.
Third I modified .trc file to look like bellow and saved it to c: \temp:

---

STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "MIRANDA" RESETLOGS NOARCHIVELOG     MAXLOGFILES 32
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 339
LOGFILE
  GROUP 1 (
    'E:\ORACLE\MWT1\REDO\PKMS_REDO_1_01.LOG',     'F:\ORACLE\MWT1\REDO\PKMS_REDO_2_01.LOG'   ) SIZE 100M
 ,GROUP 2 (
    'E:\ORACLE\MWT1\REDO\PKMS_REDO_1_02.LOG',     'F:\ORACLE\MWT1\REDO\PKMS_REDO_2_02.LOG'   ) SIZE 100M

............................

DATAFILE
'E:\ORACLE\MWT1\DATA\PKMS_SYSTEM_01.DBF',
'E:\ORACLE\MWT1\DATA\PKMS_RBS1_04.ORA',
'E:\ORACLE\MWT1\DATA\PKMS_USER_DATA_01.DBF',
'E:\ORACLE\MWT1\DATA\PKMS_TEMP_01.DBF',
'F:\ORACLE\MWT1\DATA\PKMS_PKMSDATA_01.DBF',

.........................................

CHARACTER SET WE8ISO8859P1;
RECOVER DATABASE USING BACKUP CONTROLFILE ALTER DATABASE OPEN RESETLOGS;

---

Then I do the following:

c:\>set oracle_sid=mwt1
c:\>svrmgrl

SVRMGR>connect internal
SVRMGR>startup nomount;
SVRMGR>@c:\temp\test_ctl.sql;

Here I am getting:
ORA-00279 change xxxxxx generated on xxxxxx needed for thread 1 ORA-00289 suggestion: [here it gives me a number of archive log that I don't have]
I type Cancel and get:
ORA-01113 file 1 needs media recovery
ORA-01110 datafle 1 xxxxxxx

What did I do wrong?
Thanks,
Eugene Received on Tue May 22 2007 - 12:03:35 CDT