| General Information |
| Current Control Files |
col value format a41
SELECT value
FROM gv$parameter
WHERE name = 'control_files';
SELECT RPAD(SUBSTR(name,1,50),51,' ') "CONTROL FILE NAME"
FROM gv$controlfile; |
| Dependent Objects |
| GV_$CONTROLFILE |
GV_$CONTROLFILE_RECORD_SECTION |
|
| |
| Create Control File |
| Reuse previously existing control file(s) if they exist |
CREATE CONTROLFILE [REUSE]
DATABASE <database_name>
<RESETLOGS | NORESETLOGS>; |
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 <database_name>
<RESETLOGS | NORESETLOGS>; |
STARTUP NOMOUNT;
CREATE CONTROFILE REUSE
SET DATABASE orabase
NORESETLOGS; |
| |
| Move Control Files |
Relocate Control Files |
conn / as sysdba
SQL> show parameter control
SQL> shutdown immediate
SQL> create pfile from spfile;
SQL> host
-- use cp to copy the control file from its current
location
-- to the new location
$ cp $ORACLE_BASE/oradata/orabase/control02.ctl /u02/oradata/orabase/control02.ctl
$ vi $ORACLE_HOME/dbs/initorabase.ora
-- change the control file location to the new
location
-- save the changes and exit vi
$ exit
SQL> create spfile from pfile;
startup
show parameter control
host
-- remove the copy of the control file in the
original location
$ rm $ORACLE_BASE/oradata/orabase/control02.ctl |
| |
| Backup Control Files |
| To Text File |
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
or
ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS 'c:\temp\control.bkp'; |
| To Binary File |
ALTER DATABASE BACKUP CONTROLFILE TO 'c:\temp\control.bkp'; |