ini dari metalink
Subject: Cant open database after RECOVER DATABASE
RDBMS Version: 9I
Operating System and Version: Windows XP SP1
Error Number (if applicable): ORA-01589
Product (i.e. SQL*Loader, Import, etc.):
Product Version: 9.2.0
Cant open database after RECOVER DATABASE
Hereby the message I get after startup;
SQL> startup force;
ORACLE instance started.
Total System Global Area 85006980 bytes
Fixed Size 453252 bytes
Variable Size 79691776 bytes
Database Buffers 4194304 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
When I try to recover
SQL> recover database using backup controlfile;
ORA-00279: change 2107422 generated at 06/15/2005 15:22:13 needed for thread
1
ORA-00289: suggestion : C:\ORACLE\ORA9\RDBMS\ARC00245.001
ORA-00280: change 2107422 for thread 1 is in sequence #245
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log 'C:\ORACLE\ORA9\RDBMS\ARC00245.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
This is my V$LOG table;
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 245 104857600 1 NO CURRENT
2107421 15-JUN-05
2 1 243 104857600 1 NO INACTIVE
2067414 15-JUN-05
3 1 244 104857600 1 NO INACTIVE
2087417 15-JUN-05
Please help what should I do to make the database run again.
Thanks
Jim
----------------------------------------------------------------------------
----
From: yong sou 16-Jun-05 15:08
Subject: Re : Cant open database after RECOVER DATABASE
try this:
SQL> shutdown immedaite
SQL> startup mount
SQL> recover database using backup controlfile;
when you see errors:
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log 'C:\ORACLE\ORA9\RDBMS\ARC00245.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
type CANCEL
SQL> alter database open resetlogs;
Note: you may lose un-archived transactions in redolog.
----------------------------------------------------------------------------
----
From: Jim Bon 16-Jun-05 21:00
Subject: Re : Re : Cant open database after RECOVER DATABASE
Thanks for the reply but it did not help :-((
Hereby some more info hope you can help;
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\BON9\SYSTEM01.DBF'
SQL> recover datafile 'C:\ORACLE\ORADATA\BON9\SYSTEM01.DBF';
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination C:\oracle\ora9\RDBMS
Oldest online log sequence 243
Current log sequence 245
Thanks
----------------------------------------------------------------------------
----
From: Jeanine Cooke 17-Jun-05 16:11
Subject: Re : Cant open database after RECOVER DATABASE
Jim,
Your database needs the contents of redo group 1 for recovery as indicated
by :
ORA-00279: change 2107422 generated at 06/15/2005 15:22:13 needed for thread
1
ORA-00289: suggestion : C:\ORACLE\ORA9\RDBMS\ARC00245.001
ORA-00280: change 2107422 for thread 1 is in sequence #245
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Which is saying it needs change sequence #245. From your v$log query you
know that group 1 is current, and contains sequence #245. You need to apply
that redo log. Either 1) at the "Specify log" prompt, enter the path / file
name for a redo group 1 file, or 2) copy the redo group 1 file to
c:\oracle\ora9\rdbms\arc00245.001, then just hit <return> at the "Specify
log" prompt.
Since you know that is your most current redo information, there is nothing
else to apply. After applying that one log, enter CANCEL at the "Specify
log" prompt. After you cancel, do your ALTER DATABASE OPEN RESETLOGS;
smoga membantu
salam,
Irawan
----- Original Message -----
From: "massri" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Saturday, July 30, 2005 12:03 PM
Subject: [indo-oracle] Urgent: Open database error after recover
> Hi rekans,
>
> mohon pencerahan,
>
> kemarin saya coba pindahkan lokasi datafile seperti panduan pada thread yg
sebelumnya,
>
> tetapi pada saat startup database memberikan pesan error seperti dibawah
ini
>
> SQL> startup
> ORACLE instance started.
> Total System Global Area 219223120 bytes
> Fixed Size 451664 bytes
> Variable Size 201326592 bytes
> Database Buffers 16777216 bytes
> Redo Buffers 667648 bytes
> Database mounted.
> ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
>
> SQL>
>
> kemudian yang saya coba lakukan
>
> SQL> Recover database using backup controlfile;
> ORA-00279: change 18554358603 generated at 07/29/2005 20:28:42 needed for
thread 1
> ORA-00289: suggestion : /oracle/app/product/9.2.0.4/dbs/arch1_13.dbf
> ORA-00280: change 18554358603 for thread 1 is in sequence #13
>
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
>
> CANCEl
> Media recovery cancelled.
> SQL> alter database open resetlogs
> 2 ;
> alter database open resetlogs
> *
> ERROR at line 1:
> ORA-01113: file 1 needs media recovery
> ORA-01110: data file 1: '/oracle/app/product/oradata/RADGINE/system01.dbf'
>
> SQL>
>
> Gimana ya, cara supaya database bisa di open lagi
>
> Best regards
>
>
>
>
>
> ---------------------------------
> Start your day with Yahoo! - make it your home page
>
> [Non-text portions of this message have been removed]
>
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.lizt.org (NEW)
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
The contents of this e-mail may be confidential and the unauthorized use,
copying, or dissemination of it and any attachments to it, is prohibited.
Internet communications are not secure and Dexa Group companies do not,
therefore, accept legal responsibility for the contents of this message nor
for any damage caused by viruses. The views expressed here do not necessarily
represent those of Dexa Group companies.
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hb5blqf/M=362131.6882499.7825260.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1122727578/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life
- brought to you by One Economy</a>.</font>
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
