To enable archive log mode a RAC database step by step ...do
the following
1.Login to one of the nodes (i.e. racnode1) and disable
the cluster instance parameter by setting cluster_database to FALSE from the
current instance:
==================================================================
$ sqlplus "/ as sysdba"
SQL> alter system set cluster_database=false
scope=spfile sid='racdb1';
2.Shutdown all instances accessing the clustered database:
==================================================================
$ srvctl stop database -d racdb
3.Using the local instance, MOUNT the database:
==================================================================
$ sqlplus "/ as sysdba"
SQL> startup mount
4.Enable archiving:
=======================
SQL> alter database archivelog;
5.Re-enable support for clustering by modifying the
instance parameter cluster_database to TRUE from the current instance:
=======================================================================
SQL> alter system set cluster_database=true
scope=spfile sid='racdb1';
6.Shutdown the local instance:
===========================================
SQL> shutdown immediate
7.Bring all instance back up using srvctl:
===========================================
$ srvctl start database -d racdb
8.(Optional) Bring any services (i.e. TAF) back up using
srvctl:
=====================================================
$ srvctl start service -d racdb
9.Login to the local instance and verify Archive Log Mode
is enabled:
================================================================
$ sqlplus "/ as sysdba"
SQL> archive log list
Database log
mode
Archive Mode
Automatic
archival
Enabled
Archive
destination
USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 83
Next log sequence to archive 84
Current log
sequence 84
After enabling Archive Log Mode, each instance in the RAC
configuration can automatically archive redologs!
--
Do you like this post? Please share this article.
HTML Link Code:
Post a Comment