• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3973
  • Last Modified:

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
0
systemsautomation
Asked:
systemsautomation
1 Solution
 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now