Sunday, June 2, 2013

RMAN 'backup database plus archivelog'

When you use the backup database plus archivelogcommand to back up archive logs as part of another backup, RMAN will perform the following operations in the sequence listed here: .
1. Run the alter system archive log currentcommand.
 2.Run the backup archivelog allcommand.
 3.Back up the rest of the datafiles specified by the backup databasecommand
4.Run the alter system archive log currentcommand.
5.Back up the new archive logs generated during the backup operation. The sequence of operations listed here means that RMAN will have all the necessary archived redo log information that it’ll need down the road if it has to perform a complete recovery of the database. ■NoteThe backup dathe entire database and all the archived redo logs as well as the current control file in a single command.See the next recipe for details
tabase plus archivelogcommand will back up the entire


Backing Up Everything

Problem

 You want to create a backup of the entire database, meaning all the datafiles, the archived redo logs, and the control file

Solution

To make sure the control file is backed up automatically as part of the database backup, first make sure you have configured automatic control file backups by using the following command:

RMAN> configure controlfile autobackup on;

Then you can issue the backup database plus archivelogcommand to back up the database along with the archived redo logs:

RMAN> backup database plus archivelog;




No comments:

Post a Comment

Oracle row type vs PostgreSQL record

The Oracle row type concept can be accomplished with the record type in PostgreSQL. Example: Oracle: CURSOR travel_cur IS  SELECT  c.travel_...