Oracle Controlfile Types
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 »Oracle Controlfile Types
Control File
How to Resolve ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage
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 »How to Resolve ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage
Where is Oracle Control File Location
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 »Where is Oracle Control File Location
How to Change Control File Location in Oracle
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 Change Control File Location in Oracle
How to Configure AUTOBACKUP
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 Configure AUTOBACKUP
How to Backup Controlfile
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 Backup Controlfile
How to Restore Controlfile
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 Restore Controlfile
How to Check Control File Size
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 Check Control File Size
How to Write Control File into Raw Device
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 »How to Write Control File into Raw Device