You've probably had a problem when you first opened
resetlogs. Fe., setting rollback segments that don't
exist yet. Issue a select over v$log and v$logfile to
determine which is the current redo. Copy that one to
path and with the name of the archive Oracle is
asking. Then issue the recover again and then the
alter database resetlogs.
Regards.
- "Bunyamin K. Karadeniz"
<bunyamink_at_havelsan.com.tr> wrote:
> 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.
>
>
>
>
> ATTACHMENT part 2 image/gif name=dbainblk.gif
Ing. Christian Trassens
Senior DBA & Unix Administrator
Phone: 0034-699240979
0034-649824704
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christian Trassens
INET: ctrassens_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Mar 12 2002 - 09:13:44 CST
