oracle control files[@more@]

Oracle Control Files

Version 10.2

General Information

Current Control Files

SELECT value
FROM gv$parameter
WHERE name = 'control_files';

SELECT RPAD(SUBSTR(name,1,50),51,' ') "CONTROL FILE NAME"
FROM gv$controlfile;

Dependent Objects

V_$CONTROLFILE

V_$CONTROLFILE_RECORD_SECTION

Create Control File

Reuse previously existing control file(s) if they exist

CREATE CONTROLFILE [REUSE]
DATABASE
;

STARTUP NOMOUNT;

CREATE CONTROFILE REUSE
SET DATABASE orabase
RESETLOGS;

ALTER DATABASE OPEN RESETLOGS;

Reuse previously existing control file(s) if they exist

CREATE CONTROLFILE [REUSE]
DATABASE
;

STARTUP NOMOUNT;

CREATE CONTROFILE REUSE
SET DATABASE orabase
NORESETLOGS;

Move Control Files

Relocate Control Files

conn / as sysdba

show parameter control_files

shutdown immediate

host

$ cp /control files

$ vi /

$ exit

create spfile from pfile='/oracle/product/ora102/dbs/init.ora';

startup

show parameter control_files

host

$ rm /control files

Backup Control Files

To Trace

ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

To Binary File

ALTER DATABASE BACKUP CONTROLFILE TO 'c:tempcontrol.bkp';

Oracle control files