Open Control Files
Go Up to Available object actions by DBMS
The control file contains information about the associated database that is required for the database to be accessed by an instance, both at startup and during normal operation.
- Note: Only the Oracle database server can modify a control file's information; no user can edit a database's control file directly.
The Control File Information dialog lets you view statistics (Type, Record Size, Records Total, Records Used, First Index, Last Index, and Last Recid) on the following control file entries:
ACM OPERATION |
ARCHIVED LOG |
BACKUP CORRUPTION |
BACKUP DATAFILE |
BACKUP PIECE |
BACKUP SET |
BACKUP REDOLOG |
BACKUP SPFILE |
CKPT PROGRESS |
COPY CORRUPTION |
DATABASE |
DATABASE BLOCK CORRUPTION |
DATABASE INCARNATION |
DATAFILE |
DATAFILE COPY |
DATAFILE HISTORY |
DELETED OBJECT |
FILENAME |
FLASHBACK LOG |
FOREIGN ARCHIVED LOG |
GUARANTEED RESTORE POINT |
INSTANCE SPACE RESERVATION |
LOG HISTORY |
MTTR |
OFFLINE RANGE |
PROXY COPY |
RECOVERY DESTINATION |
REDO LOG |
REDO THREAD |
REMOVABLE RECOVERY FILES |
RESTORE POINT |
RMAN CONFIGURATION |
RMAN STATUS |
STANDBY DATABASE MATRIX |
TABLESPACE |
TEMPORARY FILENAME |
THREAD INSTANCE NAME MAPPING |
Platform Availability
To View the Control File for a Database
- On the Navigator/Explorer, under Storage expand the Control Files node.
- DBArtisan displays the Control Files.
- In the right pane of the application, right-click a control file, and then select Open.
- DBArtisan opens the Control File Information dialog.