Wednesday, 8 August 2012

Backup and Recovery

What is Backup and Recovery?
In general,  backup and recovery refers to the various strategies and procedures
involved in protecting your database against data loss and reconstructing the database
after any kind of data loss.
Physical Backups and Logical Backups:
A backup is a copy of data from your database that can be used to reconstruct that
data. Backups can be divided into physical backups  and logical backups.
Physical backups are backups of the physical files used in storing and recovering y
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 locati
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, f
later re-importing into a database using the corresponding Oracle import utility.

No comments:

Post a Comment

Script to update salespersons customer site wise in oracle apps R12

SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'DEENA VISION%'; SELECT * FROM HZ_CUST_ACCOUNTS_ALL WHERE PARTY_ID =94043 ; SE...