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

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.

上一页  [1] [2] [3] [4] 下一页

【责编:Ken】

相关文章

Oracle 10g下asm安装：候选盘问题
个人经验总结：Oracle 10g手工创建数据库
Redhat Linux AS4 安装Oracle 10g(包括启动
Oracle 10g使用RMAN创建physical standby
Oracle 10g数据库基于事件的调度
Oracle 10g恢复试验的两种方法
Oracle 10g下修改VIP地址的方法
Oracle数据库9i和10g环境下使用*.ora
删除Oracle 10g垃圾表最新方法
Oracle数据库10g新特性中的闪回查询

编辑推荐

· [入门基础]关于Oracle学习以及DBA工作机会
· [入门基础]Oracle学习的一些建议 兴趣很重要
· [入门基础]Oracle listener静态注册和动态注册总结
· [安装配置]Oracle ebs 11.5 for linux as4安装心得
· [开发技术]Oracle 11g R1下的自动内存管理
· [开发技术]究竟是否需要升级到Oracle 11g？
· [性能调优]Oracle数据库TNS常见错误解决方法
· [开发技术]Oracle数据库10gR2中stream多源复制方法
· [产品介绍]SQL Server 2008与Oracle Database 11g相比较
· [备份恢复]对Oracle数据库进行容灾

相关产品和培训

文章评论