Oracle-L: RE: More RMAN Questions

From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
Date: Thu, 16 Jan 2003 06:59:19 -0800
Message-ID: <F001.00531493.20030116065919@fatcity.com>

For question 1.

(920)/oracle/app/oracle/admin> rman nocatalog

Recovery Manager: Release 9.2.0.2.0 - Production

RMAN> connect target sys/password_at_sid (NOTE: sid is 8.1.7)

Recovery Manager incompatible with TARGET database: RMAN 8.0.4 to 8.1.6 required

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-06429: TARGET database is not compatible with this version of RMAN

For question 2.

I suppose you could write your own API to talk to legato, but it seems like it would be a lot of extra work. One scenario that I have found works well -- IF your databases aren't too big and you have plenty of fault-tolerant disk space -- is to back up to disk; then use OS to copy backup sets to tape. If space permits, keep two or three days worth of stuff on disk (hard drives are cheap). Handy Handy!

Here is a driver script I use to rotate directories for storing more than one day's worth of backups on disk.

go.ksh ---------------------------------- #!/bin/ksh

BASEDIR='/u05/oracle/admin'
SIDLIST='' cd "$BASEDIR"

for SID in `ls -1`;do

RESULT='' BACKDIR="${BASEDIR}/${SID}/backup"
if [ -d "$BACKDIR" ]; then

SIDLIST="${SIDLIST} ${SID}"
else

      continue
   fi
   cd "$BACKDIR"
   if [ ! -d "${BACKDIR}/DIR1" ]; then

      mkdir -m 750 "${BACKDIR}/DIR1"
   fi
   if [ ! -d "${BACKDIR}/DIR2" ]; then

      mkdir -m 750 "${BACKDIR}/DIR2"
   fi
   ls -1dt DIR[12] 2> /dev/null | while read LINE; do

if [ -n "$LINE" ]; then RESULT="$LINE"; fi done
STASH="${BACKDIR}/${RESULT}" find "$STASH" $ -type f -a -ctime +2 $ -exec rm {} \;

for i in `find . -type f -print -o $ ! -name . -a -type d -prune $`; do

mv "$i" "${STASH}/${i}"
done

done

/oracle/app/oracle/admin/dbascripts/rman/disk_backup.ksh $SIDLIST >> /oracle/app/oracle/admin/dbascripts/rman/debug 2>&1

End go.ksh -------------------------------------

-----Original Message-----

Oracle environment: 3 x 8.1.6 databases + 23 x 8.1.7 databases on 3 servers running AIX 4.3.3.

My plan is to use RMAN 9i, Legato Module for Oracle without a catalog and have all databases in archivelog mode. Databases will be backed up incrementally and full.

Questions below:

1) Will RMAN 9iR2 support 8.1.6 & 8.1.7 databases w/out using a catalog? >From the documentation, it appears the RMAN executable must match the target database.

2) Is RMAN even required for use w/ the Legato Module for Oracle? I know the MML is not required for RMAN, hence RMAN disk backups.

My prior plan was to upgrade the databases to 9iR2 then implement RMAN, no time to do both. Can I use RMAN 9i w/ older database versions?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Jan 16 2003 - 08:59:19 CST