Ed Chen Logic

ksbsrv: No Startup Acknowledgement From Forked Process After 30 Seconds

by Ed Chen
February 26, 2013March 28, 2018

If the database server was in performance bottlenecks, there could be various kinds of errors. Here is one case of low memory. First of all,… Read More »

When Tempfiles are Missing

by Ed Chen
February 25, 2013March 14, 2023

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 »

User-Managed Backup (4/4) - Online Backup A Tablespace

by Ed Chen
February 24, 2013March 28, 2018

User-Managed Backup (3/4) - Online Backup All DatafilesThe process of backing up a whole database online is same as datafiles, you must make the tablespace… Read More »

User-Managed Backup (3/4) - Online Backup All Datafiles

by Ed Chen
February 23, 2013December 12, 2022

User-Managed Backup (2/4) - Offline Backup The Whole Database With ARCHIVELOG ModeTo backup all datafiles online with user-managed mode, you can force the all datafiles… Read More »

User-Managed Backup (2/4) - Offline Backup The Whole Database With ARCHIVELOG Mode

by Ed Chen
February 22, 2013March 15, 2022

User-Managed Backup (1/4) - Offline Backup The Whole Database With NOARCHIVELOG Mode First of all, you have to make sure your database is in ARCHIVELOG… Read More »

User-Managed Backup (1/4) - Offline Backup The Whole Database With NOARCHIVELOG Mode

by Ed Chen
February 21, 2013March 15, 2022

Go Back to Overview Page - User-Managed Backup (0/4) - An Overview First of all, you have to make sure your database is in ARCHIVELOG… Read More »

User-Managed Backup (0/4) - An Overview

by Ed Chen
February 20, 2013March 27, 2022

Backup strategies depend on the nature of the database, some DBA utilize third-party tools to perform the backup, such as backing up all raw devices… Read More »

How to Resolve ORA-12004: REFRESH FAST cannot be used for snapshot

by Ed Chen
February 19, 2013August 27, 2021

Fast refreshing a materialized view requires a view log existed on the master table to make it function well, if you got ORA-12004, this could… Read More »

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