My SQL*Plus is not working. I tried the below (but it was of no use).
SQL*Plus: Release 9.0.1.0.1 - Production on Fri Jul 21 10:17:13 2006

(c) Copyright 2001 Oracle Corporation.  All rights reserved.

Enter user-name: scott
Enter password: *****
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress


Enter user-name: / as sysdba

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production

SQL> shutdown
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  118255568 bytes
Fixed Size                   282576 bytes
Variable Size              83886080 bytes
Database Buffers           33554432 bytes
Redo Buffers                 532480 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


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: 'D:ORACLEORADATAOEMREPSYSTEM01.DBF'


SQL> recover datafile 'D:ORACLEORADATAOEMREPSYSTEM01.DBF'
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database using backup controlfile;
ORA-00279: change 11224276 generated at 05/09/2006 10:25:22 needed for thre
ORA-00289: suggestion : D:ORACLEORA90RDBMSARC00543.001
ORA-00280: change 11224276 for thread 1 is in sequence #543


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
I gave <RET>

ORA-00308: cannot open archived log 'D:ORACLEORA90RDBMSARC00543.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.


SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
         1          1        542  104857600          1 NO  INACTIVE
     11204071 09-MAY-06

         2          1        543  104857600          1 NO  INVALIDATED
     11224275 09-MAY-06

         3          1        541  104857600          1 NO  INACTIVE
     11183879 09-MAY-06


======
I am at my wit's end. Kindly help me out. Note: I am just in the learning phase (not an expert).

    Requires Free Membership to View

Everything looked good up to this point in your process:
SQL> recover database using backup controlfile;
ORA-00279: change 11224276 generated at 05/09/2006 10:25:22 needed for thre
ORA-00289: suggestion : D:ORACLEORA90RDBMSARC00543.001
ORA-00280: change 11224276 for thread 1 is in sequence #543


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
I gave <RET>

ORA-00308: cannot open archived log 'D:ORACLEORA90RDBMSARC00543.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.
When you perform recovery using a backup controlfile, Oracle has no idea about any of your archived redo logs, so it starts at the first number if knows of and keeps increasing the sequence number. But it does not know when to stop. The correct option at this point is to reply CANCEL when asked for the next archived redo log. Once that is done, open the database with RESETLOGS. Then immediately shut down the database and take a good backup!

This was first published in July 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: