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 […]
Archived Log File

How to Determine Archived Log Size

Posted on
Archived Log Size Before determining archived log size, you have to know that archived logs are derived (retired) from online redo logs switching. That is, you are not determining archived log size, in fact you are determining online redo log size. But now the question is: How to set a proper and optimal size for […]
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 […]