Home » RDBMS Server » Backup & Recovery » Unable to run RMAN script
Unable to run RMAN script [message #423197] Tue, 22 September 2009 11:25 Go to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Hi,

I am running my rman backup script as:

run{
ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '/u01/rman/%p_%d_%u_%n' maxpiecesize 5G;
ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '/u01/rman/%p_%d_%u_%n'maxpiecesize 5G;
backup database filesperset 5;
backup archivelog all filesperset 5;
release channel d1;
release channel d2;
}

But after taking bacup of all datafiles in a backupset, I am getting error as:

current log archived
released channel: d1
released channel: d2
RMAN-00571:=====================================================
RMAN-00569:============ ERROR MESSAGE STACK FOLLOWS ===========
MAN-00571: ======================================================
RMAN-03002: failure of backup command at 09/22/2009 21:31:37
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u02/logs/prod/arch/1_240_677933723.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3



Kindly let me know if there is any modification is required.

Re: Unable to run RMAN script [message #423198 is a reply to message #423197] Tue, 22 September 2009 11:36 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>ORA-19625: error identifying file /u02/logs/prod/arch/1_240_677933723.dbf
Does this file exist?
Most likely it does not.
Why not?

Post Operating System (OS) name & version for DB server system.
Post results of SELECT * from v$version.
Re: Unable to run RMAN script [message #423199 is a reply to message #423197] Tue, 22 September 2009 11:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And
Try this
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
Re: Unable to run RMAN script [message #423203 is a reply to message #423197] Tue, 22 September 2009 12:19 Go to previous messageGo to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Thanks it works
I have to update catalog about it.

But still one question , why RMAN is taking so much of arch??

Re: Unable to run RMAN script [message #423207 is a reply to message #423203] Tue, 22 September 2009 12:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>why RMAN is taking so much of arch?
Please rephrase.
Are you asking why rman is generating so much of archives?
If so, it is the database that is generating it. RMAN is just backing it.
Re: Unable to run RMAN script [message #423312 is a reply to message #423197] Wed, 23 September 2009 05:47 Go to previous message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Thanks,

I got my answer.

After registering target database with the catalog, i havent updated the catalog about the status of the archives.

That's why it was taking arch from the time it was registered with the catalog and while taking backup it showed error.
ORA-19625: error identifying file /u02/logs/prod/arch/1_240_677933723.dbf
which is the arch of the registration of the target with the catalog.

Thanks once again.
Previous Topic: default location for rman log
Next Topic: backup only arch log
Goto Forum:
  


Current Time: Thu Mar 28 13:19:51 CDT 2024