How to Find DBID
In some situations, you may have to know DBID of the database to let backup catalog know the subsequent steps are for specific database in… Read More »How to Find DBID
Recovery Manager (RMAN)
How to Resolve ORA-15173: entry 'pdbseed' does not exist in directory
Saw errors when creating a 19c RAC database by DBCA like the following. [oracle@primary01 ~]$ vi $ORACLE_BASE/cfgtoollogs/dbca/ORCLCDB/trace.log_2020-10-13_19-42-05PM ... ORA-19504: failed to create file "+DATA01/ORCLCDB/pdbseed/sysaux01.dbf" ORA-17502:… Read More »How to Resolve ORA-15173: entry 'pdbseed' does not exist in directory
How to Resolve ORA-01017: invalid username/password; logon denied
ORA-01017 ORA-01017 means that you either provided an incorrect username or password, so the database that you tried to connect denied you to logon. SQL>… Read More »How to Resolve ORA-01017: invalid username/password; logon denied
How to Restore 12c RAC Database from a Backup Set
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
How to Restore 10g RAC Database from a Backup Set
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 Restore 10g RAC Database from a Backup Set
How to Change SPFILE Location in Oracle
In this post, I will talked about how to change SPFILE location in a single-instance database and in a RAC database. Change SPFILE Location of… Read More »How to Change SPFILE Location in Oracle
How to Change Control File Location in Oracle
In this post, I will show you how to change control file location in a single-instance and a cluster database. Change Control File Location of… Read More »How to Change Control File Location in Oracle
How to Resolve RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
RMAN-06149 Trying to backup a database in the development environment. But failed with "RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode". RMAN> backup database tag 'BEFORE-IMPORT-PRODUCTION-2018Q1';… Read More »How to Resolve RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
Online Archived Logs vs Backup Archived Logs
Let me make it short first. If you can tell the difference between the following two RMAN statements, then you have already know the difference.… Read More »Online Archived Logs vs Backup Archived Logs
How to Compress RMAN Backupset
You can enable the compression feature of RMAN by the following 2 ways: One time setting RMAN> show all; RMAN configuration parameters for database with… Read More »How to Compress RMAN Backupset