Hi,
I got this problem:
I deleted the redo log files of a database by accident i want to know how can i open the database!
The error message while opening teels me the file does not exist.
Thanks
PFMS
Printable View
Hi,
I got this problem:
I deleted the redo log files of a database by accident i want to know how can i open the database!
The error message while opening teels me the file does not exist.
Thanks
PFMS
Mount the database, and open the database with resetlog option. The redo log files will be created.
sorry;
Can you tell me the command?
An example will be helpful
thanks,
pfms
from svrmgrl or sqplus as sysdba
startup mount
alter database open resetlogs
I´ve tried that and it didn´t worked.
I receive the message:
"RESETLOGS option only valid after an incomplete database recovery"
Now i can´t drop the group or file cause it is linked to a thread.
Can anybody tell me how i can solve this problem?
Note: I´can´t open the database and cause of that i can´t do an export too;
Thanks
PFMS
recover database until cancel;
do this and then
alter database open resetlogs;
now i got the following error after doing :
recover database until cancel
ORA-00279: change 513301 generated at 10/19/2001 19:50:43 needed for thread 1
ORA-00289: suggestion : E:\ORACLE\ORA81\RDBMS\ARC00172.001
ORA-00280: change 513301 for thread 1 is in sequence #172
Specify log: {=suggested | filename | AUTO | CANCEL}
i tried : auto
then it appears:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file1:
'E:\ORACLE\ORADATA\db\SYSTEM01.DBF'
Any suggestion?
Pfms
Try CANCEL while using recovery instead of AUTO. That might work.
I got the same problem like described here. Could anybody help on the last step written here? - I need the syntax for this step!
Thank you in advance,
chris
Runin the mount status and then type the name of the current redolog. Then open the database with resetlogs:Code:recover database until cancel using backup controlfile;
This should work.Code:alter database open resetlogs;