For question 1.
(920)/oracle/app/oracle/admin> rman nocatalog
Recovery Manager: Release 9.2.0.2.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect target sys/password@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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
