DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2001


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

  2. #2
    Join Date
    Feb 2000
    Washington DC
    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.

    C:\>set local=kris


    Oracle Server Manager Release - Production

    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    Oracle8i Enterprise Edition Release - Production
    With the Partitioning option
    JServer Release - Production

    SVRMGR> connect internal
    SVRMGR> select name from v$database;
    1 row selected.
    SVRMGR> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.

    Repeat the procedure for all the databases.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.