Control File

How to Resolve ORA-00214: control file

by Ed Chen
May 10, 2022August 23, 2022

ORA-00214 Tried to startup or mount a database, we got ORA-00214. SQL> startup ORACLE instance started. ... ORA-00214: control file '/u01/app/oracle/fast_recovery_area/ORCLCDB/control02.ctl' version 2286 inconsistent with… Read More »

Oracle Controlfile Types

by Ed Chen
November 20, 2021April 5, 2022

After solving ORA-01610, you might have a question: how do I know the currently used controlfile is a BACKUP one or not? We take the… Read More »

How to Resolve ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

by Ed Chen
October 4, 2021March 24, 2022
2 Comments

ORA-00245 Tried to create a standby controlfile from a RAC database, but it failed with ORA-00245 or ORA-245. [oracle@primary01 ~]$ sqlplus / as sysdba ...… Read More »

Where is Oracle Control File Location

by Ed Chen
September 21, 2020August 9, 2021

Oracle Control File Location We use different ways to find out the location of control file when the database is online and offline. 1. When… Read More »

How to Change Control File Location in Oracle

by Ed Chen
February 23, 2019October 3, 2021

ALTER SYSTEM SET CONTROL_FILES In this post, I will show you how to change control file location in a single-instance and a cluster database. Change… Read More »

How to Configure AUTOBACKUP

by Ed Chen
December 27, 2012December 1, 2021

Check AUTOBACKUP ON The default configuration of AUTOBACKUP is ON in RMAN. For those databases which are disabled, we can enable it like this: RMAN>… Read More »

How to Backup Controlfile

by Ed Chen
December 27, 2012December 1, 2021

Backup Controlfile Since the controlfile is a very busy file on reading and writing when your database is open, you can't copy the file directly… Read More »

How to Restore Controlfile

by Ed Chen
December 27, 2012December 8, 2021

When the controlfile is missing, the database can't mount the controlfile, you need to restore the controlfile before going further. But first of all, you… Read More »

How to Check Control File Size

by Ed Chen
December 14, 2012November 26, 2020

Check Control File Size Control file is a file that have several file attributes including size, but when database is stored upon raw devices, your… Read More »

How to Write Control File into Raw Device

by Ed Chen
October 25, 2012August 10, 2021

Control File in Raw Device? Since raw devices cannot be read/write as a normal file operation, you cannot write a controlfile directly into a raw… Read More »