Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Index > ORACLE Server Parameters > standby_file_management

standby_file_management


Oracle 11.1.0:

Parameter Name:standby_file_management
Description:if auto then files are created/dropped automatically on standby
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:standby_file_management
Description:if auto then files are created/dropped automatically on standby
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:standby_file_management
Description:if auto then files are created/dropped automatically on standby
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Parameter Name:standby_file_management
Description:if auto then files are created/dropped automatically on standby
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 8.1.7:

No such parmeter in Oracle 8.1.7.

Oracle 8.0.6:

No such parmeter in Oracle 8.0.6.

Oracle 7.3.4:

No such parmeter in Oracle 7.3.4.

Related Error Messages:

ORA-01273: STANDBY_FILE_MANAGEMENT = AUTO needs COMPATIBLE = %s or higher
    Cause: The COMPATIBLE initialization parameter was not set to the correct value for setting STANDBY_FILE_MANAGEMENT to AUTO.

    Action: Restart the instance with COMPATIBLE set to the correct release.*Cause: Automated standby file management was disabled, so an added file

ORA-01274: cannot add datafile '%s' - file could not be created

    Cause: Automated standby file management was disabled, so an added file could not automatically be created on the standby. The error from the creation attempt is displayed in another message. The control file file entry for the file is 'UNNAMEDnnnnn'.

    Action: Use the ALTER DATABASE CREATE DATAFILE statement to create the file, or set STANDBY_FILE_MANAGEMENT to AUTO and restart standby recovery.

ORA-01275: Operation %s is not allowed if standby file management is automatic.

    Cause: An operation that renames, adds, or drops a file was attempted at a standby database and STANDBY_FILE_MANAGEMENT was set to AUTO.

    Action: Set STANDBY_FILE_MANAGEMENT to MANUAL if the operation must be performed.

ORA-16788: unable to set one or more database configuration property values

    Cause: This situation occurs when the database resource guard attempted to set database configuration property values into the database by issuing "ALTER SYSTEM" or "ALTER DATABASE" commands. Typical causes of this error are: a) The values of redo transport-related properties have syntax errors; b) The Value of LogArchiveTrace is out of range; c) Database initialization parameter STANDBY_FILE_MANAGEMENT cannot be set to AUTO because the database compatability is not set to 9.0.0.0.0 or higher.

    Action: Check the Data Guard broker log to see which property has the problem and reset the property correctly.


This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ standby_file_management ] on the Oracle FAQ.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US