Home » RDBMS Server » Backup & Recovery » Rman Full backup failign when backing up temp file (AIX OS - )
Rman Full backup failign when backing up temp file [message #490940] Fri, 28 January 2011 04:17 Go to next message
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
Re: Rman Full backup failign when backing up temp file [message #490945 is a reply to message #490940] Fri, 28 January 2011 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
RMAN does not and cannot backup temp files.
Remove it from your list of files to back up.

Regards
Michel
Re: Rman Full backup failign when backing up temp file [message #490951 is a reply to message #490945] Fri, 28 January 2011 04:29 Go to previous messageGo to next message
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
Re: Rman Full backup failign when backing up temp file [message #490953 is a reply to message #490951] Fri, 28 January 2011 04:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Rman Full backup failign when backing up temp file [message #490955 is a reply to message #490953] Fri, 28 January 2011 04:44 Go to previous messageGo to next message
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

Re: Rman Full backup failign when backing up temp file [message #490958 is a reply to message #490955] Fri, 28 January 2011 04:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Rman Full backup failign when backing up temp file [message #490959 is a reply to message #490953] Fri, 28 January 2011 04:59 Go to previous messageGo to next message
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
Re: Rman Full backup failign when backing up temp file [message #490963 is a reply to message #490959] Fri, 28 January 2011 05:05 Go to previous messageGo to next message
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








Re: Rman Full backup failign when backing up temp file [message #490964 is a reply to message #490958] Fri, 28 January 2011 05:11 Go to previous messageGo to next message
Morgs
Messages: 21
Registered: October 2010
Location: South AFrica
Junior Member

Hi

Sorry

Same user was used...

Thanks
Re: Rman Full backup failign when backing up temp file [message #490971 is a reply to message #490958] Fri, 28 January 2011 05:26 Go to previous messageGo to next message
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
Re: Rman Full backup failign when backing up temp file [message #490978 is a reply to message #490971] Fri, 28 January 2011 06:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Rman Full backup failign when backing up temp file [message #490981 is a reply to message #490978] Fri, 28 January 2011 06:22 Go to previous messageGo to next message
Morgs
Messages: 21
Registered: October 2010
Location: South AFrica
Junior Member

Hi

Yes.. Confusing

But thanks for all your help so far
Re: Rman Full backup failign when backing up temp file [message #491034 is a reply to message #490955] Fri, 28 January 2011 09:16 Go to previous messageGo to next message
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
Re: Rman Full backup failign when backing up temp file [message #572783 is a reply to message #490940] Mon, 17 December 2012 10:38 Go to previous message
s5usyp123
Messages: 2
Registered: December 2012
Junior Member
Hi
We are also having the same issue and did any one found any solution.

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


Current Time: Thu Mar 28 16:46:05 CDT 2024