Cold Backups/Oracle Shutdown

From: Isaac Oribioye <I.O.Oribioye_at_herts.ac.uk>
Date: Wed, 19 Jun 96 16:03:28 GMT

Hi Folks;

I am new to Oracle DBA and Unix SysAdmin and am having problems setting up a
script to do automated backups on my Alpha machine running Digital Unix
3.2C, here's a trimmed down version of my shell script below...

>su - oracle -c /disk2/oracle/bin/sqldba lmode=y<<EOF1
> connect internal;
> exit;
> EOF1
> if test -f /disk2/oracle/dbs/sgadefMISUSE.dbf
> then
> echo "SGADEF IS STILL RESIDENT"
> echo "DATABASE SHUTDOWN IS SUSPECT"
> echo "DATABASE BACKUP IS SUSPECT"
> else
> echo "DATABASE SHUTDOWN WAS CLEAN"
># /usr/sbin/dump -0unN /dev/rmt0h /disk2
># /usr/sbin/dump -0unN /dev/rmt0h /usr
># /usr/sbin/dump -0un /dev/rmt0h /
> fi
>su - oracle -c /disk2/oracle/bin/sqldba lmode=y<<EOF2
> connect internal;
> exit;
> EOF2

and below is the error message that follows....

>SQL*DBA: Release 7.2.3.0.0 - Production on Wed Jun 19 15:26:43 1996
>
>Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>DBA-00314: Message 314 not found; No message file for product=RDBMS,
facility=DBA
>Error while trying to retrieve text for error ORA-12545
>
>SQLDBA> Error while trying to retrieve text for error ORA-12545
>SQLDBA> Message 37 not found; No message file for product=RDBMS, facility=DBA

Any pointers as to what I'm doing wrong either in Unix or in Oracle (7.2.3).
I would appreciate any help.

Thanks for your quick response.

Isaac Oribioye
University of Hertfordshire
manxioa_at_herts.ac.uk
Received on Wed Jun 19 1996 - 17:34:14 NZST

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:46 NZDT