Dear Gurus,
Another problem is after I created the controlfile with set option. The control files are created but then
system datafile is told to me that it needed recovery. I have shutdown the original databases and took copy of db files.
I run recover database until cancel using backup controlfile ; but it tells me that it needs TEST2T001S02203.ARC archive log file . But there is not such a file...?
How do you clone archive log mode databases ?
I can not do it althogh I go step by step with the documents I find in internet. ?
The things I did is below..
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\YEDEK123\SYSTEM01.DBF'
SVRMGR> recover database until cancel using backup controlfile ;
ORA-00279: change 6210756 generated at 03/12/2002 14:49:18 needed for thread 1
ORA-00289: suggestion : D:\YEDEK123\ARC\TEST2T001S02203.ARC
ORA-00280: change 6210756 for thread 1 is in sequence #2203
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\YEDEK123\SYSTEM01.DBF'
SVRMGR>
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
The degree of normality in a database
is inversely proportional to that of its DBA.
Received on Tue Mar 12 2002 - 08:18:32 CST
