Control File

How to Resolve ORA-01507: database not mounted

by Ed Chen
May 16, 2022September 25, 2022

ORA-01507 ORA-01507 means that the command you want to execute cannot be done at NOMOUNT state, you should mount the database from NOMOUNT for further… 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 »

Control_File_Record_Keep_Time, How and Why

by Ed Chen
May 9, 2022April 26, 2023

In this post, I'll talk about why we should increase CONTROL_FILE_RECORD_KEEP_TIME and how to increase it. RMAN Loss of Memory Check Backup Record Keep Size… Read More »

How to Build Asymmetric Standby Database for Data Guard

by Ed Chen
July 14, 2019February 13, 2023
4 Comments

Asymmetric Data Guard Usually we build data guard environments with the symmetric architecture design on primary and standby servers, that is, single-instance to single-instance or… Read More »

How to Restore 10g RAC Database from a Backup Set

by Ed Chen
June 26, 2019May 31, 2023
2 Comments

For 12c RAC database restoration, you may check: How to Restore 12c RAC Database from a Backup Set. Suppose we have recovered 10g CRS and… Read More »

How to Change Control File Location in Oracle

by Ed Chen
February 23, 2019May 31, 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 Move Oracle Database

by Ed Chen
January 23, 2019May 31, 2023

Actually, this topic "How to Move Oracle Database" follows my previous post: How to Move ORACLE HOME. But I think it can be used in… Read More »

How RMAN Restore Database from BackupSet

by Ed Chen
October 31, 2018May 31, 2023

In this post, I will show you how to restore a single-instance database from a backup set by RMAN. For RAC restoration, you may check… Read More »

When Database is Not Consistent

by Ed Chen
October 2, 2016December 12, 2022

There are several different kinds of situation when you recover a database with inconsistent states among files. In the following, I have to assume that… Read More »

When Redo Log Files Are All Missing

by Ed Chen
April 13, 2016October 2, 2019

If your redo logs are all missing, then you have to know you will lose some data and no longer to recover it. Now let's… Read More »

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