Rman相关命令
来源:互联网 发布:域名主机查询 编辑:程序博客网 时间:2024/06/06 04:40
show all;
----显示目标数据库的备份配置信息用策略。
report用于判断数据库当前可恢复状态、以及数据库已有备份的信息。
RMAN> report schema; --表空间
Report of database schema for database with db_unique_name ORCL
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 710 SYSTEM *** +DATA/orcl/datafile/system.260.834214595
2 600 SYSAUX *** +DATA/orcl/datafile/sysaux.261.834214997
3 345 UNDOTBS1 *** +DATA/orcl/datafile/undotbs1.262.834215347
4 5 USERS *** +DATA/orcl/datafile/users.264.834215541
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 64 TEMP 32767 +DATA/orcl/tempfile/temp.263.834215483
RMAN> report obsolete; -- 过期备份
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found
RMAN> report unrecoverable; --报告不可恢复的
Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------------------------
RMAN> report need backup; --报告需要备份的
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
1 0 +DATA/orcl/datafile/system.260.834214595
2 0 +DATA/orcl/datafile/sysaux.261.834214997
3 0 +DATA/orcl/datafile/undotbs1.262.834215347
4 0 +DATA/orcl/datafile/users.264.834215541
RMAN> report need backup days=3; --报告最近三天没有备份的
Report of files whose recovery needs more than 3 days of archived logs
File Days Name
---- ----- -----------------------------------------------------
1 146 +DATA/orcl/datafile/system.260.834214595
2 146 +DATA/orcl/datafile/sysaux.261.834214997
3 146 +DATA/orcl/datafile/undotbs1.262.834215347
4 146 +DATA/orcl/datafile/users.264.834215541
RMAN> report need backup incremental=3; --如果出了问题 需要多少个增量备份文件才能恢复的数据文件 。(如果出问题,这些数据文件将需要3个增量备份才能恢复)
Report of files that need more than 3 incrementals during recovery
File Incrementals Name
---- ------------ ----------------------------------------------
backup常用命令
backup database tag='20140510_bak_all'; ----备份整个库 并且打上tag tag需要唯一
backup database keep forever; --永久保留备份文件
backup database keep until time='sysdate+7'; --保存备份7天
run{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
backup database format 'bak/full_%u_%T.bak';
backup spfile format 'bak/spfile_%u_%T.bak';
backup current controlfile format 'bak/ctl_%u_%T.bak';
sql 'alter system archive log current';
backup archivelog all delete input format 'bak/arc_%u_%T.bak';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
- RMAN相关命令:
- Oracle Rman相关命令
- Rman相关命令
- RMAN维护的相关命令
- rman 命令
- rman命令
- rman命令
- rman命令
- rman命令
- rman命令
- rman命令
- RMAN实战7:list、report命令、相关动态视图、shell对RMAN监控
- Oracle RMAN相关资料
- RMAN的相关参数
- 【RMAN】【RMAN命令】CONFIGURE命令(1)--RMAN 配置参数说明
- RMAN命令详解
- RMAN备份命令
- RMAN 基本命令
- Android中Telephony学习总结
- mina学习基础-入门实例-传输java对象(二)
- 程序人生
- 一个字符变量存储到动态分配内存引发的输入问题解决--连续输入scanf函数存在缓冲区的问题
- win7无线网络适配器打不开
- Rman相关命令
- 类成员对象中含有类对象的 构造器,拷贝构造器,赋值运算符重载的写法
- es分布式 索引复制异常:org.elasticsearch.transport.RemoteTransportException: Failed to deserialize exception
- 等高直方图预估结果集行计算公式
- ContentType,pageEncoding与charset的区别
- 基于STM32_DM9000_UIP_FreeModbus的Modbus-TCP功能实现工程下载
- ZOJ 2048 highways
- c语言 关于数组名作参数传递问题
- Android中layout到color.xml颜色值