Step 1: Set the Environment Variable
$ hostname
node1
$ export ORACLE_SID=gcprod1
$ sqlplus system @ gcprod1
password:
Step 2: Disable Cluster
SQL> alter system set CLUSTER_DATABASE=FALSE scope=spfile;
system altered
Step 3: Set the parameters (Optional)
SQL> alter system set LOG_ARCHIVE_START= FALSE scope=spfile;
system altered
Step 4: Shutdown the database
SQL> exit
$ srvctl stop database -d gcprod
Step 5: Mount the database
$ echo $ORACLE_SID
gcprod1
$ sqlplus "sys as sysdba"
SQL> startup mount
ORACLE instance started
Total System Global Area: 4.4678E+10 bytes
Fixed Size 2166864 bytes
Variable Size 4345302960 bytes
Database mounted.
Step 6: Disable Archive log
SQL> alter database noarchivelog;
Step 7: Enable the cluster
SQL> alter system set CLUSTER_DATABASE=TRUE scope=spfile;
system altered
Step 8: Shutdown the instance
SQL> shutdown immediate;
Step 9: Start all the instances
$ srvctl start database -d gcprod
Step 10: verify the status.
$ crs_stat -t
all instances must be online
$ sqlplus "sys as sysdba"
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 308
Next log sequence to archive 309
Current log sequence 309
Your database is in No Archive Log Mode.
Friday, June 3, 2011
Convert Archivelog Mode to NoArchivelog Mode in RAC
Labels:
Backup,
Configuration
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment