Re: oraback.sh archive log issue

tomNOSPAM_at_teameazyriders.com said...
> Oracle 8.1.7
> RedHat 7.3
>
> Hi,
>
> I use oraback to perform hot backups of my instance and until now i have not
> had any issues with it. Today i setup oraback on a new box and have one a
> few test runs with it. It seems to work fine apart from one odd thing. It is
> not picking up on the archive log destination and instead telling me there
> are no archive logs present.
>
> Oracle is putting the archive logs in the correct location but oraback is
> not seeing them. Any thoughts why this might be as there are no config
> parameters to do with the archive log destination in the oraback config. It
> thinks the archive logs are in /u01/app/oracle/product/8.1.7/dbs for some
> reason? When they are really in /u05/arch/instancename
>
> thanks
>
> Tom
>
> log from oraback below...
>
> --snip--
>
> 17:12:34 14/04/03 - Finished Tablespace backup for TEMP
> 17:12:46 14/04/03 - Backing up /u02/oradata/DCCA/users01_SOL.dbf.
> 17:12:47 14/04/03 - Finished Tablespace backup for USERS
> -----------------------------------------------------
> Creating backup controlfile - /u05/backups/hot/DCCA/backup.controlfile
> Apr 14 17:20:06 bel oraback.sh DCCA: WARNING: NO archive logs found in
> /u01/app/oracle/product/8.1.7/dbs.
> Copying online redo logs:
> /u01/oradata/DCCA/redo01.log
> /u03/oradata/DCCA/redo02.log
>
> --snip--
>

It's because oraback.sh does an ARCHIVE LOG LIST command, which doesn't list all of your archive destinations, to determine where your archives are:

   #List archiving info
   $SVRMGR <<EOF_ARCHIVE >$TMP/$X.lf
connect internal;
archive log list;
exit;
EOF_ARCHIVE
   awk '/^Ar/ {print $3}' $TMP/$X.lf |sed "s-\?-$ORACLE_HOME-" \     > $CWD/$LOGFILE_LIST BTW, you'll also notice that almost all commands in oraback.sh use svrmgrl, so when that becomes obsolete, oraback.sh will start failing.

-- 
/Karsten
DBA > retired > DBA