OraFAQ Forum: Backup & Recovery » Unable to run RMAN script

Home » RDBMS Server » Backup & Recovery » Unable to run RMAN script

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Unable to run RMAN script [message #423197]

Tue, 22 September 2009 11:25

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.

Report message to a moderator

Re: Unable to run RMAN script [message #423198 is a reply to message #423197]

Tue, 22 September 2009 11:36

BlackSwan
Messages: 20109
Registered: January 2009

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.

Report message to a moderator

Re: Unable to run RMAN script [message #423199 is a reply to message #423197]

Tue, 22 September 2009 11:38

Mahesh Rajendran
Messages: 10572
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

And
Try this

RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;

Report message to a moderator

Re: Unable to run RMAN script [message #423203 is a reply to message #423197]

Tue, 22 September 2009 12:19

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??

Report message to a moderator

Re: Unable to run RMAN script [message #423207 is a reply to message #423203]

Tue, 22 September 2009 12:45

Mahesh Rajendran
Messages: 10572
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.

Report message to a moderator

Re: Unable to run RMAN script [message #423312 is a reply to message #423197]

Wed, 23 September 2009 05:47

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.

Report message to a moderator

Previous Topic:	default location for rman log
Next Topic:	backup only arch log

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 21:00:09 CDT 2013

Total time taken to generate the page: 0.07775 seconds