When using Oracle Real Application Clusters (RAC) version 10.2.0.4 or later, offline backups and/or restores of control file will fail to stop the database

Article:TECH63956  |  Created: 2008-01-10  |  Updated: 2010-01-27  |  Article URL http://www.symantec.com/docs/TECH63956
Article Type
Technical Solution

Product(s)

Environment

Issue



When using Oracle Real Application Clusters (RAC) version 10.2.0.4 or later, offline backups and/or restores of control file will fail to stop the database

Error



PRKO-2002 : Invalid command line option: -c

Solution



When using Oracle Real Application Clusters (RAC) version 10.2.0.4 or later, offline backups and/or restores of control file will fail to stop the database.
The offline backup jobs are completed successful, however those get backups from ONLINE database.
The restore jobs fail with V-79-57344-832: The Database script returned an error.

The following messages are reported at the RMAN Output section in job logs.

When performing offline backups:

Executing srvctl script to stop instances immediately...
c:\oracle\product\10.2.0\db_1\bin\srvctl stop database -d rac -o immediate
PRKO-2002 : Invalid command line option: -c

Executing srvctl script to start instances in MOUNTED status...
c:\oracle\product\10.2.0\db_1\bin\srvctl start database -d rac -o mount
PRKO-2002 : Invalid command line option: -c

When performing restores of control file:
Executing srvctl script to stop instances immediately...
c:\oracle\product\10.2.0\db_1\bin\srvctl stop database -d rac -o immediate
PRKO-2002 : Invalid command line option: -c

Executing srvctl script to start instances in STARTED status...
c:\oracle\product\10.2.0\db_1\bin\srvctl start database -d rac -o nomount
PRKO-2002 : Invalid command line option: -c

Cause:

Because there is a change in Oracle RAC version 10.2.0.4 or later, srvctl command which Backup Exec uses would fail.
The "-c" option was removed from srvctl command, and there is no longer any way to provide a different connect string than the default, which requires OS authentication.

Workaround:

1. For offline backups
Stop the database using pre-command then start the database using post-command.

pre-command: <path>\srvctl stop database -d <database name> -o immediate
post-command: <path>\srvctl start database -d <database name> -o mount

Please note:
If the RAC server is remotely running from media server, "Run these commands: On each server backed up" option should be selected.

2. For restores of control file
It is recommended to manually change the database status in nomount mode before performing the restore jobs because restore jobs are usually not performed periodically.
Pre-command is also useful to change the database status.

This issue is resolved in Backup Exec 2010


Supplemental Materials

SourceETrack
Value1402793
DescriptionENH: Oracle RAC 10.2.0.4 or later is no longer supporting srvctl ?c option

SourceError Code
Value0xe0000340
DescriptionThe Database script returned an error. Refer to the Database script output section in job


Legacy ID



311491


Article URL http://www.symantec.com/docs/TECH63956


Terms of use for this information are found in Legal Notices