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

"Eugene" <epipko (AT) gmail (DOT) com> wrote

Is the requested archived log file dated prior to the backup?

On May 22, 12:03 pm, Eugene <epi... (AT) gmail (DOT) com> wrote:
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