Putting a RAC database in ARCHIVELOG


bash-4.1$ su - oracle
Password: 
Oracle Corporation SunOS 5.11 11.3 September 2015
-bash-4.1$ 
-bash-4.1$ 
-bash-4.1$ 
-bash-4.1$ . .profile_aztest 
bash-4.1$ 
bash-4.1$ 
bash-4.1$ sqlplus "/ as sysdba";

SQL*Plus: Release 11.2.0.4.0 Production on Tue May 31 11:46:12 2016

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.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 No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 17
Current log sequence 18
SQL> 
SQL> select log_mode from gv$database;

LOG_MODE
------------
NOARCHIVELOG
NOARCHIVELOG

SQL> 
SQL> 
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
bash-4.1$ 
bash-4.1$ 
bash-4.1$ su - grid
Password: 
Oracle Corporation SunOS 5.11 11.3 September 2015
-bash-4.1$ 
-bash-4.1$ 
-bash-4.1$ . .profile_asm 
bash-4.1$ 
bash-4.1$ 
bash-4.1$ asmcmd
lsASMCMD> 
DATA/
FRA/
ASMCMD> 
ASMCMD> cd FR*
ASMCMD> ls
AZTEST/
ASMCMD> 
ASMCMD> cd AZT* 
ASMCMD> ls
CONTROLFILE/
ONLINELOG/
ASMCMD> 
ASMCMD> 
ASMCMD> mkdir ARCHIVELOG
ASMCMD> 
ASMCMD> ls
ARCHIVELOG/
CONTROLFILE/
ONLINELOG/
ASMCMD> 
ASMCMD> 
ASMCMD> exit
bash-4.1$ 
bash-4.1$ 
bash-4.1$ su - oracle
Password: 
Oracle Corporation SunOS 5.11 11.3 September 2015
-bash-4.1$ . .profile_aztest 
bash-4.1$ 
bash-4.1$ sqlplus "/ as sysdba";

SQL*Plus: Release 11.2.0.4.0 Production on Tue May 31 11:47:14 2016

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


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

SQL> alter system set cluster_database=false scope=spfile sid='AZTEST1';

System 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 17
Current log sequence 18
SQL> 
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
bash-4.1$ su - grid
Password: 
Oracle Corporation SunOS 5.11 11.3 September 2015
-bash-4.1$ . .profile_asm 
bash-4.1$ srvctl stop database -d AZTEST
bash-4.1$ su - oracle
Password: 
Oracle Corporation SunOS 5.11 11.3 September 2015
-bash-4.1$ 
-bash-4.1$ 
-bash-4.1$ . .profile_aztest 
bash-4.1$ 
bash-4.1$ sqlplus "/ as sysdba";

SQL*Plus: Release 11.2.0.4.0 Production on Tue May 31 11:50:02 2016

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

Connected to an idle instance.

SQL> 
SQL> startup nomount
ORACLE instance started.

Total System Global Area 4176814080 bytes
Fixed Size 2188160 bytes
Variable Size 905976960 bytes
Database Buffers 3254779904 bytes
Redo Buffers 13869056 bytes
SQL> alter system set log_archive_start=TRUE SCOPE=SPFILE;

System altered.


SQL> alter system set log_archive_dest_1='LOCATION=+FRA/AZTEST/ARCHIVELOG' SCOPE=SPFILE;

System altered.

SQL> alter system set cluster_database=true scope=spfile sid='AZTEST1';

System altered.

SQL> alter database mount;

Database altered.

SQL> alter database archivelog;

Database altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
bash-4.1$ 
bash-4.1$ 
bash-4.1$ su - grid
Password: 
Oracle Corporation SunOS 5.11 11.3 September 2015
-bash-4.1$ 
-bash-4.1$ . .profile_asm 
bash-4.1$ 
bash-4.1$ srvctl start database -d AZTEST
PRCC-1014 : AZTEST was already running
PRCR-1004 : Resource ora.aztest.db is already running
PRCR-1079 : Failed to start resource ora.aztest.db
CRS-5017: The resource action "ora.aztest.db start" encountered the following error: 
ORA-01102: cannot mount database in EXCLUSIVE mode
. For details refer to "(:CLSN00107:)" in "/u02/app/11.2.0/grid/log/bakuabsutdb2/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.aztest.db' on 'bakuabsutdb2' failed
CRS-2528: Unable to place an instance of 'ora.aztest.db' as all possible servers are occupied by the resource
bash-4.1$ 
bash-4.1$ 
bash-4.1$ 
bash-4.1$ id
uid=501(grid) gid=1000(oinstall)
bash-4.1$ 
bash-4.1$ 
bash-4.1$ srvctl stop database -d AZTEST
bash-4.1$ srvctl start database -d AZTEST
bash-4.1$ 
bash-4.1$ 
bash-4.1$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS 
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
 ONLINE ONLINE bakuabsutdb1 
 ONLINE ONLINE bakuabsutdb2 
ora.FRA.dg
 ONLINE ONLINE bakuabsutdb1 
 ONLINE ONLINE bakuabsutdb2 
ora.LISTENER.lsnr
 ONLINE ONLINE bakuabsutdb1 
 ONLINE ONLINE bakuabsutdb2 
ora.asm
 ONLINE ONLINE bakuabsutdb1 Started 
 ONLINE ONLINE bakuabsutdb2 Started 
ora.gsd
 OFFLINE OFFLINE bakuabsutdb1 
 OFFLINE OFFLINE bakuabsutdb2 
ora.net1.network
 ONLINE ONLINE bakuabsutdb1 
 ONLINE ONLINE bakuabsutdb2 
ora.ons
 ONLINE ONLINE bakuabsutdb1 
 ONLINE ONLINE bakuabsutdb2 
ora.registry.acfs
 ONLINE ONLINE bakuabsutdb1 
 ONLINE ONLINE bakuabsutdb2 
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
 1 ONLINE ONLINE bakuabsutdb2 
ora.LISTENER_SCAN2.lsnr
 1 ONLINE ONLINE bakuabsutdb1 
ora.LISTENER_SCAN3.lsnr
 1 ONLINE ONLINE bakuabsutdb1 
ora.aztest.db
 1 ONLINE ONLINE bakuabsutdb1 Open 
 2 ONLINE ONLINE bakuabsutdb2 Open 
ora.bakuabsutdb1.vip
 1 ONLINE ONLINE bakuabsutdb1 
ora.bakuabsutdb2.vip
 1 ONLINE ONLINE bakuabsutdb2 
ora.cvu
 1 ONLINE ONLINE bakuabsutdb1 
ora.oc4j
 1 ONLINE ONLINE bakuabsutdb1 
ora.scan1.vip
 1 ONLINE ONLINE bakuabsutdb2 
ora.scan2.vip
 1 ONLINE ONLINE bakuabsutdb1 
ora.scan3.vip
 1 ONLINE ONLINE bakuabsutdb1

bash-4.1$ 
bash-4.1$ id
uid=501(grid) gid=1000(oinstall)
bash-4.1$ 
bash-4.1$ 
bash-4.1$ 
bash-4.1$ su - oracle
Password: 
Oracle Corporation SunOS 5.11 11.3 September 2015
-bash-4.1$ 
-bash-4.1$ 
-bash-4.1$ . .profile_aztest 
bash-4.1$ 
bash-4.1$ 
bash-4.1$ sqlplus "/ as sysdba";

SQL*Plus: Release 11.2.0.4.0 Production on Tue May 31 11:56:15 2016

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.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 +FRA/aztest/archivelog
Oldest online log sequence 17
Next log sequence to archive 18
Current log sequence 18
SQL> 
SQL> 
SQL> select log_mode from gv$database;

LOG_MODE
------------
ARCHIVELOG
ARCHIVELOG
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: