Posting: Doc for Legato configuration on HP

From: Anil Sikri <anil_sikri_at_hotmail.com>
Date: Thu, 04 May 2000 13:12:24 CDT
Message-Id: <10487.104956@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_15fb7bb3_47d35dae$2454f091 Content-Type: text/plain; format=flowed

Hi guys,

Recently, I had to go through the gruelling process of manually installing and configuring Legato Storage Manager (LSM) on HP-UX 11.0, Oracle8.1.5. I finally succeeded in making RMAN talk to Legato through trial and error and using the haphazard documentation provided by Oracle.
I have prepared a step-by-step document for installing LSM on HP-UX, Oracle8.1.5. Hopefully others don't have to reinvent the wheel and can use this to configure Legato and start doing doing the hot backups using RMAN.This will be esp. helpful in the case when LSM wasn't installed during Oracle installation and has to be installed manually. Note: Things might have changed a bit on Oracle8.1.6.

I am also posting a script for taking a full backup to the tape using RMAN and Legato.
Both the doc and the scripts are enclosed as attachments to this e-mail.

Let me know directly in case of any problems/questions.

Anil Sikri
Sr. Oracle DBA

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

------=_NextPart_000_15fb7bb3_47d35dae$2454f091

Content-Type: text/plain; name="Legato Setup and Configuration.txt"
Content-Transfer-Encoding: 8bit
Content-Disposition: attachment; filename="Legato Setup and Configuration.txt"

------=_NextPart_000_15fb7bb3_47d35dae$2454f091

Content-Type: text/plain; name="rman_full_backup_script.rcv.txt"; format=flowed
Content-Transfer-Encoding: 8bit
Content-Disposition: attachment; filename="rman_full_backup_script.rcv.txt"

create script hot_db_backup_to_tape
{

   allocate channel t1 type 'SBT_TAPE' parms 'ENV=(BACKUP_DIR=/dev/rmt/0m)';    backup database
   format 'full_%d_%u';
   release channel t1;
}

create script backup_archlog_all
{

allocate channel t1 type 'SBT_TAPE' parms 'ENV=(BACKUP_DIR=/dev/rmt/0m)'; sql "alter system archive log current"; backup archivelog all format 'arch_%u'; release channel t1;
}

create script backup_archlog_old
{

   allocate channel t1 type 'SBT_TAPE' parms 'ENV=(BACKUP_DIR=/dev/rmt/0m)';    backup archivelog
   until time 'sysdate -2'
   all format 'arch_old_%u'
   delete input;
   release channel t1; Received on Thu May 04 2000 - 13:12:24 CDT