Control File

How to Change Control File Location

Posted on
Change Control File Location Here are the steps to change the location of control file: Stop Database Service Copy Control File to New Location Create PFILE from Current SPFILE Modify Control File Location in PFILE Restore SPFILE from Modified PFILE Startup NOMOUNT to Check New Setting Open Database If you’d like to move SPFILE as […]
Control File

When the Controlfile is Missing

Posted on
When the controlfile is missing, the database can’t mount the controlfile, you need to restore the controlfile before going further. But first of all, you must have at least one copy of the controlfile before restoring it. Otherwise, you will have a big trouble. The best practice of the backup strategy against the controlfile is […]
Control File

How to Check Control File Size

Posted on
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 control files are just symbolic links that represent raw devices. There’s no way to check the usage of a raw device. Here are several ways that can check the size […]