Property | Description |
Parameter type | String |
Syntax |
Note: The control file name can be an OMF (Oracle Managed Files) name. This occurs when the control file is re-created using the |
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 |
No comments:
Post a Comment