ALTER DATABASE OPEN RESETLOGS

How to Resolve ORA-01149: cannot shutdown - file 1 has online backup set

by Ed Chen
July 7, 2021December 12, 2022

ORA-01149 ORA-01149 means that some data files are in backup mode, so you can't shutdown the database in this moment. SQL> shutdown immediate; ORA-01149: cannot… Read More »

How to Resolve ORA-01624: log needed for crash recovery of instance

by Ed Chen
February 27, 2021May 19, 2022

ORA-01624 ORA-01624 means that the redo log group that you want to operate with is needed for recovery once the database startup after a crash.… Read More »

How to Change DB_NAME of a RAC Database

by Ed Chen
January 30, 2021December 9, 2022

In previous post, we have talked about how to change DBID of a RAC database. In this post, we will talk about how to change… Read More »

How to Change DBID of a RAC Database

by Ed Chen
January 27, 2021December 9, 2022

In previous post, we have talked about how to change both DB_NAME and DB_UNIQUE_NAME of a single-instance database. In this post, we will talk about… Read More »

How to Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database

by Ed Chen
January 23, 2021October 24, 2021

In previous post, we have talked about how to change DB_UNIQUE_NAME of a single-instance database. In this post, we will talk about how to change… Read More »

How to Change DB_NAME of a Single-Instance Database

by Ed Chen
January 16, 2021March 8, 2022

In previous post, we have talked about how to change DBID of a single-instance database. In this post, we will talk about how to change… Read More »

How to Change DBID of a Single-Instance Database

by Ed Chen
January 13, 2021September 24, 2021

For a duplicate database, you may want to change its Database Identifier (DBID) only in order to distinguish this one from another. For a RAC… Read More »

How to Restore RAC Database from RMAN Backup Set

by Ed Chen
July 4, 2019December 10, 2022

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

How RMAN Restore Database from BackupSet

by Ed Chen
October 31, 2018December 10, 2022

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 »