| INSTANCE |
Posted: Jul 30, 2007 02:03:20 AM |
Total Post: 7
Joined: Jul, 2007
|
Hi
I havae read concepts like BACKUP. I am not able to understand what is the difference between physical backup and logical backup..?
what is the difference between cache recovery and instance recovery...?
could you pls explain me in detail....?
Thanks and Regards |
|
|
 Mohammed Taj |
| Posted: Jul 30, 2007 02:20:50 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
Physical standby database
A physical standby database is physically identical to the primary database, with on disk database structures that are identical to the primary database on a block-for-block basis. The database schema, including indexes, are identical.
Logical standby database
A logical standby database is initially created as an identical copy of the primary database, but it later can be altered to have a different structure. The logical standby database is updated by executing SQL statements. This allows users to access the standby database for queries and reporting at any time.
http://download.oracle.com/docs/cd/B14117_01/server.101/b10823/toc.htm
regards
Taj
http://dbataj.blogspot.com
|
|
|
|
|
| Nand |
| Posted: Aug 04, 2007 02:41:56 AM | |
|
Total Post: 22
Joined: Jun, 2007
|
Taj...u have mentioned about the physical & logical standby databases..he was asking about physical and logical backup.
Physical backup means taking a backup of files (df,cf..) of the database...it can be either cold or hot. while logical backup implies backups taken using export utilities( exp / expdp).
Correct me if iam wrong
Regards
Nand
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
