8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 10g » Here

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.

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...

Back to the Top.