Solved

rman script error

Posted on 2009-05-14
6
1,962 Views
Last Modified: 2013-12-18
Need help understanding what this error is telling me and what to do to fix it.

Situation is that I had to change the backups script for rman to point to a new file share on a Windows box, database is on a linux box.

All I did was mount the share and change the rman script FROM:

allocate channel for maintenance type disk;
crosscheck backupset;
crosscheck archivelog all;
delete noprompt obsolete;
run
{
  allocate channel fs1b type disk maxpiecesize 2G format='/u02/rman_backup/orcl/%d_%U.bak';
  allocate channel fs2b type disk maxpiecesize 2G format='/u02/rman_backup/orcl/%d_%U.bak';
  allocate channel fs3b type disk maxpiecesize 2G format='/u02/rman_backup/orcl/%d_%U.bak';
  BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG DELETE INPUT;
  release channel fs1b;
  release channel fs2b;
  release channel fs3b;
}

--------TO---------

allocate channel for maintenance type disk;
crosscheck backupset;
crosscheck archivelog all;
delete noprompt obsolete;
run
{
  allocate channel fs1b type disk maxpiecesize 2G format='/mnt/backups/orcl/%d_%U.bak';
  allocate channel fs2b type disk maxpiecesize 2G format='/mnt/backups/orcl/%d_%U.bak';
  allocate channel fs3b type disk maxpiecesize 2G format='/mnt/backups/orcl/%d_%U.bak';
  BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG DELETE INPUT;
  release channel fs1b;
  release channel fs2b;
  release channel fs3b;
}


The backup sets seem to be on the new mount so I think the backup was good but not sure as getting the below at the end of my rman log.

piece handle=/mnt/backups/orcl/ORCL_7jkf1afu_11_1.bak comment=NONE
channel fs3b: backup set complete, elapsed time: 02:17:15
released channel: fs1b
released channel: fs2b
released channel: fs3b
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 05/14/2009 20:57:13

RMAN-03009: failure of backup command on fs1b channel at 05/14/2009 19:21:14
ORA-27052: unable to flush file data
Linux Error: 5: Input/output error
Additional information: 1

RMAN>

Recovery Manager complete.
0
Comment
Question by:geodin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 24393012
Hi,
the error means that the fsync() function is failing.
This can occur with NFS when the remote connection times out. Although a timeout should give error 78 rather than error 5, you should try to mount the NFS share with the 'hard' option (instead of 'soft') and see if it helps.
What does the NFS server say? Any messages in the log?
wmp
 
 
0
 
LVL 68

Accepted Solution

by:
woolmilkporc earned 500 total points
ID: 24393109
These are the mount options Oracle recommends -
rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,noac
 Here is an Oracle document -
http://download-east.oracle.com/docs/cd/B19306_01/install.102/b15690/app_nas.htm#CHDIAGAD
It deals mainly with NAS, but the recommended options should apply to any NFS share.
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 24394581
... and if it's CIFS (SMB), there is also a 'hard' mount option.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:geodin
ID: 24398656
It is smb, mounted using:

mount -t smb //<server ip>/backups$ /mnt/backups -o username=<username>/<domain>,password=<password>,fmask=666,dmask=777

Should this be changed too:

mount -t smb //<server ip>/backups$ /mnt/backups -o username=<username>/<domain>,password=<password>,fmask=666,dmask=777,hard
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 24398706
Yes, at least it's worth a try! And, can't you use -t cifs ? - t smb is obsolete, afaik.
0
 

Author Closing Comment

by:geodin
ID: 31581775
Thank you!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Windows 10 Creator Update has just been released and I have it working very well on my laptop. Read below for issues, fixes and ideas.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Suggested Courses

631 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question