oracle脱机状态什么意思,oracle通过归档日志进行脱机恢复

最新推荐文章于 2021-04-15 14:58:00 发布

weixin_39964573

最新推荐文章于 2021-04-15 14:58:00 发布

阅读量208

点赞数

文章标签： oracle脱机状态什么意思

5.7号在给表空间增加数据文件时，没注意系统给文件多加了一个.dbf扩展名,成了.dbf.dbf文件，看着不爽对此文件进行了脱机。又另增加了一个数据文件。当时考虑直接把.dbf.dbf的那个文件给脱机 drop，网上一查9i不能drop,此时发现不能进行联机,此已经是9号，归档日志文件已经rman自动备份后进行了删除，此文即是对此恢复的一个记录。生产系统，做之前一定要做好备份，万事不能心存侥幸。

此事，再次提醒自己一点要小心，细心再细心。

telnet (acdb2.xxx.cn)

AIX Version 5

root's Password:

*******************************************************************************

* *

* Welcome to AIX Version 5.2! *

* *

* Please see the README file in /usr/lpp/bos for information pertinent to *

* this release of the AIX Operating System. *

* *

*******************************************************************************

Last unsuccessful login: Fri May 9 14:17:06 2008 on /dev/pts/2 from 10.0.101.230

Last login: Fri May 9 15:14:26 2008 on /dev/pts/1 from 10.0.101.230

# bash

cdbash-2.05a# su - oracle

[YOU HAVE NEW MAIL]

[acdb2][/home/oracle]$echo $ORACLE_HOME

/arpsa/OraHome1

[acdb2][/home/oracle]$bash

bash-2.05a$ rman

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

RMAN> connect target;

connected to target database: ORAARP (DBID=1195582038)

RMAN> run {

2> allocate channel ch00 type 'SBT_TAPE';

3> recover datafile '/arpdata1/oradata/oraarp/T_PAY1.dbf.dbf';

4> release channel ch00;

5> }

using target database controlfile instead of recovery catalog

allocated channel: ch00

channel ch00: sid=13 devtype=SBT_TAPE

channel ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2004111820)

Starting recover at 09-MAY-08

starting media recovery

channel ch00: starting archive log restore to default destination

channel ch00: restoring archive log

archive log thread=1 sequence=24414

channel ch00: restoring archive log

archive log thread=1 sequence=24415

channel ch00: restoring archive log

archive log thread=1 sequence=24416

channel ch00: restoring archive log

archive log thread=1 sequence=24417

channel ch00: restoring archive log

archive log thread=1 sequence=24418

channel ch00: restoring archive log

archive log thread=1 sequence=24419

channel ch00: restoring archive log

archive log thread=1 sequence=24420

channel ch00: restoring archive log

archive log thread=1 sequence=24421

channel ch00: restoring archive log

archive log thread=1 sequence=24422

channel ch00: restoring archive log

archive log thread=1 sequence=24423

channel ch00: restoring archive log

archive log thread=1 sequence=24424

channel ch00: restoring archive log

archive log thread=1 sequence=24425

channel ch00: restoring archive log

archive log thread=1 sequence=24426

channel ch00: restoring archive log

archive log thread=1 sequence=24427

channel ch00: restoring archive log

archive log thread=1 sequence=24428

channel ch00: restoring archive log

archive log thread=1 sequence=24429

channel ch00: restored backup piece 1

piece handle=al_3948_1_654128333 tag=TAG20080507T220838 params=NULL

channel ch00: restore complete

archive log filename=/arpdata/oradata/oraarp/archive/1_24414.dbf thread=1 sequence=24414

media recovery complete

channel ch00: starting archive log restore to default destination

channel ch00: restoring archive log

archive log thread=1 sequence=24430

channel ch00: restoring archive log

archive log thread=1 sequence=24431

channel ch00: restoring archive log

archive log thread=1 sequence=24432

channel ch00: restoring archive log

archive log thread=1 sequence=24433

channel ch00: restoring archive log

archive log thread=1 sequence=24434

channel ch00: restoring archive log

archive log thread=1 sequence=24435

channel ch00: restoring archive log

archive log thread=1 sequence=24436

channel ch00: restoring archive log

archive log thread=1 sequence=24437

channel ch00: restoring archive log

archive log thread=1 sequence=24438

channel ch00: restoring archive log

archive log thread=1 sequence=24439

channel ch00: restoring archive log

archive log thread=1 sequence=24440

channel ch00: restoring archive log

archive log thread=1 sequence=24441

channel ch00: restoring archive log

archive log thread=1 sequence=24442

channel ch00: restoring archive log

archive log thread=1 sequence=24443

channel ch00: restoring archive log

archive log thread=1 sequence=24444

channel ch00: restoring archive log

archive log thread=1 sequence=24445

channel ch00: restoring archive log

archive log thread=1 sequence=24446

channel ch00: restored backup piece 1

piece handle=al_3949_1_654214132 tag=TAG20080508T220849 params=NULL

channel ch00: restore complete

channel ch00: starting archive log restore to default destination

channel ch00: restoring archive log

archive log thread=1 sequence=24447

channel ch00: restoring archive log

archive log thread=1 sequence=24448

channel ch00: restoring archive log

archive log thread=1 sequence=24449

channel ch00: restoring archive log

archive log thread=1 sequence=24450

channel ch00: restoring archive log

archive log thread=1 sequence=24451

channel ch00: restoring archive log

archive log thread=1 sequence=24452

channel ch00: restoring archive log

archive log thread=1 sequence=24453

channel ch00: restoring archive log

archive log thread=1 sequence=24454

channel ch00: restoring archive log

archive log thread=1 sequence=24455

channel ch00: restoring archive log

archive log thread=1 sequence=24456

channel ch00: restoring archive log

archive log thread=1 sequence=24457

channel ch00: restored backup piece 1

piece handle=al_3969_1_654289754 tag=TAG20080509T190912 params=NULL

channel ch00: restore complete

channel ch00: starting archive log restore to default destination

channel ch00: restoring archive log

archive log thread=1 sequence=24458

channel ch00: restoring archive log

archive log thread=1 sequence=24459

channel ch00: restoring archive log

archive log thread=1 sequence=24460

channel ch00: restoring archive log

archive log thread=1 sequence=24461

channel ch00: restoring archive log

archive log thread=1 sequence=24462

channel ch00: restoring archive log

archive log thread=1 sequence=24463

channel ch00: restoring archive log

archive log thread=1 sequence=24464

channel ch00: restoring archive log

archive log thread=1 sequence=24465

channel ch00: restoring archive log

archive log thread=1 sequence=24466

channel ch00: restoring archive log

archive log thread=1 sequence=24467

channel ch00: restoring archive log

archive log thread=1 sequence=24468

channel ch00: restored backup piece 1

piece handle=al_3970_1_654289832 tag=TAG20080509T190912 params=NULL

channel ch00: restore complete

Finished recover at 09-MAY-08

released channel: ch00

RMAN>

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

由于9i无法drop,只好把文件联机后改名继续用了 :->,此是记录。

bash-2.05a$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Fri May 9 20:48:28 2008

SQL> conn /as sysdba

Connected.

SQL> alter database rename file '/arpdata1/oradata/oraarp/T_PAY1.dbf.dbf' to '/arpdata1/oradata/oraarp/T_PAY2.dbf';

alter database rename file '/arpdata1/oradata/oraarp/T_PAY1.dbf.dbf' to '/arpdata1/oradata/oraarp/T_PAY2.dbf'

ERROR at line 1:

ORA-01511: error in renaming log/data files

ORA-01141: error renaming data file 92 - new file

'/arpdata1/oradata/oraarp/T_PAY2.dbf' not found

ORA-01110: data file 92: '/arpdata1/oradata/oraarp/T_PAY1.dbf.dbf'

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

SQL> !

$ cp /arpdata1/oradata/oraarp/T_PAY1.dbf.dbf /arpdata1/oradata/oraarp/T_PAY2.dbf

$ exit

SQL> alter database rename file '/arpdata1/oradata/oraarp/T_PAY1.dbf.dbf' to '/arpdata1/oradata/oraarp/T_PAY2.dbf';

Database altered.

SQL> !

$ cd /arpdata1/oradata/oraarp/

$ ls

T_EG5.dbf T_INSTANCE25.dbf T_INSTANCE30.dbf T_INSTANCE35.dbf T_PAY2.dbf temp05.dbf users10.dbf

T_INSTANCE21.dbf T_INSTANCE26.dbf T_INSTANCE31.dbf T_INSTANCE36.dbf archive users06.dbf users11.dbf

T_INSTANCE22.dbf T_INSTANCE27.dbf T_INSTANCE32.dbf T_INSTANCE37.dbf t_eg3.dbf users07.dbf users12.dbf

T_INSTANCE23.dbf T_INSTANCE28.dbf T_INSTANCE33.dbf T_PAY1.dbf t_eg4.dbf users08.dbf users13.dbf

T_INSTANCE24.dbf T_INSTANCE29.dbf T_INSTANCE34.dbf T_PAY1.dbf.dbf temp04.dbf users09.dbf users14.dbf

$ ll

total 137757712

-rw-r----- 1 oracle dba 1073750016 May 9 19:46 T_EG5.dbf

-rw-r----- 1 oracle dba 15250497536 May 9 19:46 T_INSTANCE21.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:09 T_INSTANCE22.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:44 T_INSTANCE23.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:09 T_INSTANCE24.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:36 T_INSTANCE25.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:09 T_INSTANCE26.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:36 T_INSTANCE27.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:35 T_INSTANCE28.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:27 T_INSTANCE29.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:44 T_INSTANCE30.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:53 T_INSTANCE31.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:51 T_INSTANCE32.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:51 T_INSTANCE33.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:09 T_INSTANCE34.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:09 T_INSTANCE35.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:09 T_INSTANCE36.dbf

-rw-r----- 1 oracle dba 1946165248 May 9 19:09 T_INSTANCE37.dbf

-rw-r----- 1 oracle dba 314580992 May 9 19:09 T_PAY1.dbf

-rw-r----- 1 oracle dba 314580992 May 9 20:25 T_PAY1.dbf.dbf

-rw-r----- 1 oracle dba 314580992 May 9 20:50 T_PAY2.dbf

drwxr-xr-x 2 oracle dba 4096 May 9 20:43 archive

-rw-r----- 1 oracle dba 536879104 May 9 19:09 t_eg3.dbf

-rw-r----- 1 oracle dba 536879104 May 9 19:45 t_eg4.dbf

-rw-r----- 1 oracle dba 2097160192 Jun 6 2007 temp04.dbf

-rw-r----- 1 oracle dba 2097160192 Nov 12 15:07 temp05.dbf

-rw-r----- 1 oracle dba 3101696000 May 9 19:09 users06.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:47 users07.dbf

-rw-r----- 1 oracle dba 2147491840 May 9 19:09 users08.dbf

-rw-r----- 1 oracle dba 1073750016 May 9 19:45 users09.dbf

-rw-r----- 1 oracle dba 1073750016 May 9 19:09 users10.dbf

-rw-r----- 1 oracle dba 1073750016 May 9 19:09 users11.dbf

-rw-r----- 1 oracle dba 1073750016 May 9 19:09 users12.dbf

-rw-r----- 1 oracle dba 1073750016 May 9 19:09 users13.dbf

-rw-r----- 1 oracle dba 1073750016 May 9 19:09 users14.dbf

$ exit

SQL> alter database open;

weixin_39964573

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
oracle脱机状态什么意思,oracle通过归档日志进行脱机恢复

5.7号在给表空间增加数据文件时，没注意系统给文件多加了一个.dbf扩展名,成了.dbf.dbf文件，看着不爽对此文件进行了脱机。又另增加了一个数据文件。当时考虑直接把.dbf.dbf的那个文件给脱机 drop，网上一查9i不能drop,此时发现不能进行联机,此已经是9号，归档日志文件已经rman自动备份后进行了删除，此文即是对此恢复的一个记录。生产系统，做之前一定要做好备份，万事不能心存侥幸。此...
复制链接

扫一扫