How to change database Mode from “Non Archive” to “Archive” in RAC

In this article, you will get to know the process of How to change database Mode from “Non Archive” to “Archive” in RAC in Oracle. 

 
 
High-Level Steps to change database Mode from “Non-Archive” to “Archive” in RAC

 
1) Cluster_database=false
 
2) Stop the cluster database
 
3) Startup the database from one instance in mount stage
 
4) Change the database mode to archive mode
 
5) Cluster_database=true
 
6) Shut down the database
 
7) Start the cluster database
 
Step by Step Example : –
Step 1) Set Cluster_database=false
SQL> alter system set cluster_database=false scope=spfile sid=’*’;
 
System altered.
 
Step 2) Stop the Cluster database through SRVCTL command
 
[oracle@rac1 dbs]$ srvctl stop database -d karan
[oracle@rac1 dbs]$ 
 
Step 3)  Start the database from one instance in mount stage
SQL> startup mount;
ORACLE instance started.
 
Total System Global Area 1235959808 bytes
Fixed Size     2252784 bytes
Variable Size   788529168 bytes
Database Buffers   436207616 bytes
Redo Buffers     8970240 bytes
Database mounted.
 
Step 4) Change the DB mode to archive
 
SQL> alter database archivelog;
 
Database altered.
 
SQL> archive log list;
Database log mode        Archive Mode
Automatic archival        Enabled
Archive destination        USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     19
Next log sequence to archive   20
Current log sequence        20
 
Step 5) Set Cluster_database=true
SQL> alter system set cluster_database=true scope=spfile sid=’*’;
 
System altered.
 
Step 6) Shut Down the database
 
SQL> shut immediate;
ORA-01109: database not open
 
 
Database dismounted.
ORACLE instance shut down.
 
Step 7) Start the cluster database again through SRVCTL command
 
[oracle@rac1 dbs]$ srvctl start database -d karan
[oracle@rac1 dbs]$ 
 
 

Hope this blog will help you!!

If this article is useful for you please comment, share with your friends.

In case of any issues please send your query to below comment section.

For more articles please do visit below links: –

 
 
If you want to download Oracle virtual box or VMware Workstation Player, Please click on below links:-
 
 
 

This Post Has 2 Comments

  1. This blog is very helpful for me.
    Very help full

Leave a Reply

Close Menu