Search <book_title>...

Veritas NetBackup™ for Oracle Administrator's Guide

Last Published: 2018-09-17

Product(s): NetBackup (8.1.2)

Bringing the database instance offline on Windows

Before you can perform a user-directed backup or restore from the client, you must take the database instance offline. You can use the Failsafe graphical user interface or the Failsafe command line (FSCMD).

To take the database instance offline with Failsafe graphical user interface

Select the Oracle database resource in the Failsafe graphical user interface.
Choose to bring it offline.

To take the database instance offline with Failsafe command line (FSCMD), type the following command:

fscmd offlineresource salesdb /cluster=curly /offline=immediate 
/domain=domainname /user=user /pwd=pwd

To bring the resource offline, the preceding command sets offline=immediate.

Alternately, based on your need you can specify one of the following as the argument:

abort	Shuts down the database instantaneously by aborting the database instance.
immediate	Shuts down the database immediately by terminating SQL statements in progress, rolling back uncommitted transactions and disconnecting users.
normal	Shuts down the database and doesn't allow new connections after the command was issued. This command waits for the connected users to disconnect before the database is shut down.
transactional	Shuts down the database only after all of the current transactions have completed.

Because the offlineresource operation shuts down the Oracle database service, enter the following command to start the Oracle database service:

net start OracleService