oracle备份日志命令,oracle备份把日志错

最新推荐文章于 2023-04-26 16:17:17 发布

Time-cost李大海

最新推荐文章于 2023-04-26 16:17:17 发布

阅读量99

点赞数

文章标签： oracle备份日志命令

备份日志：

Recovery Manager: Release 10.2.0.4.0 - Production on Thu Jul 30 10:25:07 2009

connected to target database: MES (DBID=1757072954)

using target database control file instead of recovery catalog

RMAN> run

2> {

3> allocate channel t1 type 'sbt_tape' connect * parms

4> 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

6> allocate channel t2 type 'sbt_tape' connect * parms

7> 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

9> backup database;

10> backup archivelog all delete input;

11> release channel t1;

12> release channel t2;

13> }

14>

allocated channel: t1

channel t1: sid=37 instance=mes2 devtype=SBT_TAPE

channel t1: Data Protection for Oracle: version 5.4.1.0

allocated channel: t2

channel t2: sid=92 instance=mes1 devtype=SBT_TAPE

channel t2: Data Protection for Oracle: version 5.4.1.0

Starting backup at 30-JUL-09

channel t1: starting full datafile backupset

channel t1: specifying datafile(s) in backupset

input datafile fno=00006 name=/dev/rmespdb01

input datafile fno=00005 name=/dev/rmes_undo2_2g

input datafile fno=00004 name=/dev/rmes_users_128m

channel t1: starting piece 1 at 30-JUL-09

channel t2: starting full datafile backupset

channel t2: specifying datafile(s) in backupset

input datafile fno=00003 name=/dev/rmes_saux_1g

input datafile fno=00001 name=/dev/rmes_sys_2g

input datafile fno=00002 name=/dev/rmes_undo1_2g

channel t2: starting piece 1 at 30-JUL-09

channel t2: finished piece 1 at 30-JUL-09

piece handle=udkle2na_1_1 tag=TAG20090730T102511 comment=API Version 2.0,MMS Version 5.4.1.0

channel t2: backup set complete, elapsed time: 00:02:05

channel t2: starting full datafile backupset

channel t2: specifying datafile(s) in backupset

including current control file in backupset

channel t2: starting piece 1 at 30-JUL-09

channel t1: finished piece 1 at 30-JUL-09

piece handle=uckle2o8_1_1 tag=TAG20090730T102511 comment=API Version 2.0,MMS Version 5.4.1.0

channel t1: backup set complete, elapsed time: 00:03:42

channel t1: starting full datafile backupset

channel t1: specifying datafile(s) in backupset

including current SPFILE in backupset

channel t1: starting piece 1 at 30-JUL-09

channel t2: finished piece 1 at 30-JUL-09

piece handle=uekle2r8_1_1 tag=TAG20090730T102511 comment=API Version 2.0,MMS Version 5.4.1.0

channel t2: backup set complete, elapsed time: 00:03:01

channel t1: finished piece 1 at 30-JUL-09

piece handle=ufkle2v6_1_1 tag=TAG20090730T102511 comment=API Version 2.0,MMS Version 5.4.1.0

channel t1: backup set complete, elapsed time: 00:02:50

Finished backup at 30-JUL-09

Starting backup at 30-JUL-09

current log archived

released channel: t1

released channel: t2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 07/30/2009 10:31:52

RMAN-06726: could not locate archivelog /arch1/1_407_673494140.dbf

Recovery Manager complete.

是因为没有找到归档日志文件：/arch1/1_407_673494140.dbf

可能被手工删除了

做一下日志校验应该就可以了

处理过程：

su - oracle

$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Thu Jul 30 11:25:37 2009

connected to target database: MES (DBID=1757072954)

RMAN> crosscheck archivelog all;

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=48 instance=mes1 devtype=DISK