Re: Recovery question

From: <fitzjarrell_at_cox.net>
Date: 22 May 2007 14:10:32 -0700
Message-ID: <1179868232.859329.24300@q66g2000hsg.googlegroups.com>

On May 22, 12:03 pm, Eugene <epi..._at_gmail.com> wrote:
> 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

We weren't present when you did your 'shutdown immediate' so we don't know if any errors were reported. My GUESS is it didn't shut down cleanly and you still decided to copy files anyway.

You need to start over with this process, ensure your shutdown is error-free, transfer the files properly to your test server (if that's via ftp you need to use binary transport) and try yet again to get this up and running. Also, I'd log everything you do from shutdown to startup so you have a record you can post here if this still isn't working.

David Fitzjarrell Received on Tue May 22 2007 - 16:10:32 CDT