Transcript Oracle热备份(RMAN)

实战Oracle之RMAN
第二讲：RMAN基础
热备份和RMAN备份
主讲人：三十而立
华章培训网、[www.hztraining.com]华章培训网版权所有
三十而立-实战RMAN
RMAN基础
Oracle备份的对象
数据文件(Data File)
日志文件(Redo Log)
控制文件(Control File)
参数文件(Spfile/Pfile)
归档文件(Archive Log)
[email protected]
华章培训
www.hztraining.com
第2页
三十而立-实战RMAN
RMAN备份
Rman常用命令
Report 报告
report schema
report need backup {days=1 redundancy=1 recover windows of 1 days}
report obsolete
report unrecoverable
[email protected]
华章培训
www.hztraining.com
第3页
三十而立-实战RMAN
RMAN备份
Rman常用命令
List
list archivelog {all, double-quoted-string, from, high, integer, like, logseq, low, scn, sequence, single-quoted-string, time, until}
RMAN> list archivelog from time 'sysdate-1' until time "to_date('2010-05-21', 'yyyy-mm-dd')";
list backup [of {datafile, tablespace, database, controlfile, spfile, archivelog} [summary]]
list backup completed before 'sysdate-1/12‘
list backup of archivelog from sequence 129 until sequence 130 like '%+DG%';
list backupset [of {datafile, tablespace, database, controlfile, spfile, archivelog} [summary]]
list backuppiece {double-quoted-string, integer, single-quoted-string, tag}
list backup by {backup, file}
list incarnation
report unrecoverable
[email protected]
华章培训
www.hztraining.com
第4页
三十而立-实战RMAN
RMAN基础
Oracle热备份(手工)
不需要Shutdown
Alter tablespace xxx begin backup;
Copy
Alter tablespace xxx end backup;
Switch log file
Do these steps for each tablespace
Backup archivelog and controlfile
华章培训
www.hztraining.com
[email protected]
第5页
三十而立-实战RMAN
RMAN基础
Oracle热恢复(手工)
数据文件级别
Recover datafile XXX
表空间级别(非系统表空间)
Recover tablespace xxxx
数据库级别
Recover database
[email protected]
华章培训
www.hztraining.com
第6页
三十而立-实战RMAN
RMAN基础
Oracle热备份(RMAN)
Backup database即可
[email protected]
华章培训
www.hztraining.com
第7页
三十而立-实战RMAN
RMAN基础
Oracle热恢复(RMAN)
Restore database
Recover database
[email protected]
华章培训
www.hztraining.com
第8页
三十而立-实战RMAN
RMAN基础
RMAN架构
RMAN是客户端命令
Disk
RMAN
Channel
Database
Server Session
SBT
[email protected]
华章培训
www.hztraining.com
第9页
三十而立-实战RMAN
RMAN基础
RMAN和常规备份的区别
常规用OS的命令copy，不能处理raw device和ASM
RMAN操作简单，而且便于管理
功能更强大，增量，复制数据库, 块级检查恢复
[email protected]
华章培训
www.hztraining.com
第10页
感谢您对华章培训网的支持!
http://www. hztraining.com