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
Backup and Recovery
How to Resolve ORA-08186: invalid timestamp specified
ORA-08186 Tried to perform a flashback query, but it failed with ORA-08186. SQL> select count(*) cnt from t1 as of timestamp to_timestamp('3023-02-20 00:53:08', 'yyyy-mm-dd hh24:mi:ss');… Read More »How to Resolve ORA-08186: invalid timestamp specified
How to Resolve ORA-01466: unable to read data - table definition has changed
ORA-01466 Tried to perform a flashback query, but it failed with ORA-01466. SQL> select count(*) cnt from t1 as of timestamp to_timestamp('2023-02-19 22:15:00', 'yyyy-mm-dd hh24:mi:ss');… Read More »How to Resolve ORA-01466: unable to read data - table definition has changed
How to Resolve CRS-4640: Oracle High Availability Services is already active
CRS-4640 We observed that osysmond.bin was taking too much memory and the usage of SWAP was increasing. At this moment, to prevent the server from… Read More »How to Resolve CRS-4640: Oracle High Availability Services is already active
How to Resolve RMAN-06094: datafile 1 must be restored
RMAN-06094 Tried to recover a database, but it failed with RMAN-06094. RMAN> recover database; ... RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571:… Read More »How to Resolve RMAN-06094: datafile 1 must be restored
How to Resolve RMAN-03031: this option of set command needs to be used inside a run block
RMAN-03031 Saw error RMAN-03031 like this: RMAN> set newname for datafile 1 to '/oradata/ORCLCDB/system01.dbf'; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================… Read More »How to Resolve RMAN-03031: this option of set command needs to be used inside a run block
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
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-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