一个通过BBED强制恢复offline状态的datafile的例子.docVIP

Focus on Oracle 一个通过BBED强制恢复offline状态的datafile的例子 By cui hua on October 14, 2009 7:41 PM | 2 Comments | No TrackBacks BBED强制让丢失了online需要的archive log的offline状态的datafile恢复成了online，并且成功抢救出来了数据。 希望如下的恢复过程能对朋友们有所帮助。 ? $ sqlplus / as sysdba; ? SQL*Plus: Release .0 - Production on Wed Oct 14 13:21:25 2009 ? Copyright (c) 1982, 2002, Oracle Corporation.? All rights reserved. ? ? Connected to: Oracle9i Enterprise Edition Release .0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release .0 - Production ? ? SQL_astcaarchive log list; Database log mode????????????? Archive Mode Automatic archival???????????? Enabled Archive destination??????????? /dras20/astca/arch Oldest online log sequence???? 9377 Next log sequence to archive?? 9379 Current log sequence?????????? 9379 ? SQL_astca create tablespace testscn datafile /dras20/astca/testscn_01.dbf size 100M extent management local uniform size 1M segment space management auto; ? Tablespace created ? SQL_astca create table tbtestscn tablespace testscn as select * from dba_users; ? Table created ? SQL_astca select count(*) from tbtestscn; ? ? COUNT(*) ??????? 32 ? SQL_astca select username from tbtestscn where rownum5; ? USERNAME SYS SCOTT SYSTEM DBSNMP ? SQL_astcaselect file_id from dba_data_files where file_name=/dras20/astca/testscn_01.dbf; ? ?? FILE_ID ?????? 139 ? SQL_astcaalter database datafile /dras20/astca/testscn_01.dbf offline; ? Database altered. ? SQL_astcaselect status from v$datafile where file#=139; ? STATUS RECOVER ? SQL_astcaalter system switch logfile; ? System altered. ? SQL_astcaalter system switch logfile; ? System altered. ? SQL_astcaalter system switch logfile; ? System altered. ? SQL_astcaalter system switch logfile; ? System altered. ? $ cd /dras20/astca/arch $ ls -l total 1888 -rw-r?? 1 oracle?? dba????????? 901120 Oct 14 16:45 1_9379.dbf -rw-r?? 1 oracle?? dba?????????? 48640 Oct 14 17:18 1_9380.dbf -rw-r?? 1 oracle?? dba??????????? 1024 Oct 14 17:18 1_9381.db