|
Index >
ORACLE Server Parameters >
control_files
control_files
Oracle 10.0.1:
| Paramter Name: | control_files
| | Description: | control file names list
| | Type: | CHAR
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 9.2.0:
| Paramter Name: | control_files
| | Description: | control file names list
| | Type: | CHAR
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 8.1.7:
| Paramter Name: | control_files
| | Description: | control file names list
| | Type: | CHAR
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 8.0.6:
| Paramter Name: | control_files
| | Description: | control file names list
| | Type: | CHAR
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 7.3.4:
| Paramter Name: | control_files
| | Description: | control file names list
| | Type: | CHAR
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Related Error Messages:
ORA-00208: number of controlfile names exceeds limit of %sCause: An attempt was made to use more controlfiles than Oracle supports.
Action: Shut down Oracle. Reduce the number of controlfiles specified in
the CONTROL_FILES parameter in the initialization parameter
file, and restart Oracle. Delete usused files.
ORA-01167: two files are the same file/group number or the same file Cause: There is an overlap of file numbers in the files specified on
the command line or the same file is specified twice. If they are
not the exact same file then one is likely to be a backup of the
other. If they are two members of the same log they must be specified
together in a group file spec. This message will also appear if
the same controlfile appears more than once in the control_files
parameter in the init.ora file. If this happens, check for
additional error messages.
Action: Confirm that the file mentioned is not a repeat of a file already
mentioned in the command. If they are different files then omit the
earlier backup. If they are members of the same log, insure they are
in the same group file specification. If this message appears because
of a duplicate controlfile, check the control_files parameter in the
init.ora file and see if a file is specified more than once.
If all files names appear to be unique, check to make sure that the
actual controlfiles themselves are unique. For example, in UNIX
check for a symbolic or a hard link to another controlfile in the list.
This parameter is documented in the
Oracle Server Reference Guide.
Search for more info about
[ control_files ]
on the Oracle FAQ.
| 
