Home » RDBMS Server » Backup & Recovery » backup archivelog issue (10.2.0.1)
backup archivelog issue [message #543041] Sun, 12 February 2012 20:31 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
I want to backup all archive logs,but it raise error,why?

run{
allocate channel dup type disk;
sql 'alter system archive log current';
backup format '/u01/app/oracle/duplicate/al_t%t_s%s_p%p' archivelog all;
release channel dup;
}


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/13/2012 05:04:04
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/app/oracle/duplicate/1_33_769179320.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Re: backup archivelog issue [message #543042 is a reply to message #543041] Sun, 12 February 2012 20:33 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ls -l /u01/app/oracle/duplicate/1_33_769179320.dbf
ls -ld /u01/app/oracle/duplicate/
ls -ld /u01/app/oracle/
ls -ld /u01/app/
ls -ld /u01/

post results from OS commands above
Re: backup archivelog issue [message #543051 is a reply to message #543042] Mon, 13 February 2012 00:09 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks BlaskSwan,
I deleted some archive log using os command rm before, so the 1_33_769179320.dbf
does not exists.
Re: backup archivelog issue [message #543054 is a reply to message #543051] Mon, 13 February 2012 00:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
andy huang wrote on Sun, 12 February 2012 22:09
Thanks BlaskSwan,
I deleted some archive log using os command rm before, so the 1_33_769179320.dbf
does not exists.


so why do you bother us with self inflicted problems?

Re: backup archivelog issue [message #543060 is a reply to message #543054] Mon, 13 February 2012 01:08 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
My problem is how to execute the flowing command successfully,because some archive logs do not exists.
Re: backup archivelog issue [message #543118 is a reply to message #543060] Mon, 13 February 2012 02:59 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Go to the RMAN docs, and read up on CROSSCHECK and EXPIRED.
Re: backup archivelog issue [message #543146 is a reply to message #543118] Mon, 13 February 2012 03:37 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
I delete the archive logs which do not exists in rman command,and the backup command can execute successfully.
rman> delete archivelog until sequence 38;
Previous Topic: Backup & Restore Oracle DB
Next Topic: Restore rman backup on new server as different name sid/service/listener etc
Goto Forum:
  


Current Time: Thu Mar 28 06:18:28 CDT 2024