ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > 使用RMAN,建立恢复点

使用RMAN,建立恢复点

原创 Oracle 作者：Rman2017 时间：2017-04-19 09:12:44 0 删除 编辑

RMAN>run{

Set until time “to_date(‘14/03/14 15:00:00’,’dd/mm/yy hh24:mi:ss’)”;

Restore database;

Recover database;

alter database open resetlogs;

}

SQL> set time on

07:46:56 SQL> conn test/test

Connected.

07:47:31 SQL>  create table test (id number,name varchar2(20));


Table created.


07:47:48 SQL> insert into test values (1,'liushiming');


1 row created.


07:48:06 SQL> commit;


Commit complete.


07:48:08 SQL> select * from test;


        ID NAME

---------- --------------------

         1 liushiming


07:49:24 SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.



RMAN> startup mount;


Oracle instance started

database mounted


Total System Global Area     419430400 bytes


Fixed Size                     1267812 bytes

Variable Size                301991836 bytes

Database Buffers             109051904 bytes

Redo Buffers                   7118848 bytes



RMAN> run {

2> set until time "to_date('31/08/14 07:47:00','dd/mm/yy hh24:mi:ss')";

3> restore database;

4> recover database;

5> }            


executing command: SET until clause


Starting restore at 31-AUG-14

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=187 devtype=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: sid=185 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 /dat/DBData/oradata/NACEC/system01.dbf

restoring datafile 00004 to /dat/DBData/oradata/NACEC/users01.dbf

restoring datafile 00005 to /dat/DBData/oradata/NACEC/test_undo.dbf

restoring datafile 00010 to /dat/DBData/oradata/NACEC/liusm.dbf

restoring datafile 00012 to /dat/DBData/oradata/NACEC/myTableSpace2.dbf

restoring datafile 00014 to /dat/DBSoftware/oracle/product/10.2.0/db_1/dbs/users02.dbf

restoring datafile 00015 to /dat/DBData/oradata/NACEC/users03.dbf

channel ORA_DISK_1: reading from backup piece /dat/DBSoftware/oracle/flash_recovery_area/NACEC/backupset/2014_08_31/o1_mf_nnndf_TAG20140831T074445_b04rhg0q_.bkp

channel ORA_DISK_2: starting datafile backupset restore

channel ORA_DISK_2: specifying datafile(s) to restore from backup set

restoring datafile 00016 to /dat/DBData/oradata/NACEC/rowchain.dbf

channel ORA_DISK_2: reading from backup piece /dat/DBSoftware/oracle/flash_recovery_area/NACEC/backupset/2014_08_31/o1_mf_nnndf_TAG20140831T074445_b04rks7x_.bkp

channel ORA_DISK_2: restored backup piece 1

piece handle=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/backupset/2014_08_31/o1_mf_nnndf_TAG20140831T074445_b04rks7x_.bkp tag=TAG20140831T074445

channel ORA_DISK_2: restore complete, elapsed time: 00:00:01

channel ORA_DISK_2: starting datafile backupset restore

channel ORA_DISK_2: specifying datafile(s) to restore from backup set

restoring datafile 00002 to /dat/DBData/oradata/NACEC/undotbs01.dbf

restoring datafile 00003 to /dat/DBData/oradata/NACEC/sysaux01.dbf

restoring datafile 00006 to /dat/DBData/oradata/NACEC/tempundotbs.dbf

restoring datafile 00007 to /dat/DBData/oradata/NACEC/ECOAL/test.dbf

restoring datafile 00008 to /dat/DBData/oradata/NACEC/ECOAL/test1.dbf

restoring datafile 00009 to /dat/DBData/oradata/NACEC/catalog.dbf

restoring datafile 00011 to /dat/DBData/oradata/NACEC/myTableSpace1.dbf

restoring datafile 00013 to /dat/DBData/oradata/NACEC/myTableSpace3.dbf

channel ORA_DISK_2: reading from backup piece /bak/rmanbak/backup_37phaerd_1_1

channel ORA_DISK_1: restored backup piece 1

piece handle=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/backupset/2014_08_31/o1_mf_nnndf_TAG20140831T074445_b04rhg0q_.bkp tag=TAG20140831T074445

channel ORA_DISK_1: restore complete, elapsed time: 00:01:37

channel ORA_DISK_2: restored backup piece 1

piece handle=/bak/rmanbak/backup_37phaerd_1_1 tag=TAG20140831T074445

channel ORA_DISK_2: restore complete, elapsed time: 00:01:35

Finished restore at 31-AUG-14


Starting recover at 31-AUG-14

using channel ORA_DISK_1

using channel ORA_DISK_2


starting media recovery


archive log thread 1 sequence 41 is already on disk as file /dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_41_b04rl8lq_.arc

channel ORA_DISK_1: starting archive log restore to default destination

channel ORA_DISK_2: starting archive log restore to default destination

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=24

channel ORA_DISK_2: restoring archive log

archive log thread=1 sequence=40

channel ORA_DISK_2: reading from backup piece /bak/rmanbak/backup_35phaeqp_1_1

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=25

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=26

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=27

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=28

channel ORA_DISK_2: restored backup piece 1

piece handle=/bak/rmanbak/backup_35phaeqp_1_1 tag=TAG20140831T074327

channel ORA_DISK_2: restore complete, elapsed time: 00:00:02

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=29

channel ORA_DISK_2: starting archive log restore to default destination

channel ORA_DISK_2: restoring archive log

archive log thread=1 sequence=33

channel ORA_DISK_2: restoring archive log

archive log thread=1 sequence=34

channel ORA_DISK_2: restoring archive log

archive log thread=1 sequence=35

channel ORA_DISK_2: restoring archive log

archive log thread=1 sequence=36

channel ORA_DISK_2: restoring archive log

archive log thread=1 sequence=37

channel ORA_DISK_2: restoring archive log

archive log thread=1 sequence=38

channel ORA_DISK_2: restoring archive log

archive log thread=1 sequence=39

channel ORA_DISK_2: reading from backup piece /dat/DBSoftware/oracle/flash_recovery_area/NACEC/backupset/2014_08_31/o1_mf_annnn_TAG20140831T074327_b04rf1b6_.bkp

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=30

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=31

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=32

channel ORA_DISK_1: reading from backup piece /bak/rmanbak/backup_34phaep0_1_1

channel ORA_DISK_1: restored backup piece 1

piece handle=/bak/rmanbak/backup_34phaep0_1_1 tag=TAG20140831T074327

channel ORA_DISK_1: restore complete, elapsed time: 00:00:28

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_24_b04s5qcq_.arc thread=1 sequence=24

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_24_b04s5qcq_.arc recid=117 stamp=857030219

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_25_b04s5rk7_.arc thread=1 sequence=25

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_25_b04s5rk7_.arc recid=118 stamp=857030219

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_26_b04s5sxc_.arc thread=1 sequence=26

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_26_b04s5sxc_.arc recid=119 stamp=857030219

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_27_b04s5x9q_.arc thread=1 sequence=27

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_27_b04s5x9q_.arc recid=114 stamp=857030218

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_28_b04s5yh3_.arc thread=1 sequence=28

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_28_b04s5yh3_.arc recid=104 stamp=857030208

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_29_b04s5yyg_.arc thread=1 sequence=29

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_29_b04s5yyg_.arc recid=106 stamp=857030208

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_30_b04s60mn_.arc thread=1 sequence=30

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_30_b04s60mn_.arc recid=108 stamp=857030208

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_31_b04s5nt3_.arc thread=1 sequence=31

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_31_b04s5nt3_.arc recid=116 stamp=857030219

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_32_b04s5v9w_.arc thread=1 sequence=32

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_32_b04s5v9w_.arc recid=115 stamp=857030218

channel ORA_DISK_2: restored backup piece 1

piece handle=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/backupset/2014_08_31/o1_mf_annnn_TAG20140831T074327_b04rf1b6_.bkp tag=TAG20140831T074327

channel ORA_DISK_2: restore complete, elapsed time: 00:00:28

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_33_b04s5ln6_.arc thread=1 sequence=33

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_33_b04s5ln6_.arc recid=109 stamp=857030209

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_34_b04s5lmk_.arc thread=1 sequence=34

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_34_b04s5lmk_.arc recid=107 stamp=857030208

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_35_b04s5lj7_.arc thread=1 sequence=35

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_35_b04s5lj7_.arc recid=113 stamp=857030218

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_36_b04s5lkd_.arc thread=1 sequence=36

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_36_b04s5lkd_.arc recid=112 stamp=857030217

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_37_b04s5lnp_.arc thread=1 sequence=37

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_37_b04s5lnp_.arc recid=110 stamp=857030211

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_38_b04s5ljn_.arc thread=1 sequence=38

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_38_b04s5ljn_.arc recid=111 stamp=857030213

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_39_b04s5lkz_.arc thread=1 sequence=39

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_39_b04s5lkz_.arc recid=105 stamp=857030208

channel default: deleting archive log(s)

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_08_31/o1_mf_1_40_b04s5k9p_.arc recid=103 stamp=857030194

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

Finished recover at 31-AUG-14



SQL> alter database open resetlogs;


Database altered.


SQL> conn test/test

Connected.

SQL> select table_name from user_tables;


TABLE_NAME

------------------------------

T

PLAN_TABLE

TESTCCC

TE

MYTEST000

DDDD

TESTBBB

TESTAAA

MYTEST01

MYTEST2

SYS_TEMP_FBT


TABLE_NAME

------------------------------

MYTEST00


12 rows selected.


SQL> select * from test;

select * from test

              *

ERROR at line 1:

ORA-00942: table or view does not exist


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

0
0
上一篇： 使用RMAN，在不同位置上还原数据库
下一篇： 使用RMAN,基于SCN的恢复
请登录后发表评论 登录
全部评论
Rman2017

注册时间：2017-03-30

  • 博文量
    352
  • 访问量
    132822

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593