How to Backup SPFILE
Timings to Backup SPFILE In case that we need to restore SPFILE to the original state at a later time, we should backup SPFILE in… Read More »How to Backup SPFILE
Recovery Manager (RMAN)
How RMAN Restore Table
Recover Table by RMAN We have talked about how to restore a table from the recyclebin earlier. By using the feature of recyclebin, we can… Read More »How RMAN Restore Table
How to Resolve ORA-01507: database not mounted
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 »How to Resolve ORA-01507: database not mounted
Control_File_Record_Keep_Time, How and Why
In this post, I'll talk about why we should increase CONTROL_FILE_RECORD_KEEP_TIME and how to increase it. RMAN Loss of Memory Check Backup Record Keep Size… Read More »Control_File_Record_Keep_Time, How and Why
How to Resolve RMAN-01009: syntax error: found
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 RMAN-01009: syntax error: found
How to Resolve ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
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 to Resolve ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
How RMAN Parallelism Works
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 RMAN Parallelism Works
Database States Differentiations in Oracle
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 »Database States Differentiations in Oracle
How to Find Oracle 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 Oracle DBID
How to Resolve ORA-15173 Error Message
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-15173 Error Message