首页 > 其他 > 详细

RMAN备份之非归档模式下的备份

时间:2015-03-27 12:12:05      阅读:177      评论:0      收藏:0      [点我收藏+]

Backing Up a Database in NOARCHIVELOG Mode:
1.Log into RMAN
2.Shutdown immediate from RMAN
3.Startup mount from RMAN
4.backup database
5.alter database open
--------------------------------------------
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:
1. Start RMAN and connect to a target database.
2. 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:
RMAN> SHUTDOWN IMMEDIATE;
RMAN> STARTUP FORCE DBA;
RMAN> SHUTDOWN IMMEDIATE;
RMAN> STARTUP MOUNT;

3. 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:
RMAN> BACKUP DATABASE;
The following variation of the command creates image copy backups of all data files in the database:
RMAN> BACKUP AS COPY DATABASE;
4. Open the database and resume normal operations.
The following command opens the database:
RMAN> ALTER DATABASE OPEN;

RMAN备份之非归档模式下的备份

原文:http://www.cnblogs.com/rusking/p/4371070.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!