Recovery Manager (RMAN)

How to Resolve ORA-01507: database not mounted

by Ed Chen
May 16, 2022May 24, 2022

ORA-01507 ORA-01507 means that the command you want to execute cannot be done at NOMOUNT state, you should try to mount the database from NOMOUNT… Read More »

RMAN Backup Records are Lost Regularly

by Ed Chen
May 9, 2022May 10, 2022

I found something unusual about RMAN backup records. 1. Obsolete Not Deleted Some backup files older than 3 months are definitely obsolete according to redundancy… Read More »

How to Resolve RMAN-01009: syntax error: found

by Ed Chen
April 25, 2022May 10, 2022

RMAN-01009 There're several error patterns that throw RMAN-01009 during RMAN statement execution. found "database" found "list" found "identifier" RMAN-01009 means that the word at the… Read More »

How to Resolve ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

by Ed Chen
November 19, 2021April 5, 2022

ORA-01610 Tried to perform RECOVER DATABASE on a mounted database by SQL statement, but it failed with ORA-01610. SQL> recover database until cancel; ORA-00283: recovery… Read More »

How RMAN Backup Parallelly

by Ed Chen
February 15, 2021April 27, 2022

RMAN Parallelism To backup the database with multithreads can considerably speed up the backup process as long as IO throughput is good enough to handle… Read More »

How to Tell What State of Database

by Ed Chen
February 10, 2021February 3, 2021

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 Oracle Find DBID

by Ed Chen
December 30, 2020September 18, 2021

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 Resolve ORA-15173 Error Message

by Ed Chen
November 4, 2020September 25, 2021

ORA-15173: entry 'pdbseed' does not exist in directory There're two operations that you might see ORA-15173. Creating a Multitenant Database Creating a Pluggable Database ORA-15173… Read More »

How to Resolve ORA-01017: invalid username/password; logon denied

by Ed Chen
January 18, 2020October 22, 2021
2 Comments

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 Restore RAC Database from RMAN Backup Set

by Ed Chen
July 4, 2019October 1, 2021

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 »