In this post, we will talk about how to change DB_NAME of a single-instance database. First of all, let's see the current status. SQL> select… Read More »How to Change DB_NAME of a Single-Instance Database
ALTER DATABASE OPEN RESETLOGS
For a duplicate database, you may want to change its Database Identifier (DBID) only in order to distinguish this one from another. Here we use… Read More »How to Change DBID of a Single-Instance Database
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 to Restore 12c RAC Database from a Backup Set
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 »How RMAN Restore Database by a Backup Set
It depends, depends on what kind of backup mode that you had taken. If you took a full backup by the following ways, then you… Read More »Are All Oracle Full Backups Consistent?
You can have this one: SQL> ALTER DATABASE OPEN READ ONLY; And also this one: SQL> ALTER DATABASE OPEN RESETLOGS; But there's NO combined statement like… Read More »Can I Open Database to READ ONLY with RESETLOGS?