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