Control File

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

by Ed Chen
October 4, 2021October 17, 2021

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 »

When the Controlfile is Missing

by Ed Chen
December 27, 2012January 19, 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 »