TEMPFILE

How to Resolve ORA-25153: Temporary Tablespace is Empty

by Ed Chen
March 14, 2015January 22, 2023
2 Comments

ORA-25153 After activating a physical standby database, I found some SQL statements returned ORA-25153: Description ORA-25153: Temporary Tablespace is Empty Cause An attempt was made… Read More »

How to Resolve ORA-01652: unable to extend temp segment by 8192 in tablespace

by Ed Chen
May 31, 2014November 13, 2021

ORA-01652 or ORA-1652 1. Permanent Tablespace SQL> INSERT INTO ERP35.PAY_HIST SELECT * FROM ERP35.PAY_TRANS; INSERT INTO ERP35.PAY_HIST SELECT * FROM ERP35.PAY_TRANS; * ERROR at line… Read More »

When Tempfiles are Missing

by Ed Chen
February 25, 2013January 19, 2021

Backing up a whole database including all datafiles by RMAN does not include temp files, this is because temp files are not required to restore… Read More »

Duplicate a Standby Database (3/4) - With Targetless Duplication

by Ed Chen
January 29, 2013December 11, 2022

Duplicate a Standby Database (2/4) - With Backup-Based Duplication Tagetless duplication does not require RMAN to connect to the target database or catalog, but it… Read More »

Duplicate a Standby Database (2/4) - With Backup-Based Duplication

by Ed Chen
January 28, 2013December 11, 2022

Duplicate a Standby Database (1/4) - With Active Database Duplication Backup-Based duplication requires to connect to the target database, and one copy of database backups… Read More »

Duplicate a Standby Database (1/4) - With Active Database

by Ed Chen
January 27, 2013December 11, 2022

Duplicate a Standby Database (0/4) - An Overview For 19c Standby database duplication, you may check the post: How to Duplicate a 19c Physical Standby… Read More »

When Several Datafiles Are Missing - Restore From the Standby Database

by Ed Chen
January 25, 2013December 12, 2022

Not only the local backups can save the datafiles, but also the standby database can be a source to restore the datafiles. There are four… Read More »

When Almost Everything of a Database is Missing

by Ed Chen
January 21, 2013December 8, 2021

I must assume that your Oracle software installed on OS is ready or not damaged before proceeding, otherwise, you should fix the software problem first.Three… Read More »

When Some of the Archived Logs are Missing

by Ed Chen
January 20, 2013December 8, 2021

If the missing archived logs are created before at least one database backup sets, there would be no problem at all while restoring a database.… Read More »

How to Perform Database Point-In-Time Recovery

by Ed Chen
December 30, 2012December 8, 2021

Sometimes, DBA may want the database back to a specific time just before a big mistake happened on the database. This is called database point-in-time… Read More »