systemsautomation
asked on
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/oradat a/XE/sysau x.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/or acle/flash _recovery_ area/XE/on linelog/o1 _mf_2_54v6 wwf0
_.log'
Please help my to recover.
- The database is in NOARCHIVELOG mode
- I don't have a backup
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/oradat
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/or
_.log'
Please help my to recover.
- The database is in NOARCHIVELOG mode
- I don't have a backup
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.