Oracle database backup and recovery - Explain how to do on-line database
backups posted by Babu
Kunwar
Explain how to do on-line database backups
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:
-
Set the database into backup state by using the alter tablespace . . . begin
backup command for each tablespace or alter database begin backup to put all
tablespaces into online backup mode.
-
Back up the data files using operating system commands.
-
Set the database back to its normal state by issuing alter tablespace . . . end
backup for each tablespace or alter database end backup for all tablespaces in
the database.
-
Archive the unarchived redo logs so that the redo required to recover the
tablespace backup is used by issuing the command alter system archive log
current.
-
Back up the archived redo log files. If necessary, compress or delete the
backed-up archived redo log files to free space on disk.
*Back up the control file.
More links
What is RAC and how is it different from non RAC databases?
Can any application be deployed on RAC? Explain
Explain how to convert a single instance database to RAC
How do we stop and start RAC instances?
Can we test if a database is running in RAC mode? How?
How can we keep track of active instances?..........
|
