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 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 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 »