Recovery Manager (RMAN)

How to Resolve ORA-01507: database not mounted

by Ed Chen
May 16, 2022September 25, 2022

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

Control_File_Record_Keep_Time, How and Why

by Ed Chen
May 9, 2022September 25, 2022

Symptoms I found that RMAN backup records are lost regularly. Let's see the symptoms. 1. Obsolete Not Deleted Some backup files older than 3 months… 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 Parallelism Works

by Ed Chen
February 15, 2021September 6, 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 »

Database States Differentiations in Oracle

by Ed Chen
February 10, 2021January 12, 2023

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

by Ed Chen
December 30, 2020July 1, 2022

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, 2020December 9, 2022

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, 2020January 19, 2023
4 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, 2019December 10, 2022

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 »