Copy of Oracle FAQ ORACLE RECOVERY without DUL
ORAFAQ HOME | ORAFAQ ASK QUESTION | ORAFAQ ADD INFO | ORAFAQ SEARCH | ORAFAQ E-MAIL
 

Index > ORACLE Server Parameters > standby_file_management

standby_file_management

Oracle 10.0.1:

Paramter 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:

Paramter 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 controlfile 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.

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

ORAFAQ HOME | ORAFAQ ASK QUESTION | ORAFAQ ADD FAQ | ORAFAQ SEARCH | ORAFAQ E-MAIL
All content of this page is copy from www.orafaq.com