RAC-Enable Archive Log-Configure to ASM Location   Leave a comment

I will List the steps to Enable Archive Log RAC Configured VM’s

Create  folders in ASM location.

a

Initially archives are not enabled

b

1. Login to one of the nodes (i.e. rac1) and disable the cluster instance parameter by setting cluster_database to FALSE from the current instance:

2. $ sqlplus “/ as sysdba”

SQL> alter system set cluster_database=false scope=spfile sid=’prod1′;

c

3. Shutdown all instances accessing the clustered database:

$ srvctl stop database -d prod

d

4.

We start in nomount mode one single instance of the RAC:

[oracle@rac1 ~]$ sqlplus ‘/as sysdba’

SQL> startup nomount;

SQL> alter system set log_archive_start=TRUE SCOPE=SPFILE;

System altered.

SQL> alter system set log_archive_dest_1=’LOCATION=+FRA/prod/archivelog’ SCOPE=SPFILE;

System altered.

e

alter system set cluster_database=true scope=spfile sid=’prod1′;

Now we mount the database instance:

SQL> alter database mount;

Database altered.
Now, we set the database to archive log mode:

SQL> alter database archivelog;
Database altered.
We can perform some checks after that…

srvctl start database -d prod

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRA/prod/archivelog
Oldest online log sequence 16
Next log sequence to archive 17
Current log sequence 17
SQL> alter system switch logfile;

System altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRA/prod/archivelog
Oldest online log sequence 17
Next log sequence to archive 18
Current log sequence 18

SQL> alter system switch logfile;

Now Check

f

Advertisements

Posted December 5, 2013 by balaoracledba.com in OracleRAC

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: