How RMAN List Backup Piece Content
Backup Piece A backup piece is a physical file that contain a part of backup targets in a backup operation. In a backup piece, the… Read More »How RMAN List Backup Piece Content
Backup and Recovery
Control_File_Record_Keep_Time, How and Why
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 »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-32005: error while parsing size specification
ORA-32005 When I tried to increase the size of Fast Recovery Area (FRA) from 1TB to 1.5TB, it failed with ORA-32005. SQL> show parameter db_recovery_file_dest_size… Read More »How to Resolve ORA-32005: error while parsing size specification
How to Resolve RMAN-06023: no backup or copy of datafile found to restore
RMAN-06026 and RMAN-06023 Found errors RMAN-06026 and RMAN-06023 after several hours of database restore. RMAN> restore database; ... RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK… Read More »How to Resolve RMAN-06023: no backup or copy of datafile found to restore
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 to Resolve ORA-38707: Media recovery is not enabled
ORA-38707 Tried to enable flashback of whole database, but it failed with ORA-38706 and ORA-38707. SQL> alter database flashback on; alter database flashback on *… Read More »How to Resolve ORA-38707: Media recovery is not enabled
How to Resolve ORA-01123: cannot start online backup; media recovery not enabled
ORA-01123 Tried to make the whole database enter backup mode, but it failed with ORA-01123. SQL> alter database begin backup; alter database begin backup *… Read More »How to Resolve ORA-01123: cannot start online backup; media recovery not enabled
How Oracle Check Archivelog Mode
Check Archivelog Mode There're two ways that can check whether archivelog mode is enabled or not. By SQL*Plus command To use SQL*Plus specific command, you… Read More »How Oracle Check Archivelog Mode
How to Resolve ORA-00283: recovery session canceled due to errors
ORA-00283 and ORA-00264 When you saw both ORA-00283 and ORA-00264 at the same time like the following: SQL> recover database; ORA-00283: recovery session canceled due… Read More »How to Resolve ORA-00283: recovery session canceled due to errors