Topic: Backup & Recovery >> differences RMAN & logical
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: differences RMAN & logical |
| sasi |
Posted: Dec 28, 2005 10:08:04 AM |
Total Post: 59
Joined: Nov, 2005
|
Hi,
what are differences between RMAN & Logical Backups.
venkat |
|
|
 Arulselvaraj |
| Posted: Jan 01, 2006 01:43:39 PM |  |
|
Total Post: 15
Joined: Dec, 2005
|
In simple words, backup taken using exp ustility is logical backup and backup taken using RMAN utility is physical backup.
In technical words, using exp utility you can backup the database objects in a binary dump file. This file can be read using imp utility and can be used to import the objects in the same database or database anywhere else. This backups can not be used to to a point in time recovery.
RMAN provides the facilty to backup the physical files(datafiles) of database hence called as the physical backup. This backup can be used to do point in time recovery with the help of archived logs. Using RMAN, we can backup whole database, particular datafile, particular tablespace, range of archived logs.
HTH..
|
|
|
|
|
| NAVEEN K |
| Posted: Jan 04, 2006 05:12:13 AM | |
|
Total Post: 1
Joined: Jan, 2003
|
Hi,
Export and RMAN backup are two different backup options provided by oracle,as mentioned export backup is logical backup the one purpose of having a logical backup is to maintain object definition of the schemas, moving data from one schema to another scehma, and also can be used to move data between hetergenious oracle environments. hope you are clear with export backup .
Coming to RMAN it is a backup recovery environment provided by oracle to handle the backups for multiple databases using centralized repository .
I suggest you to go through "Recovery Manager Users Guide" to get more insight into the RMAN environment
Naveen
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 387 |
| Vinoth Kumar | 379 |
| Gopu Gopi | 350 |
| Gitesh Trivedi | 322 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
