Wednesday, September 24, 2008

CONTROL_FILES

Property

Description

Parameter type

String

Syntax

CONTROL_FILES = filename [, filename ] ...

Note: The control file name can be an OMF (Oracle Managed Files) name. This occurs when the control file is re-created using the CREATE CONTROLFILE REUSE statement.

Default value

Operating system-dependent

Modifiable

No

Range of values

1 to 8 filenames

Basic

Yes

Real Application Clusters

Multiple instances must have the same value.

Every database has a control file, which contains entries that describe the structure of the database (such as its name, the timestamp of its creation, and the names and locations of its datafiles and redo files). CONTROL_FILES specifies one or more names of control files, separated by commas.

Oracle recommends that you multiplex multiple control files on different devices or mirror the file at the operating system level.

Note:

1. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = 'ARCHIVE_LAG_TARGET';

NAME

VALUE

IS

DEFAULT

ISSES_

MODIFIABLE

ISSYS_

MODIFIABLE

ISINSTANCE_

MODIFIABLE

IS

DEPRECATED

DESCRIPTION

control_files

/ora_data/mydb/control01.ctl,

/ora_data/mydb/control02.ctl

FALSE

FALSE

FALSE

FALSE

FALSE

control file names list

Oracle initializatoin parameters

No comments:

Post a Comment