Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Database Restore Error

Database Restore Error

From: hanu <linarayan_at_hotmail.com>
Date: 7 Nov 2005 17:05:56 -0800
Message-ID: <1131411956.061392.20380@f14g2000cwb.googlegroups.com>


Hello,
I am trying to recover a database with a RMAN backup. I only had control files, i lost all my dbf and redo. When i try to recover i got this error message:

ORA-00283: recovery session canceled due to errors
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/dbs1/oradata/db/redo01.log'
ORA-27037: unable to obtain file status

Error: 2: No such file or directory
I then did this: alter database open; and recived the following message:
RMAN-03002: failure of alter db command at 11/07/2005 14:54:30 ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/dbs2/oradata/mibas/system.dbf' what should i do? I checked it recovered the system.dbf file but still giving above errors.
Thanks for ur help.
Hanu Received on Mon Nov 07 2005 - 19:05:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US