December 6, 2014

Convert RAC database from Archivelog Mode to NoArchivelog Mode

[oracle@pard15 ~]$. oraenv
ORACLE_SID = [oracle]STG1
The Oracle base has been changed from /u01/app/oracle to /u02/app/oracle
[oracle@pard15 ~]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 07:12:55 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +RECO
Oldest online log sequence     26114
Next log sequence to archive   26116
Current log sequence           26116
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is running on node pard16
[oracle@pard15 ~]$srvctl stop database -d STG
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is not running on node pard15
Instance STG2 is not running on node pard16
[oracle@pard15 ~]$srvctl start instance -i STG1 -d STG -o mount
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is not running on node pard16
[oracle@pard15 ~]$. oraenv
ORACLE_SID = [STG1] ?
The Oracle base remains unchanged with value /u02/app/oracle
[oracle@pard15 ~]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 07:15:01 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select inst_id,instance_name,status from gv$instance;

   INST_ID INSTANCE_NAME    STATUS
---------- ---------------- ------------
         1       STG1           MOUNTED

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +RECO
Oldest online log sequence     26114
Next log sequence to archive   26116
Current log sequence           26116
SQL> alter database noarchivelog;

Database altered.

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            +RECO
Oldest online log sequence     26114
Current log sequence           26116
SQL> alter database open;

Database altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is not running on node pard16
[oracle@pard15 ~]$srvctl stop instance -i STG1 -d STG
[oracle@pard15 ~]$srvctl start database -d STG
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is running on node pard16
[oracle@pard15 ~]$. oraenv
ORACLE_SID = [STG1] ?
The Oracle base remains unchanged with value /u02/app/oracle
[oracle@pard15 ~]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 07:17:57 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select inst_id,instance_name,status from gv$instance;

   INST_ID INSTANCE_NAME    STATUS
---------- ---------------- ------------
         1 STG1           OPEN
         2 STG2           OPEN

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            +RECO
Oldest online log sequence     26114
Current log sequence           26116

No comments:

Post a Comment