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 […]
Administration

How to Move Oracle Database

Posted on
Actually, this topic “How to Move Oracle Database” follows my previous post: How to Move ORACLE HOME. But I think it can be used in any moving operations. Generally speaking, this post will include the following subtle topics: How to move spfile How to move control files How to move database files How to move […]
Backup and Recovery

When Database is Not Consistent

Posted on
There are several different kinds of situation when you recover a database with inconsistent states among files. In the following, I have to assume that you can mount the database without question.Data files are consistent, but controlfile is advanced.Do you have all required logs? If you have both archived logs and redo logs, then you […]
Backup and Recovery

When Redo Log Files Are All Missing

Posted on
If your redo logs are all missing, then you have to know you will lose some data and no longer to recover it. Now let’s mount the database, I mean you can only startup the database to mount state, and let the control file knows all the situation.SQL> startup mount;ORACLE instance started….Database mounted.Recover the database […]
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 […]
Linux

How to Write Control File into Raw Device

Posted on
Since raw devices cannot be read/write as a normal file operation, you cannot write a controlfile directly into a raw device. I guess DBA will have the problem on 9i or 10g, because 11g database does not support raw devices any longer, but 11g ASM does, and 11g ASM can take care itself through ASMCMD. For […]