OraFAQ Forum: Backup & Recovery » Rman Full backup failign when backing up temp file

Home » RDBMS Server » Backup & Recovery » Rman Full backup failign when backing up temp file (AIX OS - )

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

Rman Full backup failign when backing up temp file [message #490940]

Fri, 28 January 2011 04:17

Morgs
Messages: 21
Registered: October 2010
Location: South AFrica

Junior Member

Hi Guys

I am tryign to run a split onlike full backup from the os useign the sap command which is linked to rman..

Command that i am useing is ...

brbackup -u / -c force -t online_split -m full -p initBR1_onlinefull.sap

The backup goes thru but i get this erro on the end...

BR0522I 57 of 57 files/save sets processed by RMAN

BR0280I BRBACKUP time stamp: 2011-01-26 12.23.26
BR0505I Full database backup (level 0) using RMAN successful

BR0280I BRBACKUP time stamp: 2011-01-26 12.23.28
BR0530I Cataloging backups of all database files to database BR11/PRIMARY...
BR0278E Command output of 'brtools -f printcmd -U /oracle/BR1/sapbackup/..befcdgxn..cmd -C
/oracle/BR1/sapbackup/.befcdgxn.cmd | rsh scrbdefrmr207 /bin/sh -c "'
LANG=C SHELL=/bin/sh /oracle/BR1/102_64/bin/rman nocatalog || echo ERR_RC: \$?'"
:

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Jan 26 12:23:28 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>
connected to target database: BR1 (DBID=2250873886)
using target database control file instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>
29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42
> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of catalog command on default channel at 01/26/2011 12:23:32
ORA-19625: error identifying file /oracle/BR1/sapbackup/befcdgxn.spa/perfman.data1
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

RMAN>

Recovery Manager complete.
ERR_RC: 1
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.32
BR0279E Return code from 'brtools -f printcmd -U /oracle/BR1/sapbackup/..befcdgxn..cmd -C
/oracle/BR1/sapbackup/.befcdgxn.cmd | rsh scrbdefrmr207 /bin/sh -c "'LANG=C SHELL=/bin/sh/oracle/BR1/102_64/bin/rman nocatalog
|| echo ERR_RC: \$?'"' : 0
BR0522E 0 of 57 files/save sets processed by RMAN
BR0536E RMAN call for database instance BR11 failed

BR0280I BRBACKUP time stamp: 2011-01-26 12.23.32

I have check on the system .. There is not file like that but thwre on on the db i,e

eshtsm20:orabr1 88> pwd
/oracle/BR1/sapdata1/perfman_1
eshtsm20:orabr1 89> ls -ltr
total 102408
-rw-r----- 1 orabr1 dba 104865792 Aug 30 09:05 perfman.data1

Report message to a moderator

Re: Rman Full backup failign when backing up temp file [message #490945 is a reply to message #490940]

Fri, 28 January 2011 04:22

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

RMAN does not and cannot backup temp files.
Remove it from your list of files to back up.

Regards
Michel

Report message to a moderator

Re: Rman Full backup failign when backing up temp file [message #490951 is a reply to message #490945]

Fri, 28 January 2011 04:29

Morgs
Messages: 21
Registered: October 2010
Location: South AFrica

Junior Member

Hi Micheal

Please advise How do I remove it, when I cant see it.. I am doign a FULL Backup and its not there ...

Thanks

Report message to a moderator

Re: Rman Full backup failign when backing up temp file [message #490953 is a reply to message #490951]

Fri, 28 January 2011 04:36

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please post the RMAN command that is executed.
What are the steps that are executed by your "brbackup" tool before RMAN?

Regards
Michel

Report message to a moderator

Re: Rman Full backup failign when backing up temp file [message #490955 is a reply to message #490953]

Fri, 28 January 2011 04:44

Morgs
Messages: 21
Registered: October 2010
Location: South AFrica

Junior Member

Hi THanks fro getting so quickly back to me..

I have attached the entire log of the backup..

Hope this helps

THanks again

Attachment: befcdgxn_fnr.txt
(Size: 42.72KB, Downloaded 2320 times)

Report message to a moderator

Re: Rman Full backup failign when backing up temp file [message #490958 is a reply to message #490955]

Fri, 28 January 2011 04:58

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do you execute RMAN session with the same user than the one that started the instance?
Could you post:
ls -l /oracle/BR1/sapbackup/befcdgxn.spa/perfman.data1
ps -eaf | grep BR11

Connect to the database and post:
select status from dba_tablespaces where tablespace_name='PERFMAN';
select file_id, file_name, status from dba_data_files where tablespace_name='PERFMAN';
select file#, status from v$datafile where file# in (<les id de la requête précédente>);

Regards
Michel

Report message to a moderator

Re: Rman Full backup failign when backing up temp file [message #490959 is a reply to message #490953]

Fri, 28 January 2011 04:59

Morgs
Messages: 21
Registered: October 2010
Location: South AFrica

Junior Member

Hi

Just for information . I did the same but just backed up one tablespace.. Differennt command ( instead of a full backUp) and it went thru.. See log attached

brbackup -u / -c force -t online_split -m PSAPBIWUSR -p initBR1_onlinefull.sap

Attachment: befchgvr_pnr.txt
(Size: 29.82KB, Downloaded 2925 times)

Report message to a moderator

Re: Rman Full backup failign when backing up temp file [message #490963 is a reply to message #490959]

Fri, 28 January 2011 05:05

Morgs
Messages: 21
Registered: October 2010
Location: South AFrica

Junior Member

Hi

eshtsm20:orabr1 101> ls -l /oracle/BR1/sapbackup/befcdgxn.spa/perfman.data1
ls: /oracle/BR1/sapbackup/befcdgxn.spa/perfman.data1: No such file or directory
eshtsm20:orabr1 102> ps -eaf | grep BR11
orabr1 300 1 0 09:41 ? 00:00:00 ora_ckpt_BR11
orabr1 302 1 0 09:41 ? 00:00:00 ora_smon_BR11
orabr1 304 1 0 09:41 ? 00:00:00 ora_reco_BR11
orabr1 306 1 0 09:41 ? 00:00:00 ora_cjq0_BR11
orabr1 308 1 0 09:41 ? 00:00:00 ora_mmon_BR11
orabr1 310 1 0 09:41 ? 00:00:00 ora_mmnl_BR11
orabr1 24134 27481 0 11:00 pts/1 00:00:00 grep BR11
orabr1 32756 1 0 09:41 ? 00:00:00 ora_pmon_BR11
orabr1 32758 1 0 09:41 ? 00:00:00 ora_psp0_BR11
orabr1 32760 1 0 09:41 ? 00:00:00 ora_mman_BR11
orabr1 32762 1 0 09:41 ? 00:00:00 ora_dbw0_BR11
orabr1 32764 1 0 09:41 ? 00:00:00 ora_dbw1_BR11
orabr1 32766 1 0 09:41 ? 00:00:00 ora_lgwr_BR11

Db Selects

SQL> select status from dba_tablespaces where tablespace_name='PERFMAN';

STATUS
---------
ONLINE

SQL> select file_id, file_name, status from dba_data_files where tablespace_name='PERFMAN';

FILE_ID
----------
FILE_NAME
--------------------------------------------------------------------------------
STATUS
---------
4
/oracle/BR1/sapdata1/perfman_1/perfman.data1
AVAILABLE

Dont understand teh last Statement

Thanks

Report message to a moderator

Re: Rman Full backup failign when backing up temp file [message #490964 is a reply to message #490958]

Fri, 28 January 2011 05:11

Morgs
Messages: 21
Registered: October 2010
Location: South AFrica

Junior Member

Hi

Sorry

Same user was used...

Thanks

Report message to a moderator

Re: Rman Full backup failign when backing up temp file [message #490971 is a reply to message #490958]

Fri, 28 January 2011 05:26

Morgs
Messages: 21
Registered: October 2010
Location: South AFrica

Junior Member

Hi

Last statement as required

SQL> select FILE#, status from v$datafile where file#=4;

FILE# STATUS
---------- -------
4 ONLINE

Report message to a moderator

Re: Rman Full backup failign when backing up temp file [message #490978 is a reply to message #490971]

Fri, 28 January 2011 06:11

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why RMAN is trying to backup " /oracle/BR1/sapbackup/befcdgxn.spa/perfman.data1" when the actual file is "/oracle/BR1/sapdata1/perfman_1/perfman.data1"?

It seems your tool generates a wrong command but as we have not it we can't say.

Regards
Michel

Report message to a moderator

Re: Rman Full backup failign when backing up temp file [message #490981 is a reply to message #490978]

Fri, 28 January 2011 06:22

Morgs
Messages: 21
Registered: October 2010
Location: South AFrica

Junior Member

Hi

Yes.. Confusing

But thanks for all your help so far

Report message to a moderator

Re: Rman Full backup failign when backing up temp file [message #491034 is a reply to message #490955]

Fri, 28 January 2011 09:16

hkchital
Messages: 128
Registered: September 2008
Location: Singapore

Senior Member

From your log file :

BR0280I BRBACKUP time stamp: 2011-01-26 12.23.14
BR0202I Saving /oracle/BR1/sapdata1/perfman_1/perfman.data1

BR0280I BRBACKUP time stamp: 2011-01-26 12.23.21
BR0521I Backup of database file save set piece - piece handle=BR11_befcdgxn.58_1 tag=BEFCDGXN comment=API Version 2.0,MMS Version 5.5.0.0

#FILE..... /oracle/BR1/sapdata1/perfman_1/perfman.data1
#SAVED.... befcdgxn 57/58

Apparently, BRBackup knew that perfman.data1 was in the perfman_1 directory. It then "SAVED" it to "befcdgxn".
Later, it asked RMAN to catalog the datafile in "befcdgxn" {unfortunately we can't see the actually RMAN commands -- although 57 lines of commands).

Hemant K Chitale

Report message to a moderator

Re: Rman Full backup failign when backing up temp file [message #572783 is a reply to message #490940]

Mon, 17 December 2012 10:38

s5usyp123
Messages: 2
Registered: December 2012

Junior Member

Hi
We are also having the same issue and did any one found any solution.

thanks

Report message to a moderator

Previous Topic:	RMAN backup error
Next Topic:	error ORA-19625: error identifying file while rman backup using sap brbackup tool

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 21:28:29 CST 2024