---基于时间的不完全恢复-程序员宅基地

---基于时间的不完全恢复

[oracle@station datafile]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 9 17:11:44 2012

connected to target database: ORCL (DBID=1312694260)

RMAN> list backup;

using target database control file instead of recovery catalog

RMAN> backup archivelog all delete all input; ------ 备份默认目录下所有归档日志，并且删除这个目录下所有归档日志

Starting backup at 09-JUN-12
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=141 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=38 recid=37 stamp=785521285
input archive log thread=1 sequence=39 recid=38 stamp=785521355
input archive log thread=1 sequence=40 recid=39 stamp=785522322
channel ORA_DISK_1: starting piece 1 at 09-JUN-12
channel ORA_DISK_1: finished piece 1 at 09-JUN-12
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_06_09/o1_mf_annnn_TAG20120609T171231_7x7h20xb_.bkp tag=TAG20120609T171231 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_38_7x7d25qb_.arc recid=37 stamp=785521285
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_39_7x7d4cw3_.arc recid=38 stamp=785521355
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_40_7x7f2lc4_.arc recid=39 stamp=785522322
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=1 recid=40 stamp=785522710
input archive log thread=1 sequence=2 recid=41 stamp=785522833
input archive log thread=1 sequence=3 recid=42 stamp=785522881
input archive log thread=1 sequence=4 recid=43 stamp=785522924
input archive log thread=1 sequence=5 recid=44 stamp=785522959
input archive log thread=1 sequence=6 recid=45 stamp=785523017
input archive log thread=1 sequence=7 recid=46 stamp=785523040
input archive log thread=1 sequence=8 recid=47 stamp=785523055
input archive log thread=1 sequence=9 recid=48 stamp=785523413
channel ORA_DISK_1: starting piece 1 at 09-JUN-12
channel ORA_DISK_1: finished piece 1 at 09-JUN-12
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_06_09/o1_mf_annnn_TAG20120609T171231_7x7h233q_.bkp tag=TAG20120609T171231 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_1_7x7fgpof_.arc recid=40 stamp=785522710
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_2_7x7flk64_.arc recid=41 stamp=785522833
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_3_7x7fn16y_.arc recid=42 stamp=785522881
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_4_7x7fod5l_.arc recid=43 stamp=785522924
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_5_7x7fph2o_.arc recid=44 stamp=785522959
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_6_7x7fr97q_.arc recid=45 stamp=785523017
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_7_7x7fs08x_.arc recid=46 stamp=785523040
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_8_7x7fsh6x_.arc recid=47 stamp=785523055
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_9_7x7g4o20_.arc recid=48 stamp=785523413
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=1 recid=49 stamp=785524351
channel ORA_DISK_1: starting piece 1 at 09-JUN-12
channel ORA_DISK_1: finished piece 1 at 09-JUN-12
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_06_09/o1_mf_annnn_TAG20120609T171231_7x7h2594_.bkp tag=TAG20120609T171231 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_1_7x7h1z3f_.arc recid=49 stamp=785524351
Finished backup at 09-JUN-12

RMAN> backup tag 'strom_full_0_backup' incremental level 0 database plus archivelog; ------ 增量备份

Starting backup at 09-JUN-12
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2 recid=50 stamp=785524470
channel ORA_DISK_1: starting piece 1 at 09-JUN-12
channel ORA_DISK_1: finished piece 1 at 09-JUN-12
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_06_09/o1_mf_annnn_STROM_FULL_0_BACKUP_7x7h5q8h_.bkp tag=STROM_FULL_0_BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 09-JUN-12

Starting backup at 09-JUN-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_7x4hyn9s_.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_7wnthzp2_.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_7wntlh6m_.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_7wnthzt6_.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_7x4cxo35_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-12
channel ORA_DISK_1: finished piece 1 at 09-JUN-12
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_06_09/o1_mf_nnnd0_STROM_FULL_0_BACKUP_7x7h5rj3_.bkp tag=STROM_FULL_0_BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 09-JUN-12
channel ORA_DISK_1: finished piece 1 at 09-JUN-12
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_06_09/o1_mf_ncsn0_STROM_FULL_0_BACKUP_7x7h7ton_.bkp tag=STROM_FULL_0_BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 09-JUN-12

Starting backup at 09-JUN-12
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=3 recid=51 stamp=785524539
channel ORA_DISK_1: starting piece 1 at 09-JUN-12
channel ORA_DISK_1: finished piece 1 at 09-JUN-12
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_06_09/o1_mf_annnn_STROM_FULL_0_BACKUP_7x7h7wv5_.bkp tag=STROM_FULL_0_BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 09-JUN-12

RMAN> quit

Recovery Manager complete.
[oracle@station datafile]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 9 17:16:19 2012

SQL> conn /as sysdba
Connected.
SQL> create table hr.strom (a number) tablespace users;

Table created.

SQL> alter system switch logfile;

System altered.

SQL> insert into hr.strom values(1);

1 row created.

SQL> commit;

Commit complete.

SQL> host sleep 5

SQL> alter system switch logfile;

System altered.

SQL> insert into hr.strom values(2);

1 row created.

SQL> alter system switch logfile;

System altered.

SQL> commit;

Commit complete.

SQL> drop table hr.strom;

Table dropped.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> !
[oracle@station datafile]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 9 17:23:14 2012

connected to target database: ORCL (DBID=1312694260, not open)

RMAN> run { sql "alter session set nls_date_format=''yyyy-mm-dd:hh24:mi:ss''";
2> set until time '2012-06-09:17:18:27'; ----还原到这个时间点，2012-06-09:17:18:27时间是上面 sleep 5 后记录的时间看时间用linux上的date命令
3> restore database;
4> recover database;
5> }

using target database control file instead of recovery catalog
sql statement: alter session set nls_date_format=''yyyy-mm-dd:hh24:mi:ss''

executing command: SET until clause

Starting restore at 09-JUN-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_7x4hyn9s_.dbf
restoring datafile 00002 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_7wnthzt6_.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_7wnthzp2_.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_7x4cxo35_.dbf
restoring datafile 00005 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_7wntlh6m_.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_06_09/o1_mf_nnnd0_STROM_FULL_0_BACKUP_7x7h5rj3_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_06_09/o1_mf_nnnd0_STROM_FULL_0_BACKUP_7x7h5rj3_.bkp tag=STROM_FULL_0_BACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
Finished restore at 09-JUN-12

Starting recover at 09-JUN-12
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 3 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_3_7x7h7vqf_.arc
archive log thread 1 sequence 4 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_4_7x7hc0gs_.arc
archive log thread 1 sequence 5 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_5_7x7hgclh_.arc
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_3_7x7h7vqf_.arc thread=1 sequence=3
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_4_7x7hc0gs_.arc thread=1 sequence=4
media recovery complete, elapsed time: 00:00:02
Finished recover at 09-JUN-12

RMAN> alter database open resetlogs; ----- 执行了resetlogs命令之后，数据库的操作是：将没归档的日志都归档；然后将联机日志组都置为新的，序号从0开始。

database opened

RMAN> quit

Recovery Manager complete.
[oracle@station datafile]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 9 17:29:43 2012

SQL> conn /as sysdba
Connected.
SQL> select * from hr.strom;

A
----------
1

转载于:https://blog.51cto.com/atxstrom/893870

本文链接：https://blog.csdn.net/weixin_33676492/article/details/92742684

原作者删帖不实内容删帖广告或垃圾文章投诉

智能推荐

oracle 12c 集群安装后的检查_12c查看crs状态-程序员宅基地

文章浏览阅读1.6k次。安装配置gi、安装数据库软件、dbca建库见下：http://blog.csdn.net/kadwf123/article/details/784299611、检查集群节点及状态：[root@rac2 ~]# olsnodes -srac1 Activerac2 Activerac3 Activerac4 Active[root@rac2 ~]_12c查看crs状态

解决jupyter notebook无法找到虚拟环境的问题_jupyter没有pytorch环境-程序员宅基地

文章浏览阅读1.3w次，点赞45次，收藏99次。我个人用的是anaconda3的一个python集成环境，自带jupyter notebook，但在我打开jupyter notebook界面后，却找不到对应的虚拟环境，原来是jupyter notebook只是通用于下载anaconda时自带的环境，其他环境要想使用必须手动下载一些库：1.首先进入到自己创建的虚拟环境(pytorch是虚拟环境的名字)activate pytorch2.在该环境下下载这个库conda install ipykernelconda install nb__jupyter没有pytorch环境

国内安装scoop的保姆教程_scoop-cn-程序员宅基地

文章浏览阅读5.2k次，点赞19次，收藏28次。选择scoop纯属意外，也是无奈，因为电脑用户被锁了管理员权限，所有exe安装程序都无法安装，只可以用绿色软件，最后被我发现scoop，省去了到处下载XXX绿色版的烦恼，当然scoop里需要管理员权限的软件也跟我无缘了（譬如everything）。推荐添加dorado这个bucket镜像，里面很多中文软件，但是部分国外的软件下载地址在github，可能无法下载。以上两个是官方bucket的国内镜像，所有软件建议优先从这里下载。上面可以看到很多bucket以及软件数。如果官网登陆不了可以试一下以下方式。_scoop-cn

Element ui colorpicker在Vue中的使用_vue el-color-picker-程序员宅基地

文章浏览阅读4.5k次，点赞2次，收藏3次。首先要有一个color-picker组件 <el-color-picker v-model="headcolor"></el-color-picker>在data里面data() { return {headcolor: ’ #278add ’ //这里可以选择一个默认的颜色} }然后在你想要改变颜色的地方用v-bind绑定就好了，例如：这里的:sty..._vue el-color-picker

迅为iTOP-4412精英版之烧写内核移植后的镜像_exynos 4412 刷机-程序员宅基地

文章浏览阅读640次。基于芯片日益增长的问题，所以内核开发者们引入了新的方法，就是在内核中只保留函数，而数据则不包含，由用户（应用程序员）自己把数据按照规定的格式编写，并放在约定的地方，为了不占用过多的内存，还要求数据以根精简的方式编写。boot启动时，传参给内核，告诉内核设备树文件和kernel的位置，内核启动时根据地址去找到设备树文件，再利用专用的编译器去反编译dtb文件，将dtb还原成数据结构，以供驱动的函数去调用。firmware是三星的一个固件的设备信息，因为找不到固件，所以内核启动不成功。_exynos 4412 刷机

Linux系统配置jdk_linux配置jdk-程序员宅基地

文章浏览阅读2w次，点赞24次，收藏42次。Linux系统配置jdkLinux学习教程，Linux入门教程（超详细）_linux配置jdk

随便推点

matlab(4)：特殊符号的输入_matlab微米怎么输入-程序员宅基地

文章浏览阅读3.3k次，点赞5次，收藏19次。xlabel('\delta');ylabel('AUC');具体符号的对照表参照下图：_matlab微米怎么输入

C语言程序设计-文件(打开与关闭、顺序、二进制读写)-程序员宅基地

文章浏览阅读119次。顺序读写指的是按照文件中数据的顺序进行读取或写入。对于文本文件，可以使用fgets、fputs、fscanf、fprintf等函数进行顺序读写。在C语言中，对文件的操作通常涉及文件的打开、读写以及关闭。文件的打开使用fopen函数，而关闭则使用fclose函数。在C语言中，可以使用fread和fwrite函数进行二进制读写。‍ Biaoge 于2024-03-09 23:51发布阅读量：7 ️文章类型：【 C语言程序设计】在C语言中，用于打开文件的函数是____，用于关闭文件的函数是____。

Touchdesigner自学笔记之三_touchdesigner怎么让一个模型跟着鼠标移动-程序员宅基地

文章浏览阅读3.4k次，点赞2次，收藏13次。跟随鼠标移动的粒子以grid（SOP）为partical（SOP）的资源模板，调整后连接【Geo组合+point spirit（MAT)】，在连接【feedback组合】适当调整。影响粒子动态的节点【metaball(SOP)+force(SOP)】添加mouse in（CHOP)鼠标位置到metaball的坐标，实现鼠标影响。..._touchdesigner怎么让一个模型跟着鼠标移动

【附源码】基于java的校园停车场管理系统的设计与实现61m0e9计算机毕设SSM_基于java技术的停车场管理系统实现与设计-程序员宅基地

文章浏览阅读178次。项目运行环境配置：Jdk1.8 + Tomcat7.0 + Mysql + HBuilderX（Webstorm也行）+ Eclispe（IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持）。项目技术：Springboot + mybatis + Maven +mysql5.7或8.0+html+css+js等等组成，B/S模式 + Maven管理等等。环境需要1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。_基于java技术的停车场管理系统实现与设计

Android系统播放器MediaPlayer源码分析_android多媒体播放源码分析时序图-程序员宅基地

文章浏览阅读3.5k次。前言对于MediaPlayer播放器的源码分析内容相对来说比较多，会从Java-&amp;gt;Jni-&amp;gt;C/C++慢慢分析，后面会慢慢更新。另外，博客只作为自己学习记录的一种方式，对于其他的不过多的评论。MediaPlayerDemopublic class MainActivity extends AppCompatActivity implements SurfaceHolder.Cal..._android多媒体播放源码分析时序图

java 数据结构与算法 ——快速排序法-程序员宅基地

文章浏览阅读2.4k次，点赞41次，收藏13次。java 数据结构与算法 ——快速排序法_快速排序法