DBA Hub

📋Steps in this guide1/2

enable archive log mode in oracle rac DBACLASS

enable archive log mode in oracle rac

oracle clusteringintermediate
by OracleDba
13 views
1

Overview

Follow below steps for enabling archive log mode in oracle RAC.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
srvctl stop database -d DBACLASS

srvctl start database -d DBACLASS -o mount

SQL> alter database archivelog;
Database altered.

srvctl stop database -d DBACLAS 

srvctl start database -d DBACLAS

SQL> alter system set log_archive_dest_1='LOCATION=+ARCH/' scope=both sid='*';
System altered.



SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +ARCH
Oldest online log sequence     724
Next log sequence to archive   726
Current log sequence           726

SQL> alter system switch logfile;
System altered.
2

Section 2

For disabling archive mode also  . steps are same

Code/Command (click line numbers to comment):

1
2
3
4
5
srvctl stop database -d DBACLASS
srvctl start database -d DBACLASS -o mount
alter database noarchivelog;
srvctl stop database -d DBACLASS
srvctl start database -d DBACLASS

Comments (0)

Please to add comments

No comments yet. Be the first to comment!