Oracle 9i Database Administration in 10 Minutes

- Asim Abbasi (Author)

Chapter 9: Oracle Backup & Recovery -Simple Technique

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7

Step 5:

Backup the Control File

Control file can be backed up using the following statement and at the desired location.

ALTER DATABASE BACKUP CONTROLFILE TO ‘c:\staging\ctl.bak’;

The backup created in this fashion will be the binary copy of the control file. We can also take the backup of control file, which will be in text format in the following manner.

ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
As a result of this statement the text version of control file will get copied to the location/folder specified in USER_DUMP_DEST init.ora parameter.

Step 6:

Open the database

Now you have full database backup or in other words Whole Database Backup. It’s time to make the database available to the users you executing the following statement.

ALTER DATABASE OPEN;

This completes our User-Managed Offline/Cold Database Backup. Let’s see now how we can perform User-Managed Online/Hot Database Backup.

User-Managed Complete Recovery is done in two different ways and it all depends on the mode in which you are running the Oracle server. You can run Oracle server either in ARCHIVELOG mode or NOARCHIVELOG mode. The way we do the recovery in NOARCHIVELOG mode is different from the way we do recovery in ARCHIVELOG mode. Let’s have a look on each procedure as follows.

Chapter 9: Oracle Backup & Recovery -Simple Technique

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7

Share with others:

products

books

FREE VB, ASP Projects

Oracle 9i Database Administration in 10 Minutes