Re: comp.databases.oracle

From: 170 Systems <170sys_at_netcom.com>
Date: Fri, 21 Oct 1994 14:16:30 GMT
Message-ID: <170sysCy10zI.6KM_at_netcom.com>


You said...
: I am trying to backup the Oracle Data Base on Novll 3.11. Has anyone have
: any idea what NLM's should be unloaded to backup the DataBase . I know we
: can shutdown the Data Base from SQLPLUS. That does not help me much.

  1. SQL*Plus cannot be used to shut down the database. Use SQL*DBA to shut down the database:

   Oracle 6.x.x

       SQLDBA> SHUTDOWN NORMAL    Oracle 7.x.x

       SQLDBA> CONNECT INTERNAL
       SQLDBA> SHUTDOWN NORMAL

b) No NLMs need to be unloaded to backup the database. Just make sure that

   you back up all database, control, and redo log files. If you need to    free up memory to make the backup work then run ORAUNLD.NCF to unload    Oracle NLMs. If you do this then run ORALOAD.NCF after the backup is    complete to re-load the Oracle NLMs.

Dan Kennedy
170 Systems, Inc.
dkennedy_at_170systems.com Received on Fri Oct 21 1994 - 15:16:30 CET

Original text of this message