How RMAN Backup Parallelly
To backup the database with multithreads can considerably speed up the backup process as long as IO throughput is good enough to handle high volume… Read More »How RMAN Backup Parallelly
Recovery Manager (RMAN)
How to Tell What State of Database
We have already known that there're 4 states in life cycle of an instance. They are idle, nomount, mount and open. In this post, we… Read More »How to Tell What State of Database
How to Find DBID
DBID Database Identifier (DBID) is a unique number that can be identified by RMAN so as to do backup and restore whenever needed. In some… Read More »How to Find DBID
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 pair of username and password, or mismatched authentication protocol, so the database that you tried to… 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