ALTER DATABASE MOUNT

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 »

How to Check Oracle Database Startup Time

by Ed Chen
September 17, 2021January 24, 2023

Startup Time Varies To check Oracle database startup or restart time, we have to know the difference between instance startup time and database open time.… Read More »

Srvctl Add Database Example

by Ed Chen
December 5, 2020December 15, 2022

Add RAC DB Let me ask you a question, why would you like to add a RAC database to a cluster? In my experience, there're… Read More »

How to Start Oracle Database

by Ed Chen
September 28, 2019January 5, 2023

Start Oracle Database To start an Oracle database, you have to know which database you want to start. This includes at least two things, Oracle… Read More »

How to Change Control File Location in Oracle

by Ed Chen
February 23, 2019December 10, 2022

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, 2019March 14, 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 »

Duplicate a Standby Database (2/4) - With Backup-Based Duplication

by Ed Chen
January 28, 2013December 11, 2022

Duplicate a Standby Database (1/4) - With Active Database Duplication Backup-Based duplication requires to connect to the target database, and one copy of database backups… Read More »

Duplicate a Standby Database (1/4) - With Active Database

by Ed Chen
January 27, 2013December 11, 2022

Duplicate a Standby Database (0/4) - An Overview For 19c Standby database duplication, you may check the post: How to Duplicate a 19c Physical Standby… Read More »