0341-0342

Previous | Table of Contents | Next

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.

Previous | Table of Contents | Next