praveen

• Jun 3rd, 2014

 

as per company strategy.... mostly physical backup is done.

BinC

• Nov 3rd, 2015

 

Physical backups are backups of the physical files used in storing and recovering your database, such as datafiles, control files, and archived redo logs. Ultimately, every physical backup is a copy of files storing database information to some other location, whether on disk or some offline storage such as tape.
Logical backups contain logical data (for example, tables or stored procedures) exported from a database with an Oracle export utility and stored in a binary file, for later re-importing into a database using the corresponding Oracle import utility.

RAMYA

• Jan 23rd, 2016

 

Physical backups are backup which is taken from the datafiles, control files etc.

Logical backups are the backup which is taken from tablespace, segments etc.

Manisanthosh

• Mar 4th, 2016

 

Physical backups for database, control file, incremental, archive, full backups and Logical backups for tables, schemas.

Nishanth

• Mar 14th, 2016

 

A database dump using expdp is a 1-time export of one or more database schemas. It backs up DDL (table structures, views, synonyms, stored procedures, packages, etc), plus data.
An RMAN backup is a point-in-time backup of an entire database (for the purposes of this question). It backs up the physical blocks that make up the database (data files, control file, archive logs etc) and, in combination with the database archive logs, allows point in time recovery options.
In the event of a complete database loss an RMAN backup can be used to restore the complete database. However, a data dump taken using expdp would need a new database creating before the data could be imported using impdp.

Vikas

• Jan 9th, 2018

 

Generally, datapump is being used to remap schemas or tables as routine activities which is logical backup. For cases like database restore, creating replicated databases physical backup is mostly considered.