Oracle 10g跨越Resetlogs时间点进行恢复

来源：pcdog 作者：佚名 出处：巧巧读书 2008-05-05 进入讨论组

• 关 键 词：
• oracle 10g
• oracle数据库
• switch
• 备份数据库
• flash

上一页 1 2 3 4 下一页 

Starting recover at 2005-04-05 16:41:46

using channel ORA_DISK_1

datafile 8 not processed because file is offline

starting media recovery

archive log thread 1 sequence 7 is already on disk as file /data5/flash_recovery_area/EYGLE/archivelog

/2005_04_05/o1_mf_1_7_154m8z7k_.arc

channel ORA_DISK_1: starting archive log

restore to default destination

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=6

channel ORA_DISK_1: restored backup piece 1

piece handle=/data5/flash_recovery_area/EYGLE/backupset

/2005_04_05/o1_mf_annnn_TAG20050405T163142_154m7jpo_.bkp

tag=TAG20050405T163142

channel ORA_DISK_1: restore complete

archive log filename=/data5/flash_recovery_area/EYGLE/archivelog

/2005_04_05/o1_mf_1_6_154mtkfk_.arc thread=1 sequence=6

channel default: deleting archive log(s)

archive log filename=/data5/flash_recovery_area/EYGLE/archivelog

/2005_04_05/o1_mf_1_6_154mtkfk_.arc recid=302 stamp=554834513

archive log filename=/data5/flash_recovery_area/EYGLE/archivelog

/2005_04_05/o1_mf_1_7_154m8z7k_.arc thread=1 sequence=7

media recovery complete

Finished recover at 2005-04-05 16:41:57

RMAN> alter database open resetlogs;

database opened

RMAN> exit

Recovery Manager complete.

四、此时的数据库状态

$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Apr 5 16:43:58 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition

Release 10.1.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SYS AS SYSDBA on 2005-04-05 16:43:58 >archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 1

Next log sequence to archive 1

Current log sequence 1

SYS AS SYSDBA on 2005-04-05 16:44:01 >select count(*) from t;

COUNT(*)

----------

18956

五、继续进行数据更改

SYS AS SYSDBA on 2005-04-05 16:44:08 >

create table tt as select * from dba_users;

Table created.

SYS AS SYSDBA on 2005-04-05 16:45:51 >alter system switch logfile;

System altered.

SYS AS SYSDBA on 2005-04-05 16:45:56 >select count(*) from tt;

COUNT(*)

----------

12

SYS AS SYSDBA on 2005-04-05 16:46:01 >insert into tt select * from tt;

12 rows created.

SYS AS SYSDBA on 2005-04-05 16:46:13 >commit;

Commit complete.

SYS AS SYSDBA on 2005-04-05 16:46:16 >alter system switch logfile;

System altered.

更多内容请看Oracle 10g基础应用、Oracle 10g优化恢复、备份恢复专题，或进入讨论组讨论。

上一页 1 2 3 4 下一页 

【收藏此文】【大 中 小】【打印】【关闭】

较早的文章：Oracle数据库提供的多种安全性措施

较新的文章：带你快速了解Oracle数据库提供的恢复机制