bzack
asked on
ORA-16038, ORA-19809, ORA-16014, ORA-00312 after server crash. Oracle 10g on Windows 2000 server. Clueless noob at the wheel.
I am a total newbie with Oracle. The solutions I've found for this problem are mostly written for the clueful. Telling me to connect the foo to the bar and everything will be fine doesn't get me there. I need complete idiot instructions on how to undo what I have apparently done. Oracle 10g on Windows 2000 Advanced Server. Server meltdown. Now I'm getting:
ORA-16038: log1 sequence #669 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'E:\Oracle\Redologs\Redo1.
ORA-16014: log1 sequence #669 not archived. No available destinations
ORA-00312: online log 1 thread 1: 'E:\Oracle\Redologs\Redo1.
When the meltdown happened I was in Enterprise Manager trying to redirect some redo and archive files to a new hard drive that was added to my server. This happened prior to me reading about the spfile and how important it is to back it up. It evaporated. I can start Oracle from SQL*Plus using the pfile. I generated a new spfile from the pfile, but nothing I've tried has cleared these errors so Oracle will not start from the spfile. I tried increasing the recovery file limit, but apparently did it wrong because the error persists. I'm not sure what "No available destinations" is trying to tell me.
Thank you experts!
P.S. One step closer. I finally managed to start from the spfile, but the errors remain.
ORA-16038: log1 sequence #669 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'E:\Oracle\Redologs\Redo1.
ORA-16014: log1 sequence #669 not archived. No available destinations
ORA-00312: online log 1 thread 1: 'E:\Oracle\Redologs\Redo1.
When the meltdown happened I was in Enterprise Manager trying to redirect some redo and archive files to a new hard drive that was added to my server. This happened prior to me reading about the spfile and how important it is to back it up. It evaporated. I can start Oracle from SQL*Plus using the pfile. I generated a new spfile from the pfile, but nothing I've tried has cleared these errors so Oracle will not start from the spfile. I tried increasing the recovery file limit, but apparently did it wrong because the error persists. I'm not sure what "No available destinations" is trying to tell me.
Thank you experts!
P.S. One step closer. I finally managed to start from the spfile, but the errors remain.
or simply try to type in and see how it goes:
alter database clear unarchived logfile group 1;
acton
alter database clear unarchived logfile group 1;
acton
make user you specify the right destination for the "log_archive_dest" paramter.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I solved this myself, but I'm giving the points to markgeer because he answered it exactly the way I asked for it to be answered. I said I was a clueless idiot so please treat me as such, and he did. He even did it politely. :-)
Proof of my idiocy:
For starters, I was using the wrong pfile, which is why my create spfile from pfile was not working right. Once I got Oracle to recognize my newly created spfile I was able to poke around in Enterprise Manager. Initially I had set my log_archive_dest paths to identical paths on E: and F: drives. Once I did that again in EM, the errors stopped. The new spfile is now backed up everywhere!
Thanks to everyone who contributed. I know more questions will be coming because I'm having fun with this and I'm sure I'll be trashing this database again before long.
Proof of my idiocy:
For starters, I was using the wrong pfile, which is why my create spfile from pfile was not working right. Once I got Oracle to recognize my newly created spfile I was able to poke around in Enterprise Manager. Initially I had set my log_archive_dest paths to identical paths on E: and F: drives. Once I did that again in EM, the errors stopped. The new spfile is now backed up everywhere!
Thanks to everyone who contributed. I know more questions will be coming because I'm having fun with this and I'm sure I'll be trashing this database again before long.
http://www.idevelopment.info/data/Oracle/DBA_tips/Backup_and_Recovery/BandR_5.shtml