Re: Recovery question

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: Tue, 22 May 2007 14:52:37 -0400
Message-ID: <f2ve5n$46b$1@aioe.org>

"Eugene" <epipko_at_gmail.com> wrote in message news:1179853415.591851.173970_at_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

>

Is the requested archived log file dated prior to the backup? Received on Tue May 22 2007 - 13:52:37 CDT