探索ORACLE之RMAN_03一致性备份
来源:互联网 发布:淘宝商铺怎么激活 编辑:程序博客网 时间:2024/06/11 20:28
探索ORACLE之RMAN_03一致性备份
作者:吴伟龙
在之前的已经提到过备份分为一致性备份和非一致性备份,它们的区别就在于数据库所处的备份状态不同,并且一致性备份不能做增量备份恢复,需停业务,一致性备份可以做到增量的备份恢复,从而不影响业务的正常流转。
创建一致性备份
创建一致性备份可以是在非归档模式下创建,并且数据库必须处于mount状态下,而且恢复的时候值能恢复到最后一次备份的状态。也就说从备份到发生故障的这段时间都将丢失。操作步骤如下:
1.1检查归档状态:
SQL> archive log list;
Database log mode No Archive Mode
Automaticarchival Disabled
Archivedestination USE_DB_RECOVERY_FILE_DEST
Oldest onlinelog sequence 8
Current logsequence 10
SQL>
1.2将数据库启动到mount状态
SQL> shutdown immediate
Databaseclosed.
Databasedismounted.
ORACLE instanceshut down.
SQL> startup mount;
ORACLE instancestarted.
Total SystemGlobal Area 285212672 bytes
Fixed Size 1218968 bytes
VariableSize 79693416 bytes
DatabaseBuffers 197132288 bytes
RedoBuffers 7168000 bytes
Databasemounted.
SQL>
1.3执行备份
1.3.1 备份数据库
[oracle@wwldb ~]$ rman target /
RecoveryManager: Release 10.2.0.1.0 - Production on ÐÇÆÚÒ» 5ÔÂ 21 14:53:47 2012
Copyright (c)1982, 2005, Oracle. All rights reserved.
connected totarget database: WWL (DBID=5520179, not open)
RMAN> backup database;
Starting backupat 21-5ÔÂ -12
using targetdatabase control file instead of recovery catalog
allocatedchannel: ORA_DISK_1
channelORA_DISK_1: sid=156 devtype=DISK
channelORA_DISK_1: starting full datafile backupset
channelORA_DISK_1: specifying datafile(s) in backupset
input datafilefno=00001 name=/DBData/WWL/system01.dbf
input datafilefno=00003 name=/DBData/WWL/sysaux01.dbf
input datafilefno=00002 name=/DBData/WWL/undotbs01.dbf
input datafilefno=00004 name=/DBData/WWL/users01.dbf
channelORA_DISK_1: starting piece 1 at 21-5ÔÂ -12
channelORA_DISK_1: finished piece 1 at 21-5ÔÂ -12
piece handle=/DBBak/bak_WWL_05_21_06nbhucb_1_1tag=TAG20120521T145403 comment=NONE
channelORA_DISK_1: backup set complete, elapsed time: 00:01:16
Finished backupat 21-5ÔÂ -12
Starting ControlFile and SPFILE Autobackup at 21-5ÔÂ -12
piecehandle=/DBSoft/product/10.2.0/db_1/dbs/c-5520179-20120521-00 comment=NONE
Finished ControlFile and SPFILE Autobackup at 21-5ÔÂ -12
RMAN>
1.3.2 备份USER表空间
RMAN> backup tablespace users;
Starting backupat 21-5ÔÂ -12
using targetdatabase control file instead of recovery catalog
allocated channel:ORA_DISK_1
channelORA_DISK_1: sid=155 devtype=DISK
channelORA_DISK_1: starting full datafile backupset
channelORA_DISK_1: specifying datafile(s) in backupset
input datafilefno=00004 name=/DBData/WWL/users01.dbf
channelORA_DISK_1: starting piece 1 at 21-5ÔÂ -12
channelORA_DISK_1: finished piece 1 at 21-5ÔÂ -12
piecehandle=/DBBak/bak_WWL_05_21_08nbhvhe_1_1 tag=TAG20120521T151349 comment=NONE
channelORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backupat 21-5ÔÂ -12
Starting ControlFile and SPFILE Autobackup at 21-5ÔÂ -12
piecehandle=/DBSoft/product/10.2.0/db_1/dbs/c-5520179-20120521-01 comment=NONE
Finished ControlFile and SPFILE Autobackup at 21-5ÔÂ -12
RMAN>
- 探索ORACLE之RMAN_03一致性备份
- 探索ORACLE之RMAN_04非一致性备份
- 探索ORACLE之RMAN_05增量备份
- 探索ORACLE之RMAN_06备份策略
- 探索ORACLE之RMAN_07非一致性恢复(集合)
- 探索ORACLE之RMAN_07非一致性恢复(集合)
- 探索ORACLE不完全恢复之--基于备份控制文件恢复
- 探索c#之一致性Hash详解
- oracle事务之oracle读一致性
- oracle事务之oracle读一致性
- 探索undo一致性读
- Oracle之数据库备份
- Oracle之数据库备份
- 探索ORACLE之ASM01_概念
- 探索ORACLE之ASM02_安装
- 探索ORACLE之ASM03_应用
- 探索ORACLE之ASM04_维护
- 探索ORACLE之RMAN_01概念
- Jquery UI的日历控件datepicker限制日期
- android--graphics
- 皮肤保养牢记8件小事
- 关于虚析构函数的意义以及operator new与operator delete
- shell 重定向
- 探索ORACLE之RMAN_03一致性备份
- Linux 定时执行 PHP 文件
- linux下C语言多线程编程实例
- 枚举类型
- centOS root密码忘记怎么办?
- 一些iOS高效开源类库
- CF 190C STL
- 7 款基于 JavaScript/AJAX 的文件上传插件
- Linux下Tomcat的安装配置