This discussion is archived
9 Replies Latest reply: Oct 5, 2012 10:16 AM by jgarry RSS

Everthing lost !

Fayn_dba Newbie
Currently Being Moderated
At first Linux file system was repaired by issuing fsck command
Then the following error >>

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'


datafile 25 will be created automatically during restore operation
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/04/2012 16:30:17
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

No cold backup is there

Archives are also missing !

Whats the solution ??

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points