Oracle Development Unleashed (3rd Edition)
Page 341
| RECOVER | Similar to the RECOVER DATABASE command; starts the current instance and recovers the database, if required. The recovery works as though AUTORECOVERY were set to ON. If the recovery fails, the database remains mounted but does not open. |
| database | Starts this specific instance. If no instance is specified, startup runs on the default instance. |
| mount options | Specifies three types of options for the startup: EXCLUSIVE Mounts and opens the database for a single instance to use. PARALLEL Mounts and opens the database for parallel mode. SHARED Another name for PARALLEL. RETRIES Specifies the number of retries before failing. |
Examples
STARTUP;
STARTUP MOUNT;
STARTUP PFILE='/home/oracle/init.ora' PARALLEL;
STARTUP MOUNT RESTRICT;
STARTUP FORCE;
VARIABLE
Description
VARIABLE is used to declare a bind variable to use in the current Server Manager session. The variable can be used by the EXECUTE and PRINT commands or used in a PL/SQL block.
Command Syntax
VARIABLE variable_name format
Keywords
VARIABLE definition Defines a variable name and datatype.Example
VARIABLE employee VARCHAR(25)
Page 342
Summary
Server Manager is a powerful tool that is useful for creating, managing, and tuning all your Oracle instances. The flexibility to run in command, line, or menu mode gives the user a definite advantage that many other packages do not provide. The capability to automate many of the Server Manager commands enables the database administrator to turn over some of the database operations to secondary support personnel, which can help create a higher availability system with less down time.
Overall, the Server Manager tool is valuable in the day-to-day responsibilities of every database administrator and custom developer.