Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: More RMAN Questions
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_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.
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
-----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
![]() |
![]() |