So I'm a LAN Admin (mixed NT/Novell environment) but I've had an Oracle Server (8.1.6i running on NT 4.0) dumped onto me (I have zippo Oracle experience).... A group had an oracle consultant come in to write a database but he's gone now. I need to backup (We use BACKUPEXEC for our NT and Novell backups) the server but I know I can't simply do a backup of the entire server by file. From what I've read I need to shutdown the database (It's not a 24/7 DB so I have a 9PM-->7am backup window) and THEN I can do a simple file by file backup, yes? Once the databases aree Shutdown do I also need to "stop" Oracle from running? If I can - how would I script it? There are 3 "instances" running PRICING, PRICEQA and PRICEPROD from an ORADATA directory on D:\..
If we had a failure what's involved in taking my "file" backup and getting Oracle back up again....
You have to login to all the databases with 'connect internal' command at server manager utility and shutdown all the databases one after another and take cold backup and restart databases from the same prompt. See below(KRIS is my db on win 2000).
At Win NT command prompt
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-1999 Microsoft Corp.
Oracle Server Manager Release 188.8.131.52.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 184.108.40.206.0 - Production
With the Partitioning option
JServer Release 220.127.116.11.0 - Production
SVRMGR> connect internal
SVRMGR> select name from v$database;
1 row selected.
SVRMGR> shutdown immediate;
ORACLE instance shut down.
Repeat the procedure for all the databases.