ORA-00322: log 2 of thread 1 is not current copy

Hi

My database running Oracle XE on Ubuntu crashed today. When I open it it gives following error.

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: '/usr/lib/oracle/xe/oradata/XE/sysaux.dbf'


SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1:
'/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/onlinelog/o1_mf_2_54v6wwf0
_.log'


Please help my to recover.

- The database is in NOARCHIVELOG mode
- I don't have a backup
systemsautomationAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
You can try a point in time recovery then open resetlogs:

http://www.orafaq.com/forum/t/36893/2/

If it opens, I would probably export the important schemas and recreate the database just in case.
0
schwertnerCommented:
You can try to eliminatethe AUX tablespace

SQL>startup mount

Now offline the tablespace or the datafile:

http://users.telenet.be/oraguy.be/offline_datafiles_and_tablespaces.htm

It is a very bad idea to install Oracle on Ubuntu.
All Linux distribution have unstable file system.
Oracle has made changes in the Linux kernel to stabililaze the file system
but I do not know if this is implented.

If you would like to use Linux download more stable OLES (red Hat) from Oracle technology Network for free.
Novel (SLES is also stable. Everything else ... you see the results.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.