How to Write Control File into Raw Deviceby Ed ChenOctober 25, 2012August 10, 2021Control File in Raw Device? Since raw devices cannot be read/write as a normal file operation, you cannot write a controlfile directly into a raw… Read More »How to Write Control File into Raw Device
How to Map Timestamp to SCN or Vice Versaby Ed ChenOctober 24, 2012July 16, 2019If you are trying to do an incomplete recovery (also called Point-In-Time Recovery, PITR), you may want to know a System Change Number (SCN) using… Read More »How to Map Timestamp to SCN or Vice Versa
How to Check Current System Change Number (SCN)by Ed ChenOctober 23, 2012July 16, 2019System Change Number Some DBAs will schedule a cron job to capture System Change Number (SCN) periodically to save as a Timestamp/SCN mapping reference. To… Read More »How to Check Current System Change Number (SCN)
How to Resolve ORA-19809 Limit Exceeded for Recovery Filesby Ed ChenOctober 22, 2012January 18, 202010 CommentsORA-19809 We usually watch the space usage of log archive destination very closely because the database will be suspended if the space is full. Particularly,… Read More »How to Resolve ORA-19809 Limit Exceeded for Recovery Files
How to Set Client-Side Transparent Application Failover (TAF)by Ed ChenOctober 21, 2012February 21, 2021Transparent Application Failover (TAF) Besides connect-time failover to the standby database, there is a function called Transparent Application Failover (TAF) can do run-time failover to… Read More »How to Set Client-Side Transparent Application Failover (TAF)
ANALYZE vs DBMS_STATSby Ed ChenOctober 20, 2012January 23, 2021Oracle recommends to use DBMS_STATS instead of ANALYZE since 8i. Sometimes, we might get confused by the two similar tools. So I took some times… Read More »ANALYZE vs DBMS_STATS
How to Resolve ORA-30036 UNABLE TO EXTEND SEGMENT BY 8 IN UNDO TABLESPACE 'UNDOTBS1'by Ed ChenOctober 19, 2012March 28, 2021ORA-30036 This error ORA-30036 could be very serious in a situation that is described below and may make users panic: One day, a DBA was… Read More »How to Resolve ORA-30036 UNABLE TO EXTEND SEGMENT BY 8 IN UNDO TABLESPACE 'UNDOTBS1'
How to Resolve ORA-01653 Unable to Extend Table in Tablespaceby Ed ChenOctober 18, 2012March 28, 2021ORA-01653 The following two error messages are very similar. As a DBA, you'll probably meet them someday in the future. ORA-01653 is for table, ORA-01654… Read More »How to Resolve ORA-01653 Unable to Extend Table in Tablespace
How to Remove No-Name or Empty-Name Filesby Ed ChenOctober 17, 2012October 17, 2019After you finish your shell scripting, you'd like to try your scripts to see the result in your test environment. In the debug phase, you… Read More »How to Remove No-Name or Empty-Name Files
How to Resolve Only at Command is Available to Schedule Jobsby Ed ChenOctober 16, 2012May 4, 2019Only at Command Available When you are a customer DBA at your client's site to do routine db data collection or planned health check tasks,… Read More »How to Resolve Only at Command is Available to Schedule Jobs