Creating Catalog Database in RAC using RMAN

Steps:
—————-
At Catalog Server:-
—————-
1.Create catalog database
2.create one tablespace
3.create one user and grant appropriate
privileges to that user.
4.connect to catalog db and execute the following
command i.e;’Create catalog’ to create rman metadata tables.
7.configure tnsnames.ora
8.connect to target db through catalog db and register db into
catalog db.
9.configure rman configuration parameters and take the backup of target db.

———————————————
At Target Server
———————————————-
5.configure listener.ora
6.create password file

——————————————————
Creating catalog Database (At catalog server)
——————————————————-
Step:1
——-

$ps -ef|grep smon
$srvctl start database -d hrms
#mkdir -p /u02/app/oracle/oradata/
#chown -R oracle:oinstall /u02/app/oracle/oradata
#chmod -R 775 /u02/app/oracle/oradata

Now creating catalog database i.e;single instance database,

#xhost +
#su – oracle
$dbca
.oracle single instance
next
.create a database
next
next
Global database name : catdb
next
next
syspasword:racdba
next
.filesystem
next
.use common location for all data files
click on browse
/u02/app/oracle/oradata
next
.enable archiving
next
next
22% of memory
next
next
Finish
ok
Note:automatically we get tns entry
crms
crms1–>1 Instance
crms2–>2 instance
sqlplus rmaqnuser/rmanuser
SQL>select * from rc_database;

lnx01]$ps -ef|grep smon
$export ORACLE_SID=catdb
$sqlplus / as sysdba
SQL>select name from v$database;
SQL>select name from v$datafile;

step:2
——-
SQL>create tablespace rman_ts
datafile ‘/u02/app/oracle/oradata/catdb/rman_ts01.dbf’ size 120m autoextend on;
step:3
——
SQL>create user rmanuser identified by rmanuser default tablespace rman_ts;
SQL>grant connect,resource,recovery_catalog_owner to rmanuser;
SQL>conn rmanuser/rmanuser
SQL>show user
SQL>select * from tab; ( it will be zero count)
step:4
——-
SQL>host rman catalog rmanuser/rmanuser (to connect to rman) or
$rman catalog rmanuser/rmanuser
RMAN>create catalog;
RMAN>exit
SQL>select count * from tab; (now some tables we can see)

—————–
At Target Server
—————–
step:5
——
$cd $ORACLE_HOME/network/admin
$vi listener.ora
—–
step:6
——
$cd $ORACLE_HOME/dbs
$orapwd file=orapwhrms1 password=racdba entries=3 force=y

—————————-
At catalog Server
————————–
Step:7
——
$cd $ORACLE_HOME/network/admin
admin]$ ls
$vi tnsnames.ora

——–
:wq
(here we have all three entreis i.e;HRMS,HRMS1,HRMS2)

step:8
——
$export ORACLE_SID=catdb
$rman catalog rmanuser/rmanuser target sys/racdba@hrms1
RMAN>list incarnation; (to view existing registred db in 10g)
RMAN>register database;
RMAN>list db_unique_name all; (in 11g to view registered db)
RMAN>host ‘clear’;
RMAN>show all;

step:9
——
SQL> select * from v$rman_configuration;
RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
RMAN>show all;
RMAN>spool log to rman.log (all commands after this will be recorded)
RMAN>spool off;
RMAN>host ‘pwd’;
lnx01]vi rman.log
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE 2 AUTOBACKUP ON;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT ‘sys/racdba@hrms1’;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT ‘sys/racdba@hrms1’;
:wq!
$rman catalog rmanuser/rmanuser target sys/racdba@hrms1
RMAN>@rman.log
RMAN>show all;
RMAN>BACKUP DATABASE PLUS ARCHIVE LOG;
(it will store backupset in FRA)

————————————————————————————
SCENARIO
———————————————————————————–
1.Loss of Full database
———————–
RMAN>report schema; (location of datafiles)
$export ORACLE_SID=+ASM1
ASMCMD>ls
ASMCMD>rm *.ctl
yes>error (if your storage is ASM controlfile CANNNOT BE Removed)
$srvctl stop database -d hrms
ASMCMD>rm *.dbf *.ctl *.log
yes
ASMCMD>ls
ASMCMD>(no crd files)
ASMCMD>exit
lnx01>$export ORACLE_SID=hrms1
$sqlplus / as sysdba
SQL>startup nomount
SQL>exit
lnx01>$export ORACLE_SID=catdb
$rman catalog rmanuser/rmanuser target sys/racdba@hrms1
(error)
$cd $ORACLE_HOME/network/admin
$vi tnsnames.ora
HRMS1=
—-
———-
——–
(UR=A)
)
:wq
$rman catalog rmanuser/rmanuser target sys/racdba@hrms1
RMAN>restore controlfile;
RMAN>alter database mount;
RMAN>restore database;
RMAN>recover database;
RMAN>sql ‘alter database open resetlogs’;
RMAN>exit
RMAN>exit
$export ORACLE_SID=hrms1
$sqlplus / as sysdba
SQL>shut immediate
SQL>exit

lnx01]$ srvctl start database -d hrms
(It will start both instances and database)
lnx01]$ srvctl status database -d hrms

———————————————————-
2.Loss of non-system datafile
————————————————————-
# su – oracle
lnx01]$ srvctl stop database -d hrms
lnx01]$ ASMCMD
ASMCMD]rm users01.dbf

lnx01] $ export ORACLE_SID=hrms1
$ sqlplus / as sysdba
$ ps -ef|grep smon
$ srvctl start database -d hrms
SQL>startup mount
SQL>select * from v$recover_file;
SQL>alter database datafile 4 offline;
SQL>shut immediate;

lnx01]$ srvctl start database -d hrms
$ srvctl status database -d hrms

$rman catalog rmanuser/rmanuser target sys/racdba@hrms1
RMAN>restore datafile 4;
RMAN>recover datafile 4;
RMAN>sql ‘alter database datafile 4 online’;

ASMCMD>ls
(we can see datafile 4 now in the list)

————————————————————————-
Creating Backup Script
————————————————————————-
lnx01]$export ORACLE_SID=+ASM1
$ASMCMD
ASMCMD>ls
>cd asm_dg_fra
>cd hrms
>ls

$ vi rmanfulldbbkp.rcv
run{
allocate channel c1 device type disk connect ‘sys/racdba@hrms1’;
allocate channel c2 device type disk connect ‘sys/racdba@hrms1’;
allocate channel c3 device type disk connect ‘sys/racdba@hrms2’;
allocate channel c4 device type disk connect ‘sys/racdba@hrms2’;
sql ‘alter system archive log current’;
backup database plus archive log delete all input;
sql ‘alter system archive log current’;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}

Note:With respect to rman configuration channel priority goes to run blocks.

$export ORACLE_SID=catdb
$rman catalog rmanuser/rmanuser target sys/racdba@hrms1
RMAN>@rmanfulldbbkp.rcv

$ASMCMD
AMCMD>ls
>cd asm_dg_fra
>cd hrms
>ls
>cd archivelog
>cd 202….
>ls
>cd
>cd asm_dg_data
>ls
>cd hrms
>ls

Advertisements
Leave a comment

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: