Home » RDBMS Server » Backup & Recovery » media failure (Oracle 10g,Linux)
media failure [message #328930] Mon, 23 June 2008 07:30 Go to next message
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




Re: media failure [message #328943 is a reply to message #328930] Mon, 23 June 2008 08:17 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above
Re: media failure [message #329007 is a reply to message #328930] Mon, 23 June 2008 12:59 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Post
SQL>select * from v$log;
Re: media failure [message #329053 is a reply to message #329007] Mon, 23 June 2008 23:23 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
what is this?
Re: media failure [message #329054 is a reply to message #329053] Mon, 23 June 2008 23:25 Go to previous message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
holdingbe wrote on Mon, 23 June 2008 21:23
what is this?

this is what?
Previous Topic: Using Rman in Windown Client to Backup Oracle Server 10g in AIX, save to disk in Window (merged 3)
Next Topic: RMAN restore database from another backup of different database name
Goto Forum:
  


Current Time: Wed Dec 07 09:04:00 CST 2016

Total time taken to generate the page: 0.09492 seconds