This post is more than 5 years old
4 Posts
0
2314
May 5th, 2014 08:00
Oracle RAC backup from all nodes
What is the best practice for backup Oracle in RAC?
How allocate channel for tuning backup?
How mamy chanell allocate?
Do you have some example scripts?
Regars Greg
stephen_berry
4 Posts
0
May 8th, 2014 06:00
Hello Greg
When you ask for the best practice you have not given backup methodology (ddboost plugin nfs etc).
Allocate channel within the run block dependent on your backup method.
How many channels depends on resources available on the database server.
The "EMC Data Domain Boost for Oracle Recovery Manager 1.1 Administration Guide" would be a good place to start.
Regards
Steve Berry
GrzegorzJ
4 Posts
1
May 8th, 2014 07:00
Hello Steve
Thank you for taking the subject.
I want to make a backup using the ddboost
I have 3 Nodes in Oracle RAC Cluster and three databases 9 instances.
I want to use 3 channels for backup example below
CONFIGURE CHANNEL C1 DEVICE TYPE SBT_TAPE CONNECT 'sys/oracle@rman_service1';
CONFIGURE CHANNEL C2 DEVICE TYPE SBT_TAPE CONNECT 'sys/oracle@rman_service2';
CONFIGURE CHANNEL C3 DEVICE TYPE SBT_TAPE CONNECT 'sys/oracle@rman_service3';
channel for ddboost example
ALLOCATE CHANNEL C1 TYPE DISK SBT_TAPE PARMS 'DISK=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle,BACKUP_HOST=dd-01-eth0,ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)';
where &1 = hostname server
BACKUP INCREMENTAL LEVEL 0 DATABASE format= '/rman_backup/&1_%d_%T_Level0_%s_%p.bak' tag ='level 0';
backup archivelog all not backed up 1 times delete all input format= '/rman_backup/&1_%d_%T_archive_%s_%p.bak' delete all input filesperset=1;
backup current controlfile spfile format '&1_%d_%T_archive_%s_%p.bak_cf' filesperset=4;
Run by scripts with hostname parameters
#!/bin/bash
$ORACLE_HOME/bin/rman target / <
@backup_ts_generic.rman "RACORACLE-TST01"
END_RMAN
My question
because we have 1 STORAGE_UNIT=oracle for all databases PRODUCTION and UAT
Whether there will be any complications if the database on the production and uat have the same name?
How to make a backup for archivelogs from 3 nodes by ddboost and UAT 2 nodes by ddboost database have the same name.