Skip Headers

Oracle® Fail Safe Concepts and Administration Guide
Release 3.3.1 for Windows
Part No. A96684-01
Go To Table Of Contents
Contents
Go To Index
Index

Previous Next

5
The FSCMD Command-Line Interface

Oracle Fail Safe provides a command-line interface as an alternative to using Oracle Fail Safe Manager for managing resources in a cluster. For example, using the FSCMD command at the command prompt, you can take Oracle resources offline or bring them online. The FSCMD command is useful if you want to manage Oracle resources from batch programs or scripts.


FSCMD

The FSCMD command allows you to perform many of the same operations that you can perform with Oracle Fail Safe Manager. To run the FSCMD command, specify the full path, beginning with the location where Oracle Fail Safe Manager is installed: <Oracle_Home>\fs\fsmgr\bin\fscmd.exe.

If you do not use this path, the Windows operating system will not be able to locate the FSCMD command.


Note:

Because of possible conflicts with other Oracle products installed on your system, do not include the directory <Oracle_Home>\fs\fsmgr\bin in your system path environment variable.

Format

To use the FSCMD command, open a command prompt window and type the FSCMD command line using the following syntax:

FSCMD <action> <name> /CLUSTER=cluster_name [<qualifier>]


Note:

For clarity, the full path for FSCMD is omitted from the syntax and examples in this chapter.

Description

Oracle Fail Safe supplies the FSCMD command, which you can use in scripts to do many of the same functions that you can do with Oracle Fail Safe Manager. For example, you can use the FSCMD command to take cluster resources offline before you perform nightly backups, and then place the resources online again when the backups are complete.

You can execute the FSCMD command on any system where Oracle Fail Safe Manager is installed. (The FSCMD software is a component of Oracle Fail Safe Manager.)

When you execute the FSCMD command, you can specify the name of a log file to capture the results of long-running operations.

Command Parameters

action

Specifies the action that you want applied to the group, resource, or cluster. Use one of the actions described in the following table:

Action Description
DISABLEISALIVE Disables Is Alive and Looks Alive polling for the named database instance until one of the following occurs:
  • You explicitly enable Is Alive polling with the FSCMD ENABLEISALIVE command.

  • The instance is placed online.

The Verify Group command will issue a warning if it finds that Is Alive polling is disabled for an instance, but it will not reenable Is Alive polling.

DUMPCLUSTER Prints cluster configuration information. Output from this operation is written to the file name that you specify with the /LOGFILE qualifier.
ENABLEISALIVE Enables Is Alive and Looks Alive polling for the named database instance if they were disabled with the FSCMD DISABLEISALIVE command.
MOVEGROUP Moves the group of resources to the node that you specify with the /NODE command qualifier. Output from this operation is written to the file name that you specify with the /LOGFILE qualifier.
ONLINEGROUP Places the group online.
ONLINERESOURCE Places the resource online.
OFFLINEGROUP Takes the group offline.
OFFLINERESOURCE Takes the resource offline. For Oracle database resources, this operation requires the /OFFLINE command qualifier.
VERIFYGROUP Verifies a single group configured by Oracle Fail Safe. Output from this operation is written to the file name that you specify with the /LOGFILE qualifier.
VERIFYALLGROUPS Verifies all groups configured by Oracle Fail Safe. Output from this operation is written to the file name that you specify with the /LOGFILE qualifier.
VERIFYCLUSTER Verifies the cluster configuration. Output from this operation is written to the file name that you specify with the /LOGFILE qualifier.

The action parameter must be the first argument to the FSCMD command.

name

The name of the resource or group on which you want the FSCMD command to take action. For example, PERSONNEL.world is a valid name for a single-instance database resource.

This parameter must follow the action parameter. The name parameter is required for all FSCMD command actions except for the DUMPCLUSTER, VERIFYALLGROUPS, and VERIFYCLUSTER actions.

Command Qualifiers

/CLUSTER=cluster-name

Specifies the name of the cluster on which the FSCMD command will execute.

This qualifier is required.

/LOGFILE=file-name

Specifies the location of the log file that a long-running operation creates when the DUMPCLUSTER, MOVEGROUP, VERIFYCLUSTER, VERIFYGROUP, or VERIFYALLGROUPS action is performed. If you do not specify the LOGFILE qualifier, the log file is written to the current output device, which is typically the system console.

This qualifier is optional.

/NODE=node-name

Use this qualifier only with the MOVEGROUP action to specify the name of the node where you want to move a group.

This qualifier is required when you specify the MOVEGROUP action.

/OFFLINE=offline-option

Use this qualifier only when you specify the OFFLINERESOURCE action to take an Oracle resource offline. For Oracle databases, if you do not supply one of the offline-option modes from the following table, the resource will be taken offline in the immediate mode (the default):

Mode Description
Abort Shuts down a database instantaneously by aborting the database instance. If possible, use the abort mode of shutdown only in the following situations:
  • The database or one of its applications is functioning irregularly and neither the immediate nor the normal mode of shutdown works.

  • You need to shut down the database instantaneously (for example, you know a power shutdown is going to occur in one minute).

Database recovery procedures are performed when the database is restarted.

Immediate Shuts down a database immediately by terminating SQL statements in progress, rolling back uncommitted transactions, and disconnecting users. The immediate mode is the default mode to take a resource offline. If possible, choose the immediate mode only in the following situations:
  • A power shutdown is going to occur soon.

  • The database or one of its applications is functioning irregularly.

  • You are preparing to perform a database backup operation.

Normal Shuts down a database by:
  • Disallowing new connections after the database shutdown command is issued

  • Waiting for all connected users to disconnect before actually shutting down the database

Transactional Shuts down the database only after all of the current transactions have completed.
/DOMAIN=domain-name

Specifies the domain in which the user account (specified with the /USER qualifier) is located.

This qualifier is optional on all clients except Windows 2000 clients; however, if you enter a domain name, you must also enter a user name and a password.

/PWD=password

Specifies the password for the account that is specified with the /USER qualifier.

This qualifier is optional on all clients except Windows 2000 clients; however, if you enter a password, you must also enter a user name and a domain name.

/USER=username

Specifies the user name for a domain account that has Administrator privileges on all cluster nodes.

This qualifier is optional on all clients except Windows 2000 clients; however, if you enter a user name, you must also enter a password and a domain name.

Usage Notes


Command Examples

Example 1

The following command places online an Oracle database named salesdb.world:

FSCMD onlineresource salesdb.world /CLUSTER=ntclu-160 /USER=smith /PWD=smithpwd /DOMAIN=newengland

Example 2

The following command verifies all groups on the cluster NTCLU-160 and writes verify operation output to the log file C:\temp\fsverify.log.

FSCMD verifyallgroups /LOGFILE=c:\temp\fsverify.log /CLUSTER=ntclu-160 /USER=smith /PWD=smithpwd /DOMAIN=ORANT 

Example 3

The following command takes the Oracle database offline immediately:

FSCMD offlineresource salesdb.world /CLUSTER=NTCLU-160 /USER=smith /PWD=smithpwd /DOMAIN=ORANT /OFFLINE=immediate

Example 4

The following command takes a group called Disk Group 1 offline:

FSCMD offlinegroup "Disk Group 1" /CLUSTER=ntclu-160

Script Example

The following script backs up a database called db.world. This example assumes the database is contained in a group called FS Group1 running on a cluster called NTCLU-140, on node NTCLU-141.

REM   This script shows an example of performing a backup operation on an Oracle REM   Fail Safe database. 
REM
REM 1. Move the group FS Group1 that contains the database to the node on
REM which the backup operation will run. Alternatively, you can create file
REM share resources for each cluster disk to allow the backup software to
REM access the drives through a virtual server address regardless of which
REM cluster node currently owns them. fscmd movegroup "FS Group1" /node=NTCLU-141 /cluster=NTCLU-140 REM 2. Disable Is Alive polling for the database resource. fscmd disableisalive db.world /cluster=NTCLU-140 REM 3. Begin the backup operation here. As an example, the following lines
REM copy files using the copy function on the operating system. copy e:\ofsdb\ofs1\data\*.ora e:\backup\data copy e:\ofsdb\ofs1\log\*.ora e:\backup\log copy e:\ofsdb\ofs1\param\*.ora e:\backup\param REM 4. Reenable Is Alive polling for the database resource. fscmd enableisalive db.world /cluster=ntclu-140 REM The backup operation is complete.


Previous Next
Oracle Logo
Copyright © 1996, 2002 Oracle Corporation

All rights reserved
Go To Table Of Contents
Contents
Go To Index
Index