Cold backup blues (UNIX)...

Hello,

I'm running Oracle 7.1 on an SGI running IRIX 5.3

Every night at 4am I take down Oracle and do a cold backup. This process normally takes about 30 minutes.

Unfortunately last night Oracle didn't shut down properly, so when I came into work the backup script was still running (waiting for Oracle to shutdown). I'm wondering if I should be doing something different.

Here's the script:

#!/usr/local/bin/perl5

$tag = `mt rewind`
die if($tag =~ /failed/);

# This is the part that was still going when I got to work: system("su - oracle -c '/disk02/oracle/bin/dbshut' > /dev/null");

system("bru -cmB -s 2000M /disk02");
system("/etc/init.d/orastart > /dev/null");
system("mt rewind");
system("eject /dev/tape");

.........................

This script has been working for a couple of months. But sometimes Oracle just doesn't shut down.

Should I be bringing Oracle down differently? Any suggestions appreciated.

Thanks

• James

.........................................................................

                        James Paul Cooper * Pixel
                         MU College of Education
       pixel_at_coe.missouri.edu - http://tiger.coe.missouri.edu/~pixel/


.........................................................................