Oracle RMAN in Noarchivelog mode

DBA Notes: 2011/10/27

Cheng Li

 

Oracle RMAN in Noarchivelog mode

 

In order to increase backup time, we apply Oracle Rman backup in noarchivelog mode.

 

Reference:

http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmquick.htm#BABJAGIB

http://www.dbaglobe.com/2009/12/sample-rman-backup-in-noarchivelog-mode.html

 

Backing Up a Database in NOARCHIVELOG Mode

If a database runs in NOARCHIVELOG mode, then the only valid database backup is a consistent backup. For the backup to be consistent, the database must be mounted after a consistent shutdown. No recovery is required after restoring the backup.

To make a consistent database backup:

Start RMAN and connect to a target database.

Shut down the database consistently and then mount it.

For example, enter the following commands to guarantee that the database is in a consistent state for a backup:

Run the BACKUP DATABASE command.

For example, enter the following command at the RMAN prompt to back up the database to the default backup device:

The following variation of the command creates image copy backups of all datafiles in the database:

Open the database and resume normal operations.

The following command opens the database:

 

大宅爱敦阁.jpg

大宅爱敦阁2.jpg

大宅爱敦阁3.jpg

大宅爱敦阁4.jpg

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26136400/viewspace-709769/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26136400/viewspace-709769/