rscamell
asked on
Resetting Redo Logs (ORA-322)
I am using Personal Oracle8i. Recently I have been experimenting with adding and dropping redo log files. It appears that in doing so I may have dropped and subsequently deleted, using Windows Explorer, the current redo log. Even after restoring the deleted file from the recycle bin, my orclALRT file gives the message:
Errors in file c:\ora95po\admin\orcl\bdum p\orclLGWR .TRC:
ORA-00322: log 7 of thread 1 is not current copy
ORA-00312: online log 7 thread 1 'C:ORA95PO\ORADATA\ORCL\RE DO08.LOG'
Errors in file C:\ORA95PO\admin\orcl\bdum p\orclLGWR .TRC:
ORA-00322: log 7 of thread 1 is not current copy
ORA-00312: online log 7 thread 1 'C:ORA95PO\ORADATA\ORCL\RE DO08.LOG'
ORA-00322 signaled during alter database open...
archiving is disabled
I am running Personal Oracle8i in NOARCHIVELOG mode. Redo08.log is definitely one that I deleted. I cannot swear to it, but I think I dropped it using the ALTER DATABASE command prior moving it from its folder to the recycle bin.
Since I cannot start the Oracle database because of this problem, I'm wondering if it is possible to reset the logs without starting the database or if whatever I have done requires that I reinstall Personal Oracle 8i and my various client products (e.g., Oracle Developer).
Thanks for your help.
Richard Scamell
Errors in file c:\ora95po\admin\orcl\bdum
ORA-00322: log 7 of thread 1 is not current copy
ORA-00312: online log 7 thread 1 'C:ORA95PO\ORADATA\ORCL\RE
Errors in file C:\ORA95PO\admin\orcl\bdum
ORA-00322: log 7 of thread 1 is not current copy
ORA-00312: online log 7 thread 1 'C:ORA95PO\ORADATA\ORCL\RE
ORA-00322 signaled during alter database open...
archiving is disabled
I am running Personal Oracle8i in NOARCHIVELOG mode. Redo08.log is definitely one that I deleted. I cannot swear to it, but I think I dropped it using the ALTER DATABASE command prior moving it from its folder to the recycle bin.
Since I cannot start the Oracle database because of this problem, I'm wondering if it is possible to reset the logs without starting the database or if whatever I have done requires that I reinstall Personal Oracle 8i and my various client products (e.g., Oracle Developer).
Thanks for your help.
Richard Scamell
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
at the command prompt, issue:
SET ORACLE_SID=<yourdatabasesi d>
start the servermanager command:
svrmgr30 (or eventually svrmgrl, check your oracle\bin folder for the actual executable.
then, at the svrmgr prompt, issue this:
connect internal/password
(password is typically oracle, but depending on the config, you might omit the password)
then:
open database mount;
and you have mounted (but not opened) the database
now, here comes the time to alter the REDO log as suggested my UsamaMunir
Finally, open the database
ALTER DATABASE OPEN;
the database should now open correctly
to close:
exit (svrmgr)
exit (dos prompt)
SET ORACLE_SID=<yourdatabasesi
start the servermanager command:
svrmgr30 (or eventually svrmgrl, check your oracle\bin folder for the actual executable.
then, at the svrmgr prompt, issue this:
connect internal/password
(password is typically oracle, but depending on the config, you might omit the password)
then:
open database mount;
and you have mounted (but not opened) the database
now, here comes the time to alter the REDO log as suggested my UsamaMunir
Finally, open the database
ALTER DATABASE OPEN;
the database should now open correctly
to close:
exit (svrmgr)
exit (dos prompt)
Angelll is correct
Usama
Usama
ASKER
Usama,
Thanks very much for your help and especially for responding so quickly.
Richard Scamell
Thanks very much for your help and especially for responding so quickly.
Richard Scamell
ASKER
Thanks for your prompt comment. I have a question. How do I do what you have suggested if I cannot open the database to begin with? Can I issue a mount database command from the MS-DOS prompt? I am running Windows 98. At the moment, believe I have eight log files in my database. I cannot tell for sure since I am unable to get into Oracle and look at the content of v$logfile. Can the switch logfile command be entered at the MS-DOS prompt without having the database started?
Thanks again for your comment.
Richard Scamell