Monday, March 6, 2017

Change ARCHIVELOG mode in RAC 12.1.0.2


[oracle@dens12adm01 V2Dump]$ srvctl status database -d DBM01
Instance DBM011 is running on node dens12adm01
Instance DBM012 is running on node dens12adm02
Instance DBM013 is running on node dens12adm03
Instance DBM014 is running on node dens12adm04
Instance DBM015 is running on node dens12adm05
Instance DBM016 is running on node dens12adm06
Instance DBM017 is running on node dens12adm07
Instance DBM018 is running on node dens12adm08
[oracle@dens12adm01 V2Dump]$ srvctl stop database -d DBM01
[oracle@dens12adm01 V2Dump]$ srvctl start database -d -o mount
PRKO-2388 : Command line option -db should be followed by a value.
[oracle@dens12adm01 V2Dump]$ srvctl start database -d DBM01 -o mount
[oracle@dens12adm01 V2Dump]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 6 21:30:15 2017

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> alter database noarchivelog;

Database altered.

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     1032
Current log sequence           1041
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
[oracle@dens12adm01 V2Dump]$ srvctl stop database -d DBM01
[oracle@dens12adm01 V2Dump]$ srvctl start database -d DBM01
[oracle@dens12adm01 V2Dump]$ srvctl status database -d DBM01
Instance DBM011 is running on node dens12adm01
Instance DBM012 is running on node dens12adm02
Instance DBM013 is running on node dens12adm03
Instance DBM014 is running on node dens12adm04
Instance DBM015 is running on node dens12adm05
Instance DBM016 is running on node dens12adm06
Instance DBM017 is running on node dens12adm07
Instance DBM018 is running on node dens12adm08
[oracle@dens12adm01 V2Dump]$

No comments:

Post a Comment