Home   |   Register   |   Today's Posts   |   Rules   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > RMAN backup error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-11-12, 13:56
kroberts kroberts is offline
Registered User
  
Join Date: Dec 2012
Posts: 3
RMAN backup error
When I run my RMAN backup script I get the following error:

RMAN-00571: ================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ================================================== =========
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel dev1
RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "/db01/app/oracle/admin/train/adhoc/TRAIN_DB_05nsjjn2"
ORA-27044: unable to write the header block of file
Linux Error: 22: Invalid argument
Additional information: 2
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

RMAN>
RMAN-08031: released channel: dev1

Recovery Manager complete.

I definitely have enough disk space:
/dev/sdb1 247G 143G 91G 62% /db01

I am mostly curious about the "Linux Error: 22: Invalid argument" line. Has anyone come across this before?

I am a sysadmin trying to troubleshoot this for our DBAs so please forgive me if I left out any pertinent information. Thanks.
-K
Reply With Quote
  #2 (permalink)  
Old 12-11-12, 14:10
anacedent anacedent is offline
Registered User
  
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,095
>Linux Error: 22: Invalid argument
indicates OS error. what clues exist in OS messages file?

post results from OS commands below

ls -l /db01/app/oracle/admin/train/adhoc/TRAIN_DB_05nsjjn2
ls -ld /db01/app/oracle/admin/train/adhoc/
ls -ld /db01/app/oracle/admin/train/
ls -ld /db01/app/oracle/admin/
ls -ld /db01/app/oracle/
ls -ld /db01/app/
ls -ld /db01/
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Reply With Quote
  #3 (permalink)  
Old 12-11-12, 14:13
MCrowley MCrowley is offline
Wage drone 24601
  
Join Date: Jan 2003
Location: Massachusetts
Posts: 5,233
I take it all the "stupid" stuff has been taken care of. The login they are using has rights to create a file in the directory, and the directory exists?

Also, if this is an unusually old version of Oracle, you can check this article:
Electronic Chickens: RMAN-10035: exception raised in RPC
Reply With Quote
  #4 (permalink)  
Old 12-11-12, 14:20
kroberts kroberts is offline
Registered User
  
Join Date: Dec 2012
Posts: 3
I am running the backup script as root to aviod any access issues. The mask for the directory I am using is 755, owned by user oracle and group oinstall. Both the owner user id and group id are local accounts.

here is the output of the OS commands:

[root@rh4ora8 adhoc]# ls -ld /db01/app/oracle/admin/train/adhoc
drwxr-xr-x 2 oracle oinstall 4096 Dec 11 14:12 /db01/app/oracle/admin/train/adhoc
[root@rh4ora8 adhoc]# ls -ld /db01/app/oracle/admin/train/adhoc
drwxr-xr-x 2 oracle oinstall 4096 Dec 11 14:12 /db01/app/oracle/admin/train/adhoc
[root@rh4ora8 adhoc]# ls -ld /db01/app/oracle/admin/train
drwxr-xr-x 10 oracle oinstall 4096 Nov 2 16:53 /db01/app/oracle/admin/train
[root@rh4ora8 adhoc]# ls -ld /db01/app/oracle/admin
drwxrwxr-x 5 oracle oinstall 4096 Nov 21 12:14 /db01/app/oracle/admin
[root@rh4ora8 adhoc]# ls -ld /db01/app/oracle
drwxrwxr-x 9 oracle oinstall 4096 Mar 20 2011 /db01/app/oracle
[root@rh4ora8 adhoc]# ls -ld /db01/app
drwxrwxr-x 3 oracle oinstall 4096 Mar 17 2011 /db01/app
[root@rh4ora8 adhoc]# ls -ld /db01
drwxr-xr-x 6 oracle oinstall 4096 Nov 15 03:22 /db01

Thanks for the quick reply!
-K
Reply With Quote
  #5 (permalink)  
Old 12-11-12, 14:35
anacedent anacedent is offline
Registered User
  
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,095
>I am running the backup script as root to aviod any access issues
NEVER use root to do anything involving Oracle!
Always use OS "oracle" account.

Code:
27044, 00000, "unable to write the header block of file"
// *Cause:  write system call failed, additional information indicates which
//          function encountered the error
// *Action: check errno
OS error. Oracle is the victim; not the culprit.
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Reply With Quote
  #6 (permalink)  
Old 12-11-12, 14:43
kroberts kroberts is offline
Registered User
  
Join Date: Dec 2012
Posts: 3
I normally don't do anything as root unless absolutely neccessary. I'm troubleshooting this issue in a test environment so if I blow something up it's easily re-imaged. I think the RPC error MCrowley pointed out may have been the problem. My latest test backup is still running with no error. It was failing almost immediately before. Thanks.
-K
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.