Home » RDBMS Server » Backup & Recovery » RMAN backup error
RMAN backup error [message #155598] Tue, 17 January 2006 10:28 Go to next message
frank2lin
Messages: 10
Registered: March 2005
Location: Memphis
Junior Member
Hi, We have Oracle 9i based on Solaris 9. Oracle database uses archive log. I use RMAN to do full backup on disk(online backup), ithat is log as follow:

channel Nightly_Channel: starting piece 1 at 16-JAN-06
channel Nightly_Channel: finished piece 1 at 16-JAN-06
piece handle=/u00/oradata/prod/backup/b_suh915d5_1_1 comment=NONE
channel Nightly_Channel: backup set complete, elapsed time: 01:11:08
channel Nightly_Channel: starting full datafile backupset
channel Nightly_Channel: specifying datafile(s) in backupset
input datafile fno=00024 name=/u02/oradata/prod/pddtalrgi01.dbf
input datafile fno=00023 name=/u00/oradata/prod/pddtalrgt01.dbf
channel Nightly_Channel: starting piece 1 at 16-JAN-06
channel Nightly_Channel: finished piece 1 at 16-JAN-06
piece handle=/u00/oradata/prod/backup/b_svh919ih_1_1 comment=NONE
channel Nightly_Channel: backup set complete, elapsed time: 00:31:16
Finished backup at 16-JAN-06

Starting backup at 16-JAN-06
current log archived
released channel: Nightly_Channel
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/16/2006 21:04:06
RMAN-06059: expected archived log not found, lost of archived log compromises re
coverability
ORA-19625: error identifying file /arch/oradata/prod/archive/1_21094.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

It looks like backup is finished, but I found there is nothing under /u00/oradata/prod/backup/.I don't know what's the problem.
here is script:

run {
allocate channel Nightly_Channel type disk format '/u00/oradata/prod/backup/b_%u_%p_%c';
backup
( database include current controlfile );

backup ( archivelog all delete input );

release channel Nightly_Channel;
}


Report message to a moderator

Re: RMAN backup error [message #155599 is a reply to message #155598] Tue, 17 January 2006 10:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
may be because of inconsistencies.
Try
RMAN> Crosscheck archivelog all;

followed by resync.
Try backup again.
If that fails you may need to forcibily delete the files (Not so ideal solution).

Report message to a moderator

Re: RMAN backup error [message #156634 is a reply to message #155598] Thu, 26 January 2006 10:35 Go to previous message
ujumaka
Messages: 7
Registered: January 2006
Junior Member
In your run command, try using

allocate channel Nightly_Channel type disk format '/u00/oradata/prod/backup/b_%u_%s_%p'

instead of

allocate channel Nightly_Channel type disk format '/u00/oradata/prod/backup/b_%u_%p_%c'


Any change?

Report message to a moderator

Previous Topic: importing data error
Next Topic: Getting error ORA-00376: file 13 cannot be read at this time
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 03:18:11 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.