Visit Counter

Sunday, April 5, 2015

Enable Archive Log mode in a RAC Environment

--Archive file location

SQL> alter system set log_archive_dest_1='location=/ora/oracle/archive1/' scope=spfile;
system altered.


--Archive file format


SQL> alter system set log_archive_format='arch_%t_%s_%r.arc' scope=spfile;
system altered.


--stop the database


$ srvctl stop database -d racdb1


--start the database in mount


$ srvctl start database -d racdb1  -o mount


--enable the archivelog


sql> alter database archivelog;


--stop the database.


$ srvctl stop database -d racdb1


--start all database


$ srvctl start database -d racdb1


--check the database 


sql> archive log list;


database log mode                   Archive Mode
Automatic archiveal                 Enabled
Archive Destination                 /ora/oracle/archive1
oldert online log sequence       9
Next log sequence to archive  10
current log sequence                  10