Contents
- 192.168.25.112
- Notes
- DDBoost initiate
- Oracle Client installation how to
- You can initiate the CLI configuration wizard manually by entering the config setup command.
- DAY USEAGE
- Troubleshooting
- References
- RMAN scripts
192.168.25.112
sysadmin systec36#^
Notes
The following EMC PowerPath configurations support coexistence with DD Boost over FC: PowerPath v6.0 or greater on Windows. Customers with PowerPath versions below those listed must upgrade to a supported version. It is not necessary to submit an RPQ. Customers with platforms not listed must submit an RPQ.
- DD Boost for Oracle RMAN has been tested with Oracle Real Application Cluster, including Oracle Cluster Ware version 11.2.0.3 and ASM version 11.2.0.3.
- When utilizing device type of “SBT_TAPE” (TAPE), specify FILESPERSET = 8 when backing up to
the EMC© Data Domain system. It is important to specify this value explicitly to reduce the amount of DB backups that are needed to be cataloged by the third party backup applications. Please see MAXOPENFILES settings for the recommended value of MAXOPENFILES when FILESPERSET is set to 8.
Oracle rman agent
Data Domain Boost for Enterprise Applications, Oracle RMAN Agent enables data protection of Oracle database data with a Data Domain system. This agent allows Oracle administrators to perform backups and restores to Data Domain via Oracle RMAN, which involves client-side deduplication for faster, more efficient backup and recovery, quickly and securely on the Data Domain system using deduplication
DDBoost initiate
2. Data Domain configuration First DD Boost user needs to be created. This user should only be assigned to user role. Create DD Boost user: user add <DD Boost user> role user Create DD boost user user password aging show user password aging set <DD Boost user> max-days-between-change 99999 Enable DD Boost if needed: elicense show Display licence elicense add <license-key> Add license key, if necessary user add <user> role user Create DD Boost user Set DD Boost user default user and enable DD Boost if it has not been done ddboost status
rman agent administrator document 302-004-149 P61
Enabling DD Boost on a Data Domain System
# filesys status # filesys enable # license show => if disalbed, enter the license key provided: license add license-key. # user add USERNAME password PASSWORD # ddboost set user-name USERNAME # ddboost enable
Creating Storage Units
# ddboost storage-unit create rman-ddboost
Configuring Distributed Segment Processing
# ddboost option set distributed-segment-processing {enabled | disabled}
Enabling or disabling the distributed segment processing option does not require a
restart of the Data Domain file system.
rman catalog
First create a tablespace to house the recovery catalog schema
create tablespace rman_catalog datafile '/data/oral/rman_catalog.dbf' size 50M AUTOEXTEND ON NEXT 10M MAXSIZE 5G;
Next we create the recovery catalog owner. The user SYS cannot be the owner of the recovery catalog.
create user rman identified by rman default tablespace rman_catalog quota unlimited on rman_catalog;
grant recovery_catalog_owner to rman; select privilege from dba_sys_privs where grantee = 'RECOVERY_CATALOG_OWNER';
rman target / catalog ddboost@CATDB
CREATE CATALOG on RMAN CATALOG DATABASE
[oracle@rac01 ~]$ rman catalog ddboost/PASSWORD@rmandb Recovery Manager: Release 11.2.0.4.0 - Production on 星期二 3月 20 22:54:31 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to recovery catalog database RMAN> CREATE CATALOG; recovery catalog created
Registering a Database with RMAN
[oracle@rac01 ~]$ rman target sys/Systec36@DDTEST catalog ddboost/PASSWORD@rmandb Recovery Manager: Release 11.2.0.4.0 - Production on 星期二 3月 20 22:56:09 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: DDTEST (DBID=1842543617) connected to recovery catalog database RMAN> REGISTER DATABASE; database registered in recovery catalog starting full resync of recovery catalog full resync complete
starting backup
[oracle@rac01 ~]$ rman target sys/Systec36@DDTEST catalog ddboost/PASSWORD@rmandb @rman-ddboost-backup.rmn
Oracle Client installation how to
install rman plugin in Oracle Server
[root@rac01 ddrman]# export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 oracle@ddboost-oracle /media $ cd DDBoost-Over-FC-Softwares/ddrman oracle@ddboost-oracle /media/DDBoost-Over-FC-Softwares/ddrman $ ls ddutil libccme_base_non_fips.so libcryptocme.sig libCSP-lb.so libDDBoost.so license.txt uninstall.sh install.sh libccme_base.so libcryptocme.so libCSP-Security.so libddobk.so readme.txt $ ./install.sh Do you want to install under the default installation directory /home/oracle/opt/dpsapps/rmanagent? (y or n) n A directory outside of the ORACLE_HOME directory must have been created specifically for this installation. Enter the full pathname of the installation destination: /opt/dpsapps/rmanagent The installation directory /opt/dpsapps/rmanagent does not exist. Enter a different directory. /opt/dpsapps/rmanagent The lib directory /opt/dpsapps/rmanagent/lib is created. The config directory /opt/dpsapps/rmanagent/config is created. The bin directory /opt/dpsapps/rmanagent/bin is created. The log directory /opt/dpsapps/rmanagent/logs is created. Installing the Oracle RMAN agent. Copying the lockbox libraries to /opt/dpsapps/rmanagent/lib/. Copying libddobk.so to /opt/dpsapps/rmanagent/lib/. Copying libDDBoost.so to /opt/dpsapps/rmanagent/lib/. Copying ddutil to /opt/dpsapps/rmanagent/bin/. Successfully installed the Oracle RMAN agent. The Oracle RMAN agent library, libddobk.so, does not exist in /u01/app/oracle/product/11.2.0/db_1/lib. Do you want to update settings in /u01/app/oracle/product/11.2.0/db_1 directory so that RMAN scripts from previous installation can be reused? (y or n) y Updating settings in the /u01/app/oracle/product/11.2.0/db_1 directory. Settings are updated. Installation is completed.
Registering each Data Domain system
To connect to a Data Domain system, you must first register the Data Domain system with the Oracle RMAN agent. This registration provides the Oracle RMAN agent with the necessary username and password for connecting to the Data Domain system. The Oracle RMAN agent stores the username and password securely in an encrypted lockbox file and retrieves the values when connecting to a Data Domain system.
rman target /
Registering a standard Data Domain System
RUN {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(STORAGE_UNIT=ddboost01,BACKUP_HOST=192.168.25.112,RMAN_AGENT_HOME=/opt/dpsapps/rmanagent)';
send 'set username ddboost password 123456 servername 192.168.25.112';
RELEASE CHANNEL C1;
}
RUN {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/oracle/app/11.2/lib/libddobk.so,ENV=(STORAGE_UNIT=oraboost,BACKUP_HOST=10.48.223.102,RMAN_AGENT_HOME=/opt/dpsapps/rmanagent)';
send 'set username ddboost password Systec36 servername 10.48.223.102';
RELEASE CHANNEL C1;
}
RUN {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/oracle/app/11.2/lib/libddobk.so,ENV=(RMAN_AGENT_HOME=/opt/dpsapps/rmanagent)';
send 'set username ddboost password Systec36 servername 10.48.223.102';
RELEASE CHANNEL C1;
}
Registering to an RAC Data Domain System
RUN {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(RMAN_AGENT_HOME=/opt/dpsapps/rmanagent)';
send 'hostnames rac01 rac02';
RELEASE CHANNEL C1;
}
using target database control file instead of recovery catalog
allocated channel: C1
channel C1: SID=22 instance=ddtest1 device type=SBT_TAPE
channel C1: Data Domain Boost API
sent command to channel: C1
released channel: C1
RUN {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(STORAGE_UNIT=ddboost01,BACKUP_HOST=192.168.25.112,RMAN_AGENT_HOME=/opt/dpsapps/rmanagent)';
send 'set username ddboost password 123456 servername 192.168.25.112';
RELEASE CHANNEL C1;
}
sbttest
oracle@ddboost-oracle ~ $ tail .bash_profile
alias tns='cd $ORACLE_HOME/network/admin'
alias envo='env | grep ORACLE'
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
umask 022
export RMAN_AGENT_HOME=/opt/dpsapps/rmanagent
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export STORAGE_UNIT=ddboost01
export BACKUP_HOST=192.168.25.112
oracle@ddboost-oracle ~ $ sbttest test.log -trace x.log -libname /u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so
The sbt function pointers are loaded from /u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so library.
-- sbtinit succeeded
-- sbtinit (2nd time) succeeded
sbtinit: vendor description string=Data Domain Boost API
sbtinit: Media manager is version 4.5.0.0
sbtinit: Media manager supports SBT API version 2.0
sbtinit: allocated sbt context area of 4112 bytes
-- sbtinit2 succeeded
-- regular_backup_restore starts ................................
-- sbtbackup succeeded
write 100 blocks
-- sbtwrite2 succeeded
-- sbtclose2 succeeded
sbtinfo2: SBTBFINFO_NAME=test.log
sbtinfo2: SBTBFINFO_METHOD=stream
sbtinfo2: SBTBFINFO_SHARE=multiple users
sbtinfo2: SBTBFINFO_ORDER=random access
sbtinfo2: SBTBFINFO_LABEL=Oracle RMAN agent/ddboost01
sbtinfo2: SBTBFINFO_COMMENT=Data Domain Boost API
-- sbtinfo2 succeeded
-- sbtrestore succeeded
file was created by this program:
seed=463042226, blk_size=16384, blk_count=100
read 100 buffers
-- sbtread2 succeeded
-- sbtclose2 succeeded
-- sbtremove2 succeeded
-- regular_backup_restore ends ................................
-- sbtcommand succeeded
proxy copy is not supported
-- sbtend succeeded
*** The SBT API test was successful ***
backup database
RUN {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(STORAGE_UNIT=ddboost01,BACKUP_HOST=192.168.25.112)';
backup database;
#backup current controlfile;
RELEASE CHANNEL C1;
}oracle@ddboost-oracle /opt/dpsapps/rmanagent/config $ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Mar 15 08:56:03 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: DDTEST (DBID=1842134099)
RMAN> RUN {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(STORAGE_UNIT=ddboost01,BACKUP_HOST=192.168.25.112)';
backup current controlfile;
RELEASE CHANNEL C1;
}2> 3> 4> 5>
using target database control file instead of recovery catalog
allocated channel: C1
channel C1: SID=141 device type=SBT_TAPE
channel C1: Data Domain Boost API
Starting backup at 15-MAR-18
channel C1: starting full datafile backup set
channel C1: specifying datafile(s) in backup set
including current control file in backup set
channel C1: starting piece 1 at 15-MAR-18
channel C1: finished piece 1 at 15-MAR-18
piece handle=02str4t6_1_1 tag=TAG20180315T085606 comment=API Version 2.0,MMS Version 4.5.0.0
channel C1: backup set complete, elapsed time: 00:00:03
Finished backup at 15-MAR-18
released channel: C1
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 10.00M SBT_TAPE 00:00:02 15-MAR-18
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20180315T085606
Handle: 02str4t6_1_1 Media: Oracle RMAN agent/ddboost01
Control File Included: Ckp SCN: 970319 Ckp time: 15-MAR-18
RMAN>
RMAN> RUN {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(STORAGE_UNIT=ddboost01,BACKUP_HOST=192.168.25.112)';
backup database;
#backup current controlfile;
RELEASE CHANNEL C1;
}2> 3> 4> 5> 6>
using target database control file instead of recovery catalog
allocated channel: C1
channel C1: SID=141 device type=SBT_TAPE
channel C1: Data Domain Boost API
Starting backup at 15-MAR-18
channel C1: starting full datafile backup set
channel C1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ddtest/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ddtest/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ddtest/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ddtest/users01.dbf
channel C1: starting piece 1 at 15-MAR-18
channel C1: finished piece 1 at 15-MAR-18
piece handle=05str58t_1_1 tag=TAG20180315T090221 comment=API Version 2.0,MMS Version 4.5.0.0
channel C1: backup set complete, elapsed time: 00:00:15
channel C1: starting full datafile backup set
channel C1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel C1: starting piece 1 at 15-MAR-18
channel C1: finished piece 1 at 15-MAR-18
piece handle=06str59c_1_1 tag=TAG20180315T090221 comment=API Version 2.0,MMS Version 4.5.0.0
channel C1: backup set complete, elapsed time: 00:00:01
Finished backup at 15-MAR-18
released channel: C1
restore database
RUN {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(STORAGE_UNIT=ddboost01,BACKUP_HOST=192.168.25.112)';
ALLOCATE CHANNEL C2 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so,ENV=(STORAGE_UNIT=ddboost01,BACKUP_HOST=192.168.25.112)';
restore database from TAG='TAG20180315T091707';
#restore database;
recover database;
alter database open;
RELEASE CHANNEL C1;
RELEASE CHANNEL C2;
}
DELL EMC DATA DOMAIN ORACLE OPTIMIZED DEDUPLICATION
As stated in numerous documents, the best practice for getting the optimal deduplication with Dell EMC Data Domain system is to disable RMAN compression, RMAN encryption, and set an RMAN parameter FILESPERSET to 1. For most of the time, this practices optimizes the deduplication of Oracle RMAN backups to the EMC Data Domain. There are a few corner cases in which these settings do not yield optimal deduplication or even any deduplication.
You can initiate the CLI configuration wizard manually by entering the config setup command.
DAY USEAGE
Log into the CLI as the sysadmin user
- localhost.localdomain login: sysadmin
Password: <system_serial_number>
ddboost show
sysadmin@ddve-test# ddboost option show Option Value ------------------------------ -------- distributed-segment-processing enabled virtual-synthetics enabled fc disabled global-authentication-mode none global-encryption-strength none ------------------------------ --------
sysadmin@ddve-test# ddboost clients show active all
sysadmin@ddve-test# ddboost storage-unit show
Name Pre-Comp (GiB) Status User Report Physical
Size (MiB)
--------- -------------- ------ ------- ---------------
ddboost01 0.0 RW ddboost -
--------- -------------- ------ ------- ---------------
D : Deleted
Q : Quota Defined
RO : Read Only
RW : Read Write
RD : Replication Destinationsysadmin@ddve-test# ddboost streams show active
--------- Active Streams -------- --------- Soft Limits -------- - Hard Limit -
Name Read Write Repl-out Repl-in Read Write Repl Combined Combined
--------- ---- ----- -------- ------- ---- ----- ---- -------- --------------
ddboost01 0 0 0 0 - - - - -
--------- ---- ----- -------- ------- ---- ----- ---- -------- --------------
DD System Stream Limits: read=4 write=16 repl-in=20 repl-out=18 combined=16
disk
disk rescan disk show hardware disk status disk show state disk show stats
enclosure
enclosure show all enclosure show cpus enclosure show controllers ? sysadmin@ddve-test# enclosure show controllers 1
filesys
filesys show space mtree list mtree show compression /data/col1/ddboost01 mtree show performance /data/col1/ddboost01
system
system reboot system poweroff
ddutil
Show DD backup files
[root@ddboost-oracle ~]# ddutil -f -z 192.168.25.112:/ddboost01 'RMAN_AGENT_HOME' value obtained from environment variable is '/opt/dpsapps/rmanagent'. Type Perm Size Time Path --------------------------------------------------------------------------------- dir 777 589 Thu Mar 15 17:17:33 2018 (1521105453) /ddboost01 file 644 10485760 Thu Mar 15 16:56:08 2018 (1521104168) /ddboost01/02str4t6_1_1 file 644 10485760 Thu Mar 15 17:00:04 2018 (1521104404) /ddboost01/04str54j_1_1 file 644 1093664768 Thu Mar 15 17:02:34 2018 (1521104554) /ddboost01/05str58t_1_1 file 644 10485760 Thu Mar 15 17:02:37 2018 (1521104557) /ddboost01/06str59c_1_1 file 644 1093664768 Thu Mar 15 17:05:02 2018 (1521104702) /ddboost01/07str5dp_1_1 file 644 10485760 Thu Mar 15 17:05:05 2018 (1521104705) /ddboost01/08str5e1_1_1 file 644 1094713344 Thu Mar 15 17:17:32 2018 (1521105452) /ddboost01/09str64j_1_1 file 644 10485760 Thu Mar 15 17:17:33 2018 (1521105453) /ddboost01/0astr65c_1_1 oracle@ddboost-oracle ~ $ ddutil -f -z 192.168.25.112:/ddboost01 rac01 -R 'RMAN_AGENT_HOME' value obtained from environment variable is '/opt/dpsapps/rmanagent'. Type Perm Size Time Path --------------------------------------------------------------------------------- dir 744 191 Mon Apr 2 10:38:54 2018 (1522636734) /ddboost01/rac01 file 644 19922944 Mon Apr 2 10:38:55 2018 (1522636735) /ddboost01/rac01/DDTEST_set76_piece1_20180402_2csvaplt_1_1
delete DD backup files
[root@ddboost-oracle ~]# ddutil -d -z 192.168.25.112:/ddboost01 0astr65c_1_1 'RMAN_AGENT_HOME' value obtained from environment variable is '/opt/dpsapps/rmanagent'. Delete '/ddboost01/0astr65c_1_1' (Y/N)? y
delete DD backup directory
[root@ddboost-oracle ~]# ddutil -d -x -z 192.168.25.112:/ddboost01
'RMAN_AGENT_HOME' value obtained from environment variable is '/opt/dpsapps/rmanagent'.
Delete '/ddboost01' (Y/N)? y
Unable to complete the 'The delete operation failed for path '/ddboost01'.'. Error: [11080] [140642470917920] Tue Mar 20 12:30:04 2018
ddp_rmdir_rf_status() failed, Path /ddboost01/., Err: 5009-Path resolved with status 0 after recursive directory delete
.
[root@ddboost-oracle ~]# ddutil -f -z 192.168.25.112:/ddboost01 -R
'RMAN_AGENT_HOME' value obtained from environment variable is '/opt/dpsapps/rmanagent'.
Type Perm Size Time Path
---------------------------------------------------------------------------------
dir 777 101 Tue Mar 20 12:30:03 2018 (1521520203) /ddboost01
Troubleshooting
ORA-19511: Error received from media manager layer, error text:
https://grepora.com/2015/10/24/ddboost-sbtbackup-dd_rman_connect_to_backup_host-failed/
Starting backup at 05-JAN-18 current log archived channel dd0: starting archived log backup set channel dd0: specifying archived log(s) in backup set input archived log thread=1 sequence=5 RECID=1 STAMP=964619122 channel dd0: starting piece 1 at 05-JAN-18 released channel: dd0 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on dd0 channel at 01/05/2018 13:45:24 ORA-19506: failed to create sequential file, name="01sntqrj_1_1", parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: Error received from media manager layer, error text: sbtbackup: dd_rman_connect_to_backup_host failed
alert
alerts show current
References
https://gruffdba.wordpress.com/2015/08/01/configuring-dd-boost-on-linux-for-oracle-rman/
Instructions This article provides detailed instructions for DDBoost/RMAN plug-in installation and configuration on Unix/Linux Server.
Step 1: Download the plug-in file from EMC Data Domain download website.
From left panel, navigate to DDBoost For Enterprise Application --> DDBoost for Oracle RMAN, and pick the version.
Note: Make sure to choose the corresponding plug-in zip file for your Unix/Linux platform/OS, with the correct bits.
For example, for Solaris, there are different versions for Solaris_Sparc, and Solaris_x86_64
Once you download the tar file, you may need the password to decrypt the file. Please use the fillowing KB for password:
KB 186457: DDBoost Recovery Manager (RMAN) Plug In Download and Password
Step 2: Check the environmental variables on Unix/Linux Database server:
#echo $ORACLE_HOME
#echo $ORACLE_SID
Step 3. Stop RMAN processes before installing the RMAN Plug-in.
Note: No need to shutdown the database for Linux/Unix server.
Step 4. Unzip the plug-in file, and run install script.
It is recommended to have the same user to install the plug-in, start the database and run RMAN backup script.
#gunzip xxx.tar.gz
#tar xvf xxx.tar
#./install.sh
Note: If the installation did not completed with "Successfully installed the Data Domain plugin for RMAN..", open install.sh (a short shellscript), and cross-check the error message, to check on the user/permission. May need to manually copy those files to the destination location.
Step 5. After the installation, confirm the libraries (libDDBoost.so and libDDobk.so) are under $ORACLE_HOME/lib.
For the two libraries:
-libDDBoost is DDBoost
-libddobk is the API (interface) between RMAN and DDBoost (libDDboost).
Step 6. From within RMAN, run a script similar to the following to configure a channel to use with the RMAN plug-in.
Example below: (Note the path is case sensitive.)
RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/usr/oracle/dbhome_1/11.2.0.3/lib/libddobk.so,ENV=(STORAGE_UNIT=Storage-unit1,BACKUP_HOST=datadomain1.host.com,ORACLE_HOME=/usr/oracle/dbhome_1/11.2.0.3)';
new RMAN configuration parameters are successfully stored.
Notes:
-STORAGE_UNIT only need the short name for DDBoost SU, no need for /data/col1
-ORACLE_HOME need the full path, not $ORACLE_HOME.
Step 7. Run DD system registration script.
Example below: (Note the path is case sensitive.)
RMAN> RUN {
ALLOCATE CHANNEL C1 TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/usr/oracle/dbhome_1/11.2.0.3/lib/libddobk.so';
send 'set username ddboost-user password ddboost-user-password servername datadomain1.host.com';
RELEASE CHANNEL C1;
}
Notes:
-This registration script creates the encrypted user/password file and stores it in lockbox file, which is ddboost.config, normally under $ORACLE_HOME/config.
-Each DD system that will be used for backups should be registered.
-In an Oracle RAC environment or other configuration where multiple nodes are sharing the lockbox file, special steps are needed to create the lockbox. See the RMAN plug-in Admin Guide for details.
RMAN scripts
level0
hostname=`hostname -s` . /home/oracle/.bash_profile if [[ $# -eq 0 ]]; then echo "usage: incre0-backup.bash <oracle_sid>" exit fi export ORACLE_SID=$1 rman target / catalog rman@ddboost << EOF CONFIGURE DEFAULT DEVICE TYPE TO sbt_tape; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO './$hostname/%d_%F.ctl'; CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/u01/app/oracle/ddboost/lib/libddobk.so,ENV=(STORAGE_UNIT=oraboost,BACKUP_HOST=<DDname>,RMAN_AGENT_HOME=/u01/app/oracle/ddboost,DDBOOST_COMPRESSED_RESTORE=TRUE)' FORMAT './$hostname/%d_set%s_piece%p_%T_%U'; backup incremental level 0 as backupset database section size 5G filesperset 4; sql 'alter system switch logfile'; backup archivelog all delete input; exit; EOF
COL BS_REC FORMAT 99999 COL BP_REC FORMAT 99999 COL MEDIA_HANDLE FORMAT A50 COL P.COMPLETION_TIME SELECT S.RECID AS "BS_REC", P.RECID AS "BP_REC", P.COMPLETION_TIME as "COMPLETIONTIME", P.HANDLE AS "MEDIA_HANDLE" FROM RC_BACKUP_PIECE P, RC_BACKUP_SET S, RC_DATABASE D WHERE D.NAME = 'ddtest' AND P.DB_KEY = D.DB_KEY AND P.SET_STAMP = S.SET_STAMP AND P.SET_COUNT = S.SET_COUNT;