Init parameterFiles & storage

CONTROL_FILES

What it controls

The control file copies the instance opens at startup.

Know this before you change it

Keep at least two copies on different disks. After moving or restoring a copy, update this before the next restart.

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'control_files';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'control_files' AND isspecified = 'TRUE';8 9-- Static: saved in the spfile, takes effect after a restart10ALTER SYSTEM SET control_files = '+DATA/ORCL/CONTROLFILE/control01.ctl', '+FRA/ORCL/CONTROLFILE/control02.ctl' SCOPE = SPFILE SID = '*';

Related scripts

• Working with the spfileShows which spfile the instance is using, where parameter files live and the order Oracle searches for them, and what SCOPE = MEMORY, SPFILE and BOTH…

Open in the parameter referenceOracle's reference

More in Files & storage

• DB_CREATE_FILE_DESTDefault location for Oracle-managed datafiles and tempfiles.
• DB_CREATE_ONLINE_LOG_DEST_NLocations for Oracle-managed online redo logs and control files. Numbered 1 to 5; each one holds a member of every group.
• DB_FILESThe most datafiles the database can have open.
• FILESYSTEMIO_OPTIONSAsynchronous and direct I/O for datafiles on file systems.
• DEFERRED_SEGMENT_CREATIONWhether new tables and indexes get space only when the first row arrives.
• RECYCLEBINWhether dropped tables go to the recycle bin so they can be flashed back.
• MAX_STRING_SIZEEXTENDED raises VARCHAR2, NVARCHAR2 and RAW limits from 4000 to 32767 bytes.