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-01507: database not mounted

by Ed Chen
May 16, 2022September 17, 2023

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, 2022November 12, 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, 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 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 »

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