-
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
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
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
-
Run
Code:
recover database until cancel using backup controlfile;
in the mount status and then type the name of the current redolog. Then open the database with resetlogs:
Code:
alter database open resetlogs;
This should work.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|