Backup and Recovery

How to Resolve ORA-19693: backup piece already included

by Ed Chen
July 24, 2023June 26, 2023

ORA-19693 We saw error ORA-19693 when we tried to restore some archived logs from backup sets in a newly duplicated database. RMAN> catalog start with… Read More »

How to Resolve OSD-04002: unable to open file

by Ed Chen
July 19, 2023June 19, 2023

OSD-04002 In this case, we tried to backup database to a specific location by formatting its path, but it failed with OSD-04002. RMAN> backup database… Read More »

How to Resolve ORA-45909: restore, recover or block media recovery may be in progress

by Ed Chen
June 15, 2023June 24, 2023

ORA-45909 Tried to restore a data file by RMAN, it failed with ORA-45909, ORA-19890 and ORA-19573. RMAN> restore datafile 13; ... ORA-19870: error while restoring… Read More »

How to Resolve RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP

by Ed Chen
June 14, 2023June 24, 2023

RMAN-06509 When we tried to restore a datafile from a backup piece in RMAN, we saw error RMAN-06509. RMAN> restore datafile 1 from '/home/oracle/datafile-0a1r6qon_1_1'; ...… Read More »

How to Resolve ORA-19697: standby control file not found in backup set

by Ed Chen
June 13, 2023June 24, 2023

ORA-19697 Tried to restore controlfile from a backup set by RMAN, but it failed with ORA-19697. RMAN> restore controlfile from '/home/oracle/031r656h_1_1'; ... ORA-19697: standby control… Read More »

How to Resolve ORA-19687: SPFILE not found in backup set

by Ed Chen
June 12, 2023May 3, 2023

ORA-19687 Tried to restore SPFILE from a backup set by RMAN, but it failed with ORA-19687. RMAN> restore spfile from '/backup/rman/051r6emh_1_1'; ... ORA-19687: SPFILE not… Read More »

How RMAN Restore Table

by Ed Chen
March 30, 2023June 6, 2023

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 to Resolve ORA-08186: invalid timestamp specified

by Ed Chen
March 17, 2023March 21, 2023

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-01466: unable to read data - table definition has changed

by Ed Chen
March 16, 2023March 21, 2023

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 CRS-4640: Oracle High Availability Services is already active

by Ed Chen
March 7, 2023February 15, 2023

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 »

JavaScript is not enabled. Please enable it and reload the page.