V$CONTROLFILE_RECORD_SECTION

RMAN Backup Records are Lost Regularly

by Ed Chen
May 9, 2022May 10, 2022

I found something unusual about RMAN backup records. 1. Obsolete Not Deleted Some backup files older than 3 months are definitely obsolete according to redundancy… Read More »

How to Check Control File Size

by Ed Chen
December 14, 2012November 26, 2020

Check Control File Size Control file is a file that have several file attributes including size, but when database is stored upon raw devices, your… Read More »

Restrictions on Adding a Datafile

by Ed Chen
November 3, 2012March 28, 2021

There are two major restrictions must be considered before you add a datafile to a tablespace. One is about the number limit of datafiles, the… Read More »