[Oracle] instance recovery required, cannot set ARCHIVELOG mode

Posted by cikul | Posted in Oracle, SQL, Technology | Posted on 26-09-2012-05-2008

1

When I try to set archivelog in another machine using this guidance. I’ve got this error message :


SQL> startup mount;
ORACLE instance started.

Total System Global Area  320309648 bytes
Fixed Size                   731536 bytes
Variable Size             285212672 bytes
Database Buffers           33554432 bytes
Redo Buffers                 811008 bytes
Database mounted.
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Read the rest of this entry »

Share and Enjoy

[Oracle] Setting ArchiveLog mode

Posted by cikul | Posted in Oracle, SQL | Posted on 25-09-2012-05-2008

2

What Is Archive Log?

As a DBA, you are responsible to recover any failures to a point of failure and also to perform your backup while online. Your organization is a 24×7 shop and you are not able to shutdown the database. Therefore, the database has to be in an archive mode.

For example you have severe corruption or a database crash that required you to restore some datafiles from several hours ago. If you have all the archived logs from that pint in time up until the moment of the crash, you can roll forward all the changes contained in those archived logs against the restored datafiles.

This process will replays all the changes in the database over the past hours. After recovering the last archived log, Oracle will then look to roll forward even more by using the online redo logs. If those online redo logs contain changes necessary, Oracle will apply those changes also.

Read the rest of this entry »

Share and Enjoy