-
can i recover database in noarchivelog mode
MEDIA RECOVERY
=================
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORANT\database\SYS01.ORA'
SVRMGR> alter database recover datafile 'C:\ORANT\database\SYS01.ORA';
alter database recover datafile 'C:\ORANT\database\SYS01.ORA'
*
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:
when i try to recover datafile i get message like this
this database is in noarchivelog mode. i don't have coldbackup also.
so how can i recover that noarchivelog mode database?
please help me.
-
You can't recover a database which is in NOARCHIVELOG mode. It can only do instance recovery, which is recovering transactions which were in redo logs when system crashed.
If you do not have a cold backup, then there is not much you can do. If you have export dump then you can import that.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|