ORA-01110: data file 1: ‘SYSTEM01.DBF’


The database is suddenly can not connect. I’ve tried using the command,
shutdown immediate;
startup mount;
alter database open resetlogs;

Then this error appears
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: ‘\SYSTEM01.DBF’

Second try,
SQL> alter database recover datafile ‘\SYSTEM01.DBF’
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database until cancel using backup controlfile;
ORA-00279: change 302423545 generated at 01/14/2009 09:25:14 needed for thread 1
ORA-00289: suggestion : G:\ARCHIVELOGS\672825376_1_49174.ARC
ORA-00280: change 302423545 for thread 1 is in sequence #49174

Specify log: {=suggested | filename | AUTO | CANCEL}

The more I want to find the solution, the more errors occurred. So I took the decision to continue to seek solutions from the first error only (“ORA-01110: data file 1: ‘\SYSTEM01.DBF'”).

Finally, after googling everywhere, I found the command in RMAN,
RMAN TARGET USR/PW
RMAN > RESTORE DATABASE
RMAN > RECOVER DATABASE

Back to SQLPLUS, I run again alter database open, and error is gone. ^_^

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: