8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23ai | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Legato Single Server Version (LSSV) 7.1 and RMAN on Tru64 5.1b
Legato Single Server Version (LSSV) 7.1 is shipped on the Oracle Database 10g Companion CD, allowing RMAN to write to tape as well as disk.
OUI Install
As the Oracle software owner move to the "Oracle Database 10g Companion CD" staging area, export the DISPLAY variable if necessary and start the installer.
cd /ccd/Disk1 export DISPLAY=clientpc:0.0 ./runInstaller
Install the companion products into an existing database ORACLE_HOME. When prompted run the $ORACLE_HOME/root.sh script as root which installs the LSSV software.
Add "/usr/opt/networker/bin" to the PATH variable in the root .profile file.
Manual Install
As the root user move to the "Oracle Database 10g Companion CD" staging area, find the appropriate lsminst
script
and run it as follows.
su - root cd /ccd find . -name lsminst -print ./Disk1/lgto/lsminst ./Disk1/stage/Components/oracle.rdbms.lsm/6.1.0.0.0/1/DataFiles/Expanded/lsm/lsminst ./Disk1/stage/Components/oracle.rdbms.lsm/6.1.0.0.0/1/DataFiles/Expanded/lsminst ./Disk1/stage/Components/oracle.rdbms.lsm/6.1.0.0.0/1/DataFiles/Expanded/lsminst/rdbms/install/lgto/lsminst cd ./Disk1/stage/Components/oracle.rdbms.lsm/6.1.0.0.0/1/DataFiles/Expanded/lsm/ ./lsminst ./stage_tmp/lsm
During the installation you will be asked several questions, most of which can be answered with the defaults with the exception of the following.
- Select option 2 (Install LSSV Software)
- Select option 5 (Install all subsets)
- Enter the server name to backup.
Only move on to the next stage if the installation was completed successfully.
As the Oracle software owner find the liblsm.so library in the staging area, copy it to the appropriate location and create a symbolic link to it.
su - oracle cd /ora/install/db/10.1.0/ccd find . -name liblsm.so -print ./Disk1/stage/Components/oracle.rdbms.lsm/6.1.0.0.0/1/DataFiles/Expanded/lsminst/lib/liblsm.so cd ./Disk1/stage/Components/oracle.rdbms.lsm/6.1.0.0.0/1/DataFiles/Expanded/lsminst/lib/ cp liblsm.so $ORACLE_HOME/lib/liblsm.so ln -s $ORACLE_HOME/lib/liblsm.so $ORACLE_HOME/lib/libobk.so
Add "/usr/opt/networker/bin" to the PATH variable in the root .profile file.
Manual Uninstall
To manually uninstall the Legato software do the following.
su - oracle cd $ORACLE_HOME/lib rm liblsm.so rm libobk.so su - root nsr_shutdown # Select the appropriate line depending on the version. #setld -d ORCLSERV610 ORCLNODE610 ORCLCLNT610 ORCLMAN610 #setld -d LGTOCLNT611 LGTOMAN611 LGTONODE611 LGTOSERV611 setld -d LGTOSERV710 LGTONODE710 LGTOCLNT710 LGTOMAN710
Networker
The Networker software can be accessed by issuing the following command as the root user.
export DISPLAY=clientpc:0.0 networker
Once the GUI has run you can use it to define devices, label and mount tapes etc. The scripts used later assume that the necessary tape devices have been defined and the tape being mounted is already labelled.
RMAN Tape Backups
Once the LSSV software is installed RMAN backups to tape can be done by defining the default device type as follows.
su - oracle rman target=/ Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. connected to target database: DEV (DBID=3608529853) RMAN> CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'; old RMAN configuration parameters: CONFIGURE DEFAULT DEVICE TYPE TO DISK; new RMAN configuration parameters: CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'; new RMAN configuration parameters are successfully stored
Once this parameter is defined RMAN uses the libobk.so library as the media manager by default. In this way RMAN is able to work with any supported third party media manager by simply creating a symbolic link called libobk.so which points to the vendors media management library, in this case liblsm.so.
A tape backup can be done using a script like the following which is run from root.
#!/bin/ksh PATH=$PATH:/usr/bin:/usr/sbin/:/sbin:/bin:/usr/opt/networker/bin; export PATH ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE LOGPATH=$ORACLE_BASE/dba/logs; export LOGPATH LOGFILE=$LOGPATH/daily_backup.0.log; export LOGFILE # Rotate logs. rm $LOGPATH/daily_backup.9.log mv $LOGPATH/daily_backup.8.log $LOGPATH/daily_backup.9.log mv $LOGPATH/daily_backup.7.log $LOGPATH/daily_backup.8.log mv $LOGPATH/daily_backup.6.log $LOGPATH/daily_backup.7.log mv $LOGPATH/daily_backup.5.log $LOGPATH/daily_backup.6.log mv $LOGPATH/daily_backup.4.log $LOGPATH/daily_backup.5.log mv $LOGPATH/daily_backup.3.log $LOGPATH/daily_backup.4.log mv $LOGPATH/daily_backup.2.log $LOGPATH/daily_backup.3.log mv $LOGPATH/daily_backup.1.log $LOGPATH/daily_backup.2.log mv $LOGPATH/daily_backup.0.log $LOGPATH/daily_backup.1.log echo "Log rotate complete" >> $LOGFILE 2>&1 echo Start: `date +"%d/%m/%y %H:%M"` >> $LOGFILE 2>&1 chmod 777 $LOGFILE # Mount the tape nsrmm -m -f /dev/ntape/tape0_d1 >> $LOGFILE 2>&1 sleep 240 su - oracle <<EOF ORACLE_SID=DEV1; export ORACLE_SID rman target=/ cmdfile='$ORACLE_BASE/dba/cmdfile' log='$LOGFILE' append EOF # Unmount the tape nsrmm -u >> $LOGFILE 2>&1 echo End: `date +"%d/%m/%y %H:%M"` >> $LOGFILE 2>&1
The "cmdfile" referenced by this script constains the following RMAN script.
run { backup database plus archivelog; delete force noprompt obsolete; } exit;
Obviosuly you will need to adjust any path and device names appropriately.
For more information see:
Hope this helps. Regards Tim...