DBA Hub

📋Steps in this guide1/1

Enable Archive Log Mode In Oracle RAC

srvctl stop database -d PRIM

oracle configurationintermediate
by OracleDba
13 views
1

Overview

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
27
28
29
30
31
32
33
34
srvctl stop database -d PRIM

srvctl start database -d DBACLASS -o mount

SQL> alter database archivelog;

Database altered.

srvctl stop database -d PRIM

srvctl start database -d PRIM

SQL> alter system set log_archive_dest_1='LOCATION=+FRA/' scope=both sid='*';
System altered.
SQL> archive log list

Database log mode              Archive Mode

Automatic archival              Enabled

Archive destination            +FRA

Oldest online log sequence  724

Next log sequence to archive   726
Current log sequence           726
SQL> alter system switch logfile;
System altered.

srvctl stop database -d PRIM 
srvctl start database -d PRIM -o mount
alter database noarchivelog;
srvctl stop database -d PRIM 
srvctl start database -d PRIM

Comments (0)

Please to add comments

No comments yet. Be the first to comment!