Oracle database backup and recovery - June 17, 2010 at 12:30 PM
by Babu Kunwar
Backup is generally needed for safety reason. For example if something may go
wrong in the live database which is running. Then immediately we can restore
the backup and server the purpose. We can take back up as per our
wish...................
Read Answer
The backup strategies that are provided by Oracle are as
follows:...................
Read Answer
Online backup is one which is taken at the time the database is running in the
ARCHIVELOG mode....................
Read Answer
Restoring a database is copying the physical files from a backup medium (disk or
tape) to the appropriate file locations for database operation
Recovery...............
Read Answer
The logical backup in Oracle database is done by Export utility. Oracle’s Export
utility queries the database, including the data dictionary, and writes the
output to a binary file called an export dump file. The backup through export
utility can be done in four phase..................
Read Answer
To make use of the ARCHIVELOG capability, the database must first be placed in
ARCHIVELOG mode. The following listing shows the steps needed to place a
database in ARCHIVELOG mode.................
Read Answer
Consistent offline backups occur when the database has been shut down normally
using the normal, immediate, or transactional option of the shutdown
command....................
Read Answer
Online backup can be done while the database is open. The only condition needs
to be satisfied is it must be in ARCHIVED mode. Implementing Online
Backups:...................
Read Answer
RMAN in Oracle stands for Oracle Recovery Manager. RMAN takes backup and
recovery to a new level of protection and ease of use. We can use RMAN with
command line mode and with OEM web interface..................
Read Answer
RMAN provides two modes of full database backup. Full database backup can be
done as:...............
Read Answer
We can archive logs using RMAN. RMAN provides option that once the backup is
completed, we have the option to leave the logs in place..................
Read Answer
Creating RMAN account:
SQL> create tablespace rman datafile '+data1' 2 size 125m auto extend on
next 50m maxsize 500m;.................
Read Answer
Recovery Manager is the single tool for guaranteed, efficient, manageable Oracle
database backup and recovery. RMAN integrates with leading 3rd party backup
vendors for backup to tape, via the System Backup to Tape API................
Read Answer
In order to clone/duplicate a database with RMAN follows the steps
below:.................
Read Answer
Cold Backup
In this type of backup, after the database is shut down, DBA exits the
SVRMGR utility and copies the log files, data files and control files onto a
backup media.Once the backup has been completed the DBA can restart the
database...................
Tablespace fragmentation can be prevented by using PCTINCREASE command.
PCTINCREASE is the percentage a new subsequent extent will grow...............
Automatic Performance Diagnostic and Tuning Features, Automatic Shared Memory
Management - Automatic Shared Memory Management puts Oracle in control of
allocating memory within the SGA...........
|
