Control File

How to Resolve ORA-19697: standby control file not found in backup set

by Ed Chen
June 13, 2023June 24, 2023

ORA-19697 Tried to restore controlfile from a backup set by RMAN, but it failed with ORA-19697. RMAN> restore controlfile from '/home/oracle/031r656h_1_1'; ... ORA-19697: standby control… Read More »

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, 2021June 13, 2023

CONTROLFILE_TYPE 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… 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 6, 2023
4 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, 2019November 7, 2023

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 RMAN Backup Controlfile

by Ed Chen
December 27, 2012June 15, 2023

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, 2012June 14, 2023

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, 2012December 11, 2022

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 »

JavaScript is not enabled. Please enable it and reload the page.