CODEWITHSUNDEEP
oracle-databasebackup
Gtopuria
Gtopuria

Reputation: 427

Oracle Whole Database Backup

What is difference between Oracle Full database Backup vs Physical/Logical?

Does Physical backup include logical?

I want to Backup Whole database what backup should i tell to DBA?

Upvotes: 1

Views: 509

Answers (1)

Rob van Laarhoven
Rob van Laarhoven

Reputation: 8915

Physical backup is a backup made with RMAN or copying datafiles on the OS. A logical backup is a term used for data dumps using tools like datapump, export. Technically a logical backup is no a backup because you can not do a point in time recovery.

A physical backup contains logical data (for example, tables or stored procedures) so in that sense it does.

http://docs.oracle.com/cd/B19306_01/backup.102/b14192/intro001.htm

Upvotes: 1

Related Questions