| media failure [message #328930] |
Mon, 23 June 2008 07:30  |
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
|
Senior Member |
|
|
hi,
I got media failure in system tablesapce.
My steps below.
sqlplus
user_name:sys as sysdba
password :manager
connected.
SQL>shutdown.
ORA-01109: database not open
Database dismounted.
SQL> startup;
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL>alter database open resetlogs;
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/opt/oracle/oradata/hhh/system01.dbf'
SQL>recover datafile '/opt/oracle/oradata/hhh/system01.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 until cancel;
ORA-00279: change 249890925 generated at 06/19/2008 06:53:16 needed for thread
1
ORA-00289: suggestion : /opt/oracle/product/9.2.0/dbs/arch1_4528.dbf
ORA-00280: change 249890925 for thread 1 is in sequence #4528
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: '/opt/oracle/oradata/hhh/system01.dbf'
ORA-01112: media recovery not started
How can resolve this issue?
Thanks,
Michael
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
