Why Export/data Pump Backup Called As Logical Backup?

1.	Why Export/data Pump Backup Called As Logical Backup?
Answer» Export and datapump dump file doesn't backup or contain any physical structure of database like datafile, control file, redo LOG file, parameter file, PASSWORD file. Instead of physical structure, export dump contains logical structure of database like DEFINITION of tablespaces, SEGMENTS, schemas, data of segments etc. DUE to these reasons export and datapump dump is called as logical backup. Export and datapump dump file doesn't backup or contain any physical structure of database like datafile, control file, redo log file, parameter file, password file. Instead of physical structure, export dump contains logical structure of database like definition of tablespaces, segments, schemas, data of segments etc. Due to these reasons export and datapump dump is called as logical backup.

Answer»

Export and datapump dump file doesn't backup or contain any physical structure of database like datafile, control file, redo LOG file, parameter file, PASSWORD file. Instead of physical structure, export dump contains logical structure of database like DEFINITION of tablespaces, SEGMENTS, schemas, data of segments etc. DUE to these reasons export and datapump dump is called as logical backup.

Export and datapump dump file doesn't backup or contain any physical structure of database like datafile, control file, redo log file, parameter file, password file. Instead of physical structure, export dump contains logical structure of database like definition of tablespaces, segments, schemas, data of segments etc. Due to these reasons export and datapump dump is called as logical backup.

Discussion

No Comment Found

Related InterviewSolutions

What Is Full Backup?
Which Command I Should Need To Execute To Back Up Database Which Is Running On Noarchivelog Mode?
Have You Faced Any Recovery Scenario? Explain How You Resolved It?
Why Export/data Pump Backup Called As Logical Backup?
Why We Should Need To Open Database Using Resetlogs After Finishing Incomplete Recovery?
What Is The Complete Recovery?
How Do You Recover From The Loss Of Data File If Database Is Running In Archive Log Mode?
Archive Logs Are Being Generated Around 20gb In My Production Large Database. But One Day Almost Double Archives Were Generated. What Is The Reason Behind This? How Can I Check It?
How Can I Know My Require Table Is Available In Export Dump File?
What Is The Meaning Of Lgwr Sync And Lgwr Async In Log Archive Destination Parameter Of Standby Configuration?