RAC

 Oracle RAC Architecture Picture

How to put the database in archive mode in rac?

SQL> select name from v$database;

NAME
---------
EBSTEST

SQL> alter system set cluster_database=False scope=spfile;

System altered.

SQL>

srvctl status database -d ebstest

srvctl stop database -d ebstest

sqlplus "/as sysdba"

SQL> startup mount
ORACLE instance started.

Total System Global Area 9556852736 bytes
Fixed Size 2166288 bytes
Variable Size 6375346672 bytes
Database Buffers 3154116608 bytes
Redo Buffers 25223168 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +ARCH
Oldest online log sequence 380
Next log sequence to archive 382
Current log sequence 382
SQL> alter system set cluster_database=true scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL>


srvctl start database -d ebstest


+++++++++++++++++++++++++++++++++++++++++
ATTACHING HOME IN RAC
+++++++++++++++++++++++++++++++++++++++++

cd $ORACLE_HOME/oui/bin

Server:- ctsst11

./attachHome.sh -local "CLUSTER_NODES=ctsst11,ctsst12" LOCAL_NODE=ctsst11

Server:- ctsst12

./attachHome.sh -local "CLUSTER_NODES=ctsst11,ctsst12" LOCAL_NODE=ctsst12

============================================

RAC CONVERSION

============================================

check on first node.

SQL> select THREAD#,GROUP# from v$log;

THREAD# GROUP#

---------- ----------

1 1

1 2

1 5

alter system set cluster_database=TRUE scope=spfile;

alter system set instance_number=1 SID='ebstest11' scope=spfile;

alter system set thread=1 SID='ebstest11' scope=spfile;

alter system set instance_number=2 SID='ebstest12' scope=spfile;

alter system set thread=2 SID='ebstest12' scope=spfile;

alter system set undo_tablespace='UNDOTBS1' SID='ebstest11' scope=spfile;

alter system set undo_tablespace='UNDOTBS2' SID='ebstest12' scope=spfile;

ALTER DATABASE ADD LOGFILE THREAD 2

GROUP 3 (

'+DATABASE_DATA',

'+DATABASE_DATA'

) SIZE 100M BLOCKSIZE 512 REUSE,

GROUP 4 (

'+DATABASE_DATA',

'+DATABASE_DATA'

) SIZE 100M BLOCKSIZE 512 REUSE,

GROUP 6 (

'+DATABASE_DATA',

'+DATABASE_DATA'

) SIZE 100M BLOCKSIZE 512 REUSE;

alter database enable public thread 2;

VERIFY* :-

select tablespace_name,STATUS from dba_tablespaces where tablespace_name like '%UNDO%';
sho parameter cluster
sho parameter undo
select * from v$active_instances;
sho parameter instance


=================================
Configure Scan Listener
==================================


[oratest1@ctsst11 11.2.0]$ srvctl config scan
SCAN name: cluster-scan.user.com, Network: 1/172.16.1.0/255.255.0.0/eth0
SCAN VIP name: scan1, IP: /cluster-scan.user.com/172.16.1.10
SCAN VIP name: scan2, IP: /cluster-scan.user.com/172.16.1.11
SCAN VIP name: scan3, IP: /cluster-scan.user.com/172.16.1.12

NODE1
=====

alter system set local_listener='(address=(protocol=tcp)(host=ctsst11-vip.user.com)(port=1542))' scope=both

sid='ebstest11';


alter system set remote_listener='(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.10)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.12)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.11)(PORT=1521)))';




NODE2
=====

alter system set local_listener='(address=(protocol=tcp)(host=ctsst12-vip.user.com)(port=1542))' scope=both sid='ebstest12';

======================================

How to take hotback in rac to normal file system?
=====================================

rman log /ebstest1/oracle/hotbackup.log


rman
connect target /

run {
ALLOCATE CHANNEL ch02 TYPE DISK;
ALLOCATE CHANNEL ch03 TYPE DISK;
ALLOCATE CHANNEL ch04 TYPE DISK;
ALLOCATE CHANNEL ch05 TYPE DISK;
ALLOCATE CHANNEL ch06 TYPE DISK;
ALLOCATE CHANNEL ch07 TYPE DISK;
ALLOCATE CHANNEL ch08 TYPE DISK;
ALLOCATE CHANNEL ch09 TYPE DISK;
ALLOCATE CHANNEL ch10 TYPE DISK;
ALLOCATE CHANNEL ch11 TYPE DISK;
BACKUP
FORMAT '/rman_backup/ebstest1/db/%d_db_u%u_s%s_p%p_t%t_db'
FILESPERSET 10
database plus archivelog ;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
RELEASE CHANNEL ch04;
RELEASE CHANNEL ch05;
RELEASE CHANNEL ch06;
RELEASE CHANNEL ch07;
RELEASE CHANNEL ch08;
RELEASE CHANNEL ch09;
RELEASE CHANNEL ch10;
RELEASE CHANNEL ch11;
}

step 2:

BACKUP FORMAT '/rman_backup/ebstest1/db/bk_u%u_s%s_p%p_t%t_bk' TAG 'ebstest1_ctrl' CURRENT CONTROLFILE;

=========================
HOW TO UPDATE SPFILE
========================

srvctl modify database -d ebstest1 -p '+DATABASE_DATA/EBSTEST1/PARAMETERFILE/spfile.261.823412109';