Oracle® Fail Safe Concepts and Administration Guide
Release 3.3.1 for Windows
Part No. A96684-01
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.
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.
To use the FSCMD command, open a command prompt window and type the FSCMD command line using the following syntax:
Note:For clarity, the full path for FSCMD is omitted from the syntax and examples in this chapter.
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.
Specifies the action that you want applied to the group, resource, or cluster. Use one of the actions described in the following table:
Disables Is Alive and Looks Alive polling for the named database instance until one of the following occurs:
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.
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.
Specifies the name of the cluster on which the FSCMD command will execute.
This qualifier is required.
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.
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.
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):
Shuts down a database instantaneously by aborting the database instance. If possible, use the abort mode of shutdown only in the following situations:
Database recovery procedures are performed when the database is restarted.
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:
Shuts down a database by:
|Transactional||Shuts down the database only after all of the current transactions have completed.|
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.
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.
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.
The action parameter must be the first argument to the FSCMD command.
The domain, user name, and password qualifiers supply the account information to connect to Oracle Services for MSCS. You cannot enter one of these qualifiers without entering the other two, or a syntax error will occur. If the account information is not supplied, the user logged on when the FSCMD command is invoked will be authenticated by the server. If the current account does not have the required privileges to perform operations in an Oracle Fail Safe environment, an error message will be generated.
The parser accepts either a slash (/) or a hyphen (-) as the delimiter between command qualifiers.
The command parameters and qualifiers are not case-sensitive; you can use either uppercase or lowercase letters, or a combination of both cases.
A group or resource name that contains one or more spaces must be within quotation marks; for example, "Sales Group."
You must enter a space between qualifiers in the command line. The following examples show correct and incorrect spacing in the command line:
FSCMD onlineresource salesdb.world /CLUSTER=ntclu-160 /USER=smith /PWD=smithpwd /DOMAIN=newengland
FSCMD onlineresource salesdb.world/CLUSTER=ntclu-160/USER=smith/PWD=smithpwd/DOMAIN=newengland Invalid number of parameters.
Use the Windows Event Viewer to display events that have been reported during the processing of FSCMD commands.
The following command places online an Oracle database named salesdb.world:
FSCMD onlineresource salesdb.world /CLUSTER=ntclu-160 /USER=smith /PWD=smithpwd /DOMAIN=newenglandExample 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=ORANTExample 3
The following command takes the Oracle database offline immediately:
FSCMD offlineresource salesdb.world /CLUSTER=NTCLU-160 /USER=smith /PWD=smithpwd /DOMAIN=ORANT /OFFLINE=immediateExample 4
The following command takes a group called Disk Group 1 offline:
FSCMD offlinegroup "Disk Group 1" /CLUSTER=ntclu-160
REM This script shows an example of performing a backup operation on an Oracle REM Fail Safe database.
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.