在线精品99_中国九九盗摄偷拍偷看_91免费版在线观看_91.app_91高清视频在线_99热最新网站

基于scn的恢复是怎样的

125次阅读
没有评论

共计 5918 个字符，预计需要花费 15 分钟才能阅读完成。

今天就跟大家聊聊有关基于 scn 的恢复是怎样的，可能很多人都不太了解，为了让大家更加了解，丸趣 TV 小编给大家总结了以下内容，希望大家根据这篇文章可以有所收获。

– 先背备份：（热备）

[oracle@wang ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 – Production on Fri Dec 8 19:35:11 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DBDB (DBID=3282897732)

RMAN backup database;

Starting backup at 08-DEC-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=44 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/DBdb/users01.dbf
input datafile file number=00006 name=/u01/app/oracle/fast_recovery_area/DBDB/newback/ts_xxf_01.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/DBdb/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/DBdb/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 08-DEC-17
channel ORA_DISK_1: finished piece 1 at 08-DEC-17
piece handle=/u01/app/oracle/fast_recovery_area/DBDB/newback/DBDB/backupset/2017_12_08/o1_mf_nnndf_TAG20171208T193949_f2nyj5gy_.bkp tag=TAG20171208T193949 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/DBdb/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/DBdb/example01.dbf
channel ORA_DISK_1: starting piece 1 at 08-DEC-17
 channel ORA_DISK_1: finished piece 1 at 08-DEC-17
piece handle=/u01/app/oracle/fast_recovery_area/DBDB/newback/DBDB/backupset/2017_12_08/o1_mf_nnndf_TAG20171208T193949_f2nykwl2_.bkp tag=TAG20171208T193949 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
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 08-DEC-17
channel ORA_DISK_1: finished piece 1 at 08-DEC-17
piece handle=/u01/app/oracle/fast_recovery_area/DBDB/newback/DBDB/backupset/2017_12_08/o1_mf_ncsnf_TAG20171208T193949_f2nylpqk_.bkp tag=TAG20171208T193949 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-DEC-17

RMAN    

二、模拟操作：
SQL select current_scn from v$database;

CURRENT_SCN
———–
  3960846

SQL  
SQL create table scott.scn_a as select * from dba_objects;

Table created.

SQL select count(*) from scott.scn_a;

  COUNT(*)
———-
  87053

SQL select current_scn from v$database;

CURRENT_SCN
———–
  3960968

SQL
SQL create table hr.scn_b as select * from dba_objects;

Table created.

SQL select count(*) from hr.scn_b;

  COUNT(*)
———-
  87054

SQL select current_scn from v$database;

CURRENT_SCN
———–
  3961042

SQL    
SQL alter system switch logfile;

System altered.

SQL
SQL select current_scn from v$database;

CURRENT_SCN
———–
  3961063

SQL
SQL alter system checkpoint;

System altered.

SQL
SQL select current_scn from v$database;

CURRENT_SCN
———–
  3961088

– 删除表 scn_a/scn_b:
SQL drop table scott.scn_a purge;

Table dropped.

SQL drop table hr.scn_b purge;

Table dropped.

– 进行恢复：
– 关库，启动到 mount 状态:
SQL shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL
SQL startup mount;
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size  2257840 bytes
Variable Size  549456976 bytes
Database Buffers  281018368 bytes
Redo Buffers  2371584 bytes
Database mounted.
SQL

启用 rman 进行恢复：
[oracle@wang ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 – Production on Fri Dec 8 19:49:38 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DBDB (DBID=3282897732, not open)

RMAN    

RMAN run { 
  set until scn =3960968;  
  restore database;  
  recover database;  
  alter database open resetlogs; }

executing command: SET until clause

Starting restore at 08-DEC-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/DBdb/system01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/DBdb/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/DBdb/users01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/fast_recovery_area/DBDB/newback/ts_xxf_01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/DBDB/newback/DBDB/backupset/2017_12_08/o1_mf_nnndf_TAG20171208T193949_f2nyj5gy_.bkp
  channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/DBDB/newback/DBDB/backupset/2017_12_08/o1_mf_nnndf_TAG20171208T193949_f2nyj5gy_.bkp tag=TAG20171208T193949
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:15
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/DBdb/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/DBdb/example01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/DBDB/newback/DBDB/backupset/2017_12_08/o1_mf_nnndf_TAG20171208T193949_f2nykwl2_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/DBDB/newback/DBDB/backupset/2017_12_08/o1_mf_nnndf_TAG20171208T193949_f2nykwl2_.bkp tag=TAG20171208T193949
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 08-DEC-17

Starting recover at 08-DEC-17
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 08-DEC-17

database opened

RMAN    

– 验证：
SQL select status from v$instance;

STATUS
————
OPEN

SQL select count(*) from scott.scn_a;

  COUNT(*)
———-
  87053

SQL
SQL select count(*) from hr.scn_b;
select count(*) from hr.scn_b
  *
ERROR at line 1:
ORA-00942: table or view does not exist

因为恢复时只是恢复到创建 scn_a 表后查询到的 current_scn，此时表 scn_b 还没有创建。

看完上述内容，你们对基于 scn 的恢复是怎样的有进一步的了解吗？如果还想了解更多知识或者相关内容，请关注丸趣 TV 行业资讯频道，感谢大家的支持。

正文完
发表至： 数据库
2023-07-20
 
丸趣
版权声明：本站原创文章，由 丸趣 2023-07-20发表，共计5918字。
转载说明：除特殊说明外本站除技术相关以外文章皆由网络搜集发布，转载请注明出处。
评论（没有评论）
主站蜘蛛池模板： 国产精品久久久久9999爆乳 | 在线观看亚洲人成网站 | 爆乳女仆高潮在线观看 | 国产亚洲欧美另类久久久 | 午夜国产福利在线 | 国产亚洲欧美久久精品 | 精品国产一区二区三区在线 | 国产chinese视频在线观看 | 欧美一区二区三区香蕉视 | 久久久综合香蕉尹人综合网 | 欧美一级在线毛片免费观看 | 日韩欧美亚洲天堂 | 久视频在线观看久视频 | 欧美成人三级网站在线观看 | 亚洲精品宾馆在线精品酒店 | 久久精品1| 四虎精品免费国产成人 | 欧美uc恋夜在线全部视频 | 亚洲av永久无码天堂网 | 久久加久久 | 狠狠人妻久久久久久综合 | 暴力强奷在线播放无码 | 欧美在线视频一区 | 久久国产avjust麻豆 | 欧美日韩乱码毛片免费观看 | 亚洲av日韩综合一区二区三区 | 高清国产露脸捆绑01经典 | 女网址www女大全小 女网址www女高清中国 | 影音先锋男人站 | 国产精品综合在线 | 久久亚洲av成人无码国产 | 4hu永久影院在线四虎 | 亚洲精品久久久久久久网站 | 久久女同 | 国产偷国产偷亚洲清高动态图 | 毛片免费在线观看网址 | 欲色欲色天天天www 欲香欲色天天天综合和网 欲香欲色天天综合和网 | 免费观看一区二区 | 国产偷国产偷精品高清尤物 | 欧美国产免费 | 久操免费视频 |