Need help with dataguard installation [message #475369] |
Tue, 14 September 2010 11:57 |
ultgnp
Messages: 106 Registered: May 2010 Location: Germany
|
Senior Member |
|
|
Hi,
I am planning to use Data Guard facility in Oracle 10g database. Could someone please answer few of my queries:
1) I would like to have a standby database, which can be used if the primary goes down and also for reporting and other queries (read-Only).
2) Please explain me in simple words the difference between Physical and Logical standby database. I have to explain non-technical users (management) regarding this.
3) What is Sync and Async redo log apply?
4) When i manipulate data (Insert,Delete,Update) in logical standby database, will these changes reflect in Primary database synchronously?
5) Which type of REDO APPLY is better: Managed Recovery Process(MRP) or Real Time Apply(RTA)?
6) can the redo data be deleted if its obsolete or is it deleted automatically by oracle?
7) If i want to take backup, should i take it from primary or standby database? If standby, then the database should be in which mode (Read-only or Recovery Mode)
Best Regards,
|
|
|
|