[20170626]rman merge例子.txt

最新推荐文章于 2022-12-28 11:15:59 发布
最新推荐文章于 2022-12-28 11:15:59 发布
阅读量95 收藏
点赞数

[20170626]rman merge例子.txt

1.环境:
SCOTT@book> @ &r/ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

2.别人问的问题,要建立备份,不断应用日志,常用的方式如下:

RUN
{
backup incremental level 1 for recover of copy with tag 'incr_update' database ;
recover copy of database with tag 'incr_update' ;
}

--//但这样数据文件建立在闪回区,采用OMF格式.而如果采用如下方式执行:

RUN
{
backup incremental level 1 for recover of copy with tag 'incr_update' database format '/home/oracle/backup/%b';
recover copy of database with tag 'incr_update' ;
}
Starting backup at 2017-06-26 10:54:36
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=35 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=46 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=56 device type=DISK
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 5 found
no parent backup or copy of datafile 4 found
no parent backup or copy of datafile 6 found
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/mnt/ramdisk/book/sysaux01.dbf
channel ORA_DISK_2: starting datafile copy
input datafile file number=00003 name=/mnt/ramdisk/book/undotbs01.dbf
channel ORA_DISK_3: starting datafile copy
input datafile file number=00001 name=/mnt/ramdisk/book/system01.dbf
output file name=/u01/app/oracle/fast_recovery_area/BOOK/datafile/o1_mf_sysaux_do0xvgb8_.dbf tag=INCR_UPDATE RECID=27 STAMP=947674489
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/mnt/ramdisk/book/example01.dbf
output file name=/u01/app/oracle/fast_recovery_area/BOOK/datafile/o1_mf_undotbs1_do0xvgbh_.dbf tag=INCR_UPDATE RECID=26 STAMP=947674489
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_2: starting datafile copy
input datafile file number=00004 name=/mnt/ramdisk/book/users01.dbf
output file name=/u01/app/oracle/fast_recovery_area/BOOK/datafile/o1_mf_system_do0xvgbn_.dbf tag=INCR_UPDATE RECID=25 STAMP=947674489
channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_3: starting datafile copy
input datafile file number=00006 name=/mnt/ramdisk/book/tea01.dbf
output file name=/u01/app/oracle/fast_recovery_area/BOOK/datafile/o1_mf_example_do0xvxh1_.dbf tag=INCR_UPDATE RECID=30 STAMP=947674494
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/fast_recovery_area/BOOK/datafile/o1_mf_users_do0xvxlr_.dbf tag=INCR_UPDATE RECID=29 STAMP=947674494
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/fast_recovery_area/BOOK/datafile/o1_mf_tea_do0xvxog_.dbf tag=INCR_UPDATE RECID=28 STAMP=947674494
channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2017-06-26 10:54:54

Starting recover at 2017-06-26 10:54:54
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
no copy of datafile 3 found to recover
no copy of datafile 4 found to recover
no copy of datafile 5 found to recover
no copy of datafile 6 found to recover
Finished recover at 2017-06-26 10:54:54

Starting Control File and SPFILE Autobackup at 2017-06-26 10:54:54
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2017_06_26/o1_mf_s_947674494_do0xvz0h_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2017-06-26 10:54:55

RMAN> **end-of-file**

--//可以发现这样不行.指定format无效.虽然以上脚本一直可以应用,主要是文件名采用OMF格式.数据文件放在闪回区.
--//可以采用如下方式,先备份成datafilecopy文件.然后注册为增量备份.就ok了,看下面的测试.

RMAN> backup as copy  database format '/home/oracle/backup/%b' tag 'incr_update';
Starting backup at 2017-06-26 11:00:16
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/mnt/ramdisk/book/sysaux01.dbf
channel ORA_DISK_2: starting datafile copy
input datafile file number=00003 name=/mnt/ramdisk/book/undotbs01.dbf
channel ORA_DISK_3: starting datafile copy
input datafile file number=00001 name=/mnt/ramdisk/book/system01.dbf
output file name=/home/oracle/backup/sysaux01.dbf tag=INCR_UPDATE RECID=38 STAMP=947674828
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/mnt/ramdisk/book/example01.dbf
output file name=/home/oracle/backup/undotbs01.dbf tag=INCR_UPDATE RECID=39 STAMP=947674828
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_2: starting datafile copy
input datafile file number=00004 name=/mnt/ramdisk/book/users01.dbf
output file name=/home/oracle/backup/system01.dbf tag=INCR_UPDATE RECID=37 STAMP=947674828
channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_3: starting datafile copy
input datafile file number=00006 name=/mnt/ramdisk/book/tea01.dbf
output file name=/home/oracle/backup/example01.dbf tag=INCR_UPDATE RECID=42 STAMP=947674833
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
output file name=/home/oracle/backup/users01.dbf tag=INCR_UPDATE RECID=41 STAMP=947674833
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:01
output file name=/home/oracle/backup/tea01.dbf tag=INCR_UPDATE RECID=40 STAMP=947674832
channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2017-06-26 11:00:33
Starting Control File and SPFILE Autobackup at 2017-06-26 11:00:33
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2017_06_26/o1_mf_s_947674833_do0y6kmk_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2017-06-26 11:00:34

--//但是这样的文件非0级备份.参考链接:
--//blog.itpub.net/267265/viewspace-1867253/
--//blog.itpub.net/267265/viewspace-1832475/

RMAN> catalog datafilecopy '/home/oracle/backup/system01.dbf' level 0 ;
cataloged datafile copy
datafile copy file name=/home/oracle/backup/system01.dbf RECID=43 STAMP=947675261

catalog datafilecopy '/home/oracle/backup/sysaux01.dbf' level 0 ;
catalog datafilecopy '/home/oracle/backup/example01.dbf' level 0 ;
catalog datafilecopy '/home/oracle/backup/undotbs01.dbf' level 0 ;
catalog datafilecopy '/home/oracle/backup/users01.dbf' level 0 ;
catalog datafilecopy '/home/oracle/backup/tea01.dbf' level 0 ;

--//不知道如何一次搞定.

RMAN> recover copy of database with tag incr_update;
Starting recover at 2017-06-26 11:12:07
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
no copy of datafile 3 found to recover
no copy of datafile 4 found to recover
no copy of datafile 5 found to recover
no copy of datafile 6 found to recover
Finished recover at 2017-06-26 11:12:07
Starting Control File and SPFILE Autobackup at 2017-06-26 11:12:07
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2017_06_26/o1_mf_s_947675527_do0yw76w_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2017-06-26 11:12:08

$ cat merge.rman
RUN
{
backup incremental level 1 for recover of copy with tag 'incr_update' database ;
recover copy of database with tag 'incr_update' ;
}

Starting backup at 2017-06-26 11:19:50
using target database control file instead of recovery catalog
channel ORA_DISK_3: SID=46 device type=DISK
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=/mnt/ramdisk/book/sysaux01.dbf
input datafile file number=00005 name=/mnt/ramdisk/book/example01.dbf
channel ORA_DISK_1: starting piece 1 at 2017-06-26 11:19:51
channel ORA_DISK_2: starting incremental level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00003 name=/mnt/ramdisk/book/undotbs01.dbf
input datafile file number=00006 name=/mnt/ramdisk/book/tea01.dbf
channel ORA_DISK_2: starting piece 1 at 2017-06-26 11:19:51
channel ORA_DISK_3: starting incremental level 1 datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00001 name=/mnt/ramdisk/book/system01.dbf
input datafile file number=00004 name=/mnt/ramdisk/book/users01.dbf
channel ORA_DISK_3: starting piece 1 at 2017-06-26 11:19:52
channel ORA_DISK_1: finished piece 1 at 2017-06-26 11:19:53
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_06_26/o1_mf_nnnd1_INCR_UPDATE_do0zbqyz_.bkp tag=INCR_UPDATE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_2: finished piece 1 at 2017-06-26 11:19:53
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_06_26/o1_mf_nnnd1_INCR_UPDATE_do0zbqz6_.bkp tag=INCR_UPDATE comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_3: finished piece 1 at 2017-06-26 11:19:53
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_06_26/o1_mf_nnnd1_INCR_UPDATE_do0zbr04_.bkp tag=INCR_UPDATE comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:01
Finished backup at 2017-06-26 11:19:53

Starting recover at 2017-06-26 11:19:53
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile copies to recover
recovering datafile copy file number=00001 name=/home/oracle/backup/system01.dbf
recovering datafile copy file number=00004 name=/home/oracle/backup/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_06_26/o1_mf_nnnd1_INCR_UPDATE_do0zbr04_.bkp
channel ORA_DISK_2: starting incremental datafile backup set restore
channel ORA_DISK_2: specifying datafile copies to recover
recovering datafile copy file number=00002 name=/home/oracle/backup/sysaux01.dbf
recovering datafile copy file number=00005 name=/home/oracle/backup/example01.dbf
channel ORA_DISK_2: reading from backup piece /u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_06_26/o1_mf_nnnd1_INCR_UPDATE_do0zbqyz_.bkp
channel ORA_DISK_3: starting incremental datafile backup set restore
channel ORA_DISK_3: specifying datafile copies to recover
recovering datafile copy file number=00003 name=/home/oracle/backup/undotbs01.dbf
recovering datafile copy file number=00006 name=/home/oracle/backup/tea01.dbf
channel ORA_DISK_3: reading from backup piece /u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_06_26/o1_mf_nnnd1_INCR_UPDATE_do0zbqz6_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_06_26/o1_mf_nnnd1_INCR_UPDATE_do0zbr04_.bkp tag=INCR_UPDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:00
channel ORA_DISK_2: piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_06_26/o1_mf_nnnd1_INCR_UPDATE_do0zbqyz_.bkp tag=INCR_UPDATE
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:00
channel ORA_DISK_3: piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_06_26/o1_mf_nnnd1_INCR_UPDATE_do0zbqz6_.bkp tag=INCR_UPDATE
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:00:00
Finished recover at 2017-06-26 11:19:53

Starting Control File and SPFILE Autobackup at 2017-06-26 11:19:53
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2017_06_26/o1_mf_s_947675993_do0zbson_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2017-06-26 11:19:54

RMAN> **end-of-file**

3.可以做一个简单验证:
$ strings /home/oracle/backup/tea01.dbf | grep -i zzzz

SCOTT@book> create table ttt tablespace tea as select 'zzzzz' name  from dual connect by level<=10;
Table created.

RMAN> @ merge.rman

$ strings /home/oracle/backup/tea01.dbf | grep -i zzzz|wc
     10      10      69

--//说明ok!!

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-2141253/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267265/viewspace-2141253/

cuixun7780
关注
Oracle面试题集锦（2020大厂秋招真题）
数字成都
03-19 1万+
1，范式 7大范式：1NF, 2NF,3NF,BCNF,4NF,5NF,6NF 什么叫normalization？Denormalization? Normalization是数据库规范化，denormalization是数据库逆规范化。 在设计和操作维护数据库时，关键的步骤就是要确保数据正确地分布到数据库的表中。使用正确的数据结构，不仅便于对数据库进行相应的存取操作，而且可以极大地简化应用程序的...
举一反三：跨平台版本迁移之 XTTS 方案操作指南
Enmotech的博客
04-22 9925
作者 | 罗贵林： 云和恩墨技术工程师，具有8年以上的 Oracle 数据库工作经验，曾任职于大型的国家电信、省级财政、省级公安的维护，性能调优等。精通 Oracle 数...
[20171031]rman merge例子2.txt
10-31 86
[20171031]rman merge例子2.txt --//以前做的测试 [20170626]rman merge例子.txt --//链接 http://blog.itpub.net/267265/viewspace...
Oracle 知识篇+RMAN合并增量备份
ZZT_2009
05-08 766
说明：本文为Oracle RMAN合并增量备份/增量更新备份指导手册， 标签：RMAN增量更新备份、RMAN合并增量备份 温馨提示：如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化 ★ 开启增量备份块追踪（加速增量备份速度）（该步可要可不要） ///////////////////////////////////////////////////// SQL> alt...
多个txt合并成一个txt（简单易操作）
热门推荐
weixin_52642225的博客
12-28 2万+
多个txt合并成一个txt（简单易操作）
ORACLE-MERGE用法详解
GeneralXCK的专栏
03-26 838
Oracle9i引入了MERGE命令,你能够在一个SQL语句中对一个表同时执行inserts和updates操作. MERGE命令从一个或多个数据源中选择行来updating或inserting到一个或多个表.在Oracle 10g中MERGE有如下一些改进：1、UPDATE或INSERT子句是可选的2、UPDATE和INSERT子句可以加WHERE子句3、在
Oracle rman中restore和recover的区别
hellojoy的博客
08-14 6546
在Oracle的备份与恢复的知识点中，经常会出现Restore 和 Recovery两个词。 由于这两个词在字典中的解释很接近，困扰了我很久。直到我在Oracle的官方文档中看到了以下解释。 Restoration:A corrupted data file is overwritten from a backup of the data file .The data file is at a
[20120216]查看数据库整体性能问题sql语句.txt
02-16 66
http://dbatrain.wordpress.com/2010/11/22/do-you-have-an-oracle-background/从这个blog获得这个sql语句，通过这个查询到生产系统数据库一个seqence...
Oracle Rman
Legend的专栏
03-06 198
  Oracle9i,10g备份恢复文档  Rman     1 概述：   1.1 Oracle数据库备份类型、特点： Oracle数据库备份主要有3种类型：冷备份、热备份、逻辑备份： 冷备份（Cold Backup）主要指在关闭数据库的状态下进行的数据库完全备份，备份内容包括所有数据文件、控制文件、联机日志文件、ini文件，当数据库被关闭时，被数据库使用的每一个文件都被备...
Shell脚本学习-阶段二十七-命令解释二
qq_43058317的博客
06-16 4517
文章目录-命令解释二前言emacsjedjoenano================picosed===================vi,vim============mtype=============rgrep==========excmpbzcmpcommdiff===========bzdiffdiffstatdiff3find==============locate/slocate=========whereis==========updatedbwhich=========basena..
时过境迁：Oracle跨平台迁移之XTTS方案与实践
Enmotech的博客
02-25 3265
作者简介谢金融云和恩墨东区交付部 Oracle 工程师，多年来从事 Oracle 第三方服务，曾服务过金融、制造业、物流、政府等许多行业的客户，精通数据库迁移、性能优化和故障诊断。本文由恩墨大讲堂146期线上分享整理而成。课程回看可点击文末“阅读原文”。1前期准备1.1.  检查数据库时区，保持两边一致select dbtimezone from dual;DBTIME------+08:00 1
kettle使用中遇到的一些常见问题总结
星月情缘的博客
01-16 1万+
             大数据在ETL处理过程中，使用的工具有kettle, dataStage,infomatica等等。kettle是属于开源免费的etl 工具。基于java开发，内置了很多强大的工具，在数据清洗加工处理方面，有优越的性能和处理效率。当然如果内置的组件不能满足要求，还支持二次开发插件来解决问题，实现功能。下面简单对日常中使用kettle中出现的问题做一个总结，方便自己也方便大...
Oracle RMAN 还原与恢复（三）--Restore和recover命令
weixin_33994444的博客
06-24 608
1、RESTORE 命令虽然store 命令有一些辅助目标，但其主要功能是从RMAN备份中还原文件，为恢复做准备。 RMAN和restore 命令非常只能，他们将选择最近的备份来进行还原，从而减少恢复时间。 其结果是，restore 命令可能从备份集中还原数据文件，也可能从映像副本中还原数据文件，或者两者并用来进行还原，只要对加快还原过程有帮助即可。Restore 命令用于从...
基于FPGA的智能车牌检测系统设计与实现
11-08
内容概要：本文介绍了一种基于FPGA的智能车牌检测系统。该系统采用了OV5640摄像头进行图像采集，通过FPGA集成化开发环境进行图像处理，主要包括图像格式转换、图像灰度化、图像增强、边缘检测、腐蚀膨胀、投影定位等技术步骤。该系统能够在复杂环境中快速实现车牌的图像采集及定位，提高了车牌检测的效率和准确性。 适合人群：具备一定嵌入式系统和图像处理基础的研究人员和技术人员。 使用场景及目标：适用于智慧交通管理系统，尤其是停车场、高速公路、智能制造等领域，主要用于实现实时的车牌检测与识别。 其他说明：系统采用Sobel算子进行边缘检测，中值滤波进行图像增强，投影定位确定车牌位置，整体处理效率较高，适用于复杂光照条件下的车牌检测。
【java毕业设计】springbootJava学生选课系统(springboot+vue+mysql+说明文档).zip
11-08
项目经过测试均可完美运行！ 环境说明： 开发语言：java 框架：ssm jdk版本：jdk1.8 数据库：mysql 5.7+ 数据库工具：Navicat11+ 管理工具：maven 开发工具：idea/eclipse 部署容器：tomcat7+
JDK-API-1-6-zh-CN
11-08
JDK API 1.6 中文版，附使用说明
【java毕业设计】springbootJava校车管理信息系统(springboot+vue+mysql+说明文档).zip
11-08
项目经过测试均可完美运行！ 环境说明： 开发语言：java 框架：ssm jdk版本：jdk1.8 数据库：mysql 5.7+ 数据库工具：Navicat11+ 管理工具：maven 开发工具：idea/eclipse 部署容器：tomcat7+
resnet模型-python语言pytorch框架训练识别动物-不含数据集图片-含逐行注释和说明文档.zip
最新发布
11-08
本代码是基于python pytorch环境安装的。 下载本代码后，有个环境安装的requirement.txt文本 首先是代码的整体介绍 总共是3个py文件，十分的简便 本代码是不含数据集图片的，下载本代码后需要自行搜集图片放到对应的文件夹下即可 需要我们往每个文件夹下搜集来图片放到对应文件夹下，每个对应的文件夹里面也有一张提示图，提示图片放的位置 然后我们需要将搜集来的图片，直接放到对应的文件夹下，就可以对代码进行训练了。 运行01生成txt.py,是将数据集文件夹下的图片路径和对应的标签生成txt格式,划分了训练集和验证集 运行02CNN训练数据集.py,会自动读取txt文本内的内容进行训练，这里是适配了数据集的分类文件夹个数，即使增加了分类文件夹，也不需要修改代码即可训练 训练过程中会有训练进度条，可以查看大概训练的时长,每个epoch训练完后会显示准确率和损失值 训练结束后，会保存log日志，记录每个epoch的准确率和损失值 最后训练的模型会保存在本地名称为model.ckpt 运行03pyqt界面.py，就可以实现自己训练好的模型去识别图片了
[20150902]rman的list archivelog命令.txt
05-29
很抱歉，作为一名AI语言模型，我无法提供您所需的文本文件，但我可以告诉您有关rman list archivelog命令的一些信息。该命令用于列出备份集中可用的归档日志副本。它可以帮助数据库管理员确定哪些归档日志副本可以...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值