This was happened on One of the Production database where non guaranteed restore point was created on Primary database without keeping DR on delay/Apply-off. We did below steps to bring standby…
Read more
Below is High Level Steps: On Primary : 1. check primary logfile and standby logfile group, thread and size 2. ADD and Drop primary logfile group 3. ADD and Drop standby primary logfile group …
Read more
How to calculate FRA It is always questionable , what is the value should I set for Recovery area dest size ? Below is easiest way you can set FRA (Fast recovery area ) usage.…
Read more
How to enable SSH X-11 forwarding and magic cookies Basically, whenever the any new database server provision by server admin team, X11 setup is not there, we are getting below error :…
Read more
FRA Configuration and Some useful details FRA : Fast Recovery Area. Configuring the FRA we can easily manage backup and recovery files. The fast recovery area is an Oracle-managed direc…
Read more
A temporary tablespace is a special set of datafiles associated with an Oracle database that contain data that is not required for read-consistency or for any recovery. The most obvious i…
Read more
Social Plugin