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....
Thanks...