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