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_ANARTEST

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

ANARTEST/

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_ANARTEST

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='ANARTEST1';




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 ANARTEST

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_ANARTEST

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/ANARTEST/ARCHIVELOG' SCOPE=SPFILE;




System altered.




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




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 ANARTEST

PRCC-1014 : ANARTEST was already running

PRCR-1004 : Resource ora.ANARTEST.db is already running

PRCR-1079 : Failed to start resource ora.ANARTEST.db

CRS-5017: The resource action "ora.ANARTEST.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.ANARTEST.db' on 'bakuabsutdb2' failed

CRS-2528: Unable to place an instance of 'ora.ANARTEST.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 ANARTEST

bash-4.1$ srvctl start database -d ANARTEST

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.ANARTEST.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_ANARTEST

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/ANARTEST/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: