Enable/Disable Archive Log Mode Oracle 10g/11g

A very very very good and clear explanation from here : http://www.oracledistilled.com/oracle-database/backup-and-recovery/enabledisable-archive-log-mode-10g11g/

To Disable:

sqlplus / as sysdba
shutdown immediate
startup mount
alter database noarchivelog;
alter database open;
archive log list;

To Enable:

sqlplus / as sysdba
archive log list
show parameter recovery_file_dest
alter system set log_archive_dest_1='LOCATION=/path/orcl/arch' scope = both;
shutdown immediate
startup mount
alter database archivelog;
alter database open;
archive log list

//alak

Comments

Popular posts from this blog

SAP: Segregate Different SMTP Mail Server Based on Sender Domain

SAP Client Copy Error: Errors occurred during export of container object FINB-TR-DERIVATION