.
Standby Redo Logs (SRL) : is similar to Online Redo Log (ORL) and only difference between two is that Standby Redo Log is used to store redo data received from another database (primary database).
        Standby Redo Logs are only used if you have the LGWR as transport mode to Remote Standby Database. (step to check transport mode below)
. 
In what […]

Popularity: 7% [?]

read more from this topic.....

NOTE: This is One of the Hidden Oracle Parameters. DO NOT use it until and unless instructed by Oracle Support. You are trying to start your DATABASE, you found the aforementioned error i.e. ORA-00354.
.

Required Action: Perform recovery with a good version of the redo log file or perform cancel-based recovery up to, but not including, […]

Popularity: 6% [?]

read more from this topic.....

On Unix/Linux, when a file is deleted, but a process still has the file open, the file is still there in the filesystem, and only the inode is removed.
But the process can continue to use its file handle, and the file can also be accessible under /proc/<pid>/fd .
In the following example, we use that behavior […]

Popularity: 11% [?]

read more from this topic.....

This is in continuation of Oracle Dataguard configuration part I  which I posted long back and forgot to update next one.
   One of my friend was looking for steps so I thought of finishing this (If you think I missed any post just leave comment and I’ll try to post on that topic)
Ensure that you have […]

Popularity: 15% [?]

read more from this topic.....

Today lets conclude dataguard/standby configuration & look at Metalink note on Dataguard configuration in Apps 11i with database 9i & 10g.After creating standby control file and moving datafiles, redo log, control file,tnsnames.ora to standby site , start standby database as mentioned below using standby control file.
SQL> startup mount
In order to put standby database in managed […]

Popularity: 12% [?]

read more from this topic.....

Today I am going to cover step by step configuration for Oracle Dataguard & may be in next or future posts I will discuss on common mistakes which you can do while configure dataguard / standby database.
Below steps are based on assumptions that Primary Database is on Machine1.domain.com & Standby database is on Machine2.domain.com . […]

Popularity: 17% [?]

read more from this topic.....

Based on lots of request from readers of this blog I am posting on Backup & Recovery of Oracle Apps 11i database & application tier.
I’ll discuss on How to troubleshoot load balancer in oracle Apps after Backup & Recover.
You might have read in Oracle Documentation lot of time to backup your system before applying patch […]

Popularity: 5% [?]

read more from this topic.....