Oracle 11g 053 使用 RMAN 执行恢复
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES CLAER;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "for device"
RMAN-01008: the bad identifier was: CLAER
RMAN-01007: at line 1 column 36 file: standard input
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK clear;
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
RMAN configuration parameters are successfully reset to default value
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN> backup database plus archivelog;
Starting backup at 23-OCT-19
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=16 RECID=2 STAMP=1022220573
input archived log thread=1 sequence=17 RECID=3 STAMP=1022313667
input archived log thread=1 sequence=18 RECID=5 STAMP=1022390382
input archived log thread=1 sequence=19 RECID=8 STAMP=1022390429
input archived log thread=1 sequence=20 RECID=10 STAMP=1022390720
input archived log thread=1 sequence=21 RECID=11 STAMP=1022390874
input archived log thread=1 sequence=22 RECID=13 STAMP=1022391977
channel ORA_DISK_1: starting piece 1 at 23-OCT-19
channel ORA_DISK_1: finished piece 1 at 23-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_23/annnf0_tag20191023t054617_0.279.1022391979 tag=TAG20191023T054617 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
Finished backup at 23-OCT-19
Starting backup at 23-OCT-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1016595403
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.1016595403
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.1016595403
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1016595663
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1016595405
channel ORA_DISK_1: starting piece 1 at 23-OCT-19
channel ORA_DISK_1: finished piece 1 at 23-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_23/nnndf0_tag20191023t054713_0.278.1022392039 tag=TAG20191023T054713 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:26
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 23-OCT-19
channel ORA_DISK_1: finished piece 1 at 23-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_23/ncsnf0_tag20191023t054713_0.260.1022392195 tag=TAG20191023T054713 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 23-OCT-19
Starting backup at 23-OCT-19
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=23 RECID=15 STAMP=1022392200
channel ORA_DISK_1: starting piece 1 at 23-OCT-19
channel ORA_DISK_1: finished piece 1 at 23-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_23/annnf0_tag20191023t055000_0.261.1022392201 tag=TAG20191023T055000 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 23-OCT-19
RMAN>
相关文章
- Oracle数据库使用出现错误-状态: 失败 ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
- ORACLE数据库存储空间使用情况查询
- 【Oracle】如何查看sql 执行计划的历史变更
- 【Python Oracle】使用cx_Oracle 连接oracle的简单介绍
- 【Oracle】修改oracle监听端口
- 《oracle每日一练》免安装Oracle客户端使用PL/SQL
- 《oracle每天一练》Oracle之物化视图
- oracel: 通过特殊表序列来实现oracle自增id (mybatis实现自增id)
- ORACLE 执行计划
- oracle client字符集设置 乱码问题
- cx_Oracle连接oracle数据库
- oracle针对oracle和grid用户---环境变量设置---单实例和RAC
- -- Oracle 常见故障及日常规划----
- 【Oracle 集群】ORACLE DATABASE 11G RAC 知识图文详细教程之RAC 特殊问题和实战经验(五)
- Oracle 集群】ORACLE DATABASE 11G RAC 知识图文详细教程之ORACLE集群概念和原理(二)
- Some tricks when using cx_Oracle
- Oracle在linux下面的安装
- Oracle数据库 External component has thrown an exception
- Oracle 如何查看建表时间?
- Oracle性能优化学习笔记之选择最有效率的表名顺序
- atitit.Oracle 9 10 11 12新特性attilax总结
- 解密 Oracle 数据库 SQL 执行历史:掌握多种实现方式,轻松实现 SQL 监控与性能优化
- ORACLE 树形查询 树查询
- mybatis连接Oracle执行begin..end批量操作返回行数问题
- oracle dblink造成远程数据库session过多
- 04、Oracle转换函数和条件表达式
- 【Mysql异构实时同步Oracle】OGG12异构同步mysql到oracle(windows mysql实时同步数据到linux oracle)详细文档