Cold Backup help on NT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Cold Backup help on NT

Hybrid View

  1. #1
    Join Date
    May 2001
    Posts
    2

    Unhappy

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

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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

    C:\>svrmgrl

    Oracle Server Manager Release 3.1.6.0.0 - Production

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

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

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

    Repeat the procedure for all the databases.
    Reddy,Sam

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