-
Hi
I need some help
I lost the current logfile. In the group I have 2 files, one of the 2 files is corrupted. My database is mount.
I try to recover database but oracle doesn't want to open with resetlogs.
I try to open the database with oracle's docs but no one
works.
Is there someone who have a little idea, please.
YT
yt
-
not a big deal IF NOT ALL GROUP MEMBERS LOST:
drop corrupted log file:
ALTER DATABASE DROP LOGFILE MEMBER '/oracle/dbs/log2b.f';
add new
ALTER DATABASE ADD LOGFILE MEMBER '/oracle/dbs/log2b.f' REUSE TO GROUP 2;
Read backup and recovery guide, media recovery scenarious chapter.
-
I try to follow your method but it sent this message
ORA-00362: member is required to form a valid logfile in group 1
In fact , I 've lost the 2 current redo log file. I manage to have a backup, but only one of the 2 redo log.
I tried to recover database until cancel but Oracle doesn't want it says :
ORA-01194: file 1 needs more recovery to be consistent
I tried to switch the redo log, but I can't the database is mount.
I tried to drop the group, but I can't because it is the current group.
yt
yt
-
This is a delicate issue. Generally, when 1 of the members is corrupted, Oracle suggests you 'clear' the log member. If both are corrupted, you probably would have to perform an incomplete recovery until the most recent arch redo log file. I strongly suggest you call Tech Support.
-
if you REALLY lost ALL CURRENT log files and HAVE NO BACKUPS, then there is one parameter
_ALLOW_RESETLOGS_CORRUPTION = TRUE
but just try to get over w/o this parameter. After you open db using it, it is recomended to exp/imp into new database.
-
You are getting the error 00362 because any group must have at least 2 members.Try to create a third one and them try to drop the corrupted one.
Best of Luck
-
Originally posted by vishywish
You are getting the error 00362 because any group must have at least 2 members.Try to create a third one and them try to drop the corrupted one.
Best of Luck
thank you everybody
I managed to open the database.
I 've added a third member, It was OK
I've shut down the database then open it.
The database was mounted, it couldn't open. So I've clear the logfile group and then tried to open it with option resetlogs.
Now it is opened.
Thank you very much becasuse I hadn't a cold backup, but only one backup of a redo log file.
YT
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
|