geodin
asked on
rman script error
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/o rcl/%d_%U. bak';
allocate channel fs2b type disk maxpiecesize 2G format='/u02/rman_backup/o rcl/%d_%U. bak';
allocate channel fs3b type disk maxpiecesize 2G format='/u02/rman_backup/o rcl/%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/O RCL_7jkf1a fu_11_1.ba k 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.
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/o
allocate channel fs2b type disk maxpiecesize 2G format='/u02/rman_backup/o
allocate channel fs3b type disk maxpiecesize 2G format='/u02/rman_backup/o
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/
allocate channel fs2b type disk maxpiecesize 2G format='/mnt/backups/orcl/
allocate channel fs3b type disk maxpiecesize 2G format='/mnt/backups/orcl/
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/O
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
... and if it's CIFS (SMB), there is also a 'hard' mount option.
ASKER
It is smb, mounted using:
mount -t smb //<server ip>/backups$ /mnt/backups -o username=<username>/<domai n>,passwor d=<passwor d>,fmask=6 66,dmask=7 77
Should this be changed too:
mount -t smb //<server ip>/backups$ /mnt/backups -o username=<username>/<domai n>,passwor d=<passwor d>,fmask=6 66,dmask=7 77,hard
mount -t smb //<server ip>/backups$ /mnt/backups -o username=<username>/<domai
Should this be changed too:
mount -t smb //<server ip>/backups$ /mnt/backups -o username=<username>/<domai
Yes, at least it's worth a try! And, can't you use -t cifs ? - t smb is obsolete, afaik.
ASKER
Thank you!
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