Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Oracle / Oracle Server / January 2006

Tip: Looking for answers? Try searching our database.

RMAN backup failure on a 700 GB database.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
vasant.naidu@gmail.com - 26 Jan 2006 10:22 GMT
Hi,

Let me start with the details:

Database: Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit
Production
OS: SunOS P0021ADCDA 5.8 Generic_117350-20 sun4u sparc SUNW,Sun-Fire
Backup System: NetBackup-Solaris2.6 4.5GA

Ours is a 700 GB database which runs a critical application concerned
with telecom systems. We take RMAN Hotbackup everyday.

Giving you a format of our script:
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';
BACKUP
   $BACKUP_TYPE
   SKIP INACCESSIBLE
   TAG hot_db_bk_level0
   FILESPERSET 5
   # recommended format
   FORMAT 'bk_%s_%p_%t'
   DATABASE;
   sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
}

The database is run during night when the load is low. But since the
size has grown to this much big propotion it fails everyday with the
following error:

File Name: -rw-rw-rw-   1 root     root       15911 Jan 26 14:34
hot_database_SV_VBPDF_backup.sh.Jan26_0012.out

End contents:

RMAN-08522: input datafile fno=00080
name=/u175/oradata/SVM_VBPDF/data/VBPDF_data_74.dbf
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
ch02
RMAN-10035: exception raised in RPC: ORA-19502: write error on file
"bk_20461_1_580742991", blockno 21016449 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: sbtwrite2: sbtwrite2() failed.
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

Let me also tell that sometimes this backup happens successfully, like
the below fired on 24th Jan.
-rw-rw-rw-   1 root     root       27905 Jan 24 23:57
hot_database_SV_VBPDF_backup.sh.Jan24_0430.out

So what might be the problem:

1. Is it due to the database size
2. Is it due to the fact that our backup system cannot handle this big
a database, during peak loads (most of the backup happens during night)

Can anybody clear me on this?

Thanks.

Regards,
Vasant Naidu
Jerome Vitalis - 26 Jan 2006 13:14 GMT
On Thu, 26 Jan 2006 02:22:08 -0800, vasant.naidu wrote:

> Hi,
>
[quoted text clipped - 69 lines]
> Regards,
> Vasant Naidu

Which media manager do you use?
You have to ask your system team to check the backup server logs to track
the problem down.
This error can be caused by a thousand different
problems. For example, a communication timeout during the transfert of one
backup piece. Your sysadmins have to tune such timeout threshold
parameters.

Cheers,
Jerome
sybrandb@yahoo.com - 26 Jan 2006 13:29 GMT
As the error evidently occurs on the tapedrive/in netbackup, you need
to check problems on your tapedrive.
At this point you are just jumping to conclusions, you can't
substantiate.
The tape may be full and if you don't have an autochanger attached to
the drive, no new tape will be inserted,unless someone does it
manually.

So nobody can clear you on this as you provide way insufficient
information.
The probability you are just appending to the same tape over and over
again, until it is full, increases by your assertion the backup
sometimes happen successfully.

Signature

Sybrand Bakker
Senior Oracle DBA

Mladen Gogala - 27 Jan 2006 07:05 GMT
On Thu, 26 Jan 2006 02:22:08 -0800, vasant.naidu wrote:

> RMAN-10035: exception raised in RPC: ORA-19502: write error on file
> "bk_20461_1_580742991", blockno 21016449 (blocksize=512)
[quoted text clipped - 15 lines]
>
> Can anybody clear me on this?

Here are some probable causes:
clock speed
solar flares
electromagnetic radiation from satellite debris
static from nylon underwear
static from plastic slide rules
global warming
poor power conditioning
static buildup
doppler effect
hardware stress fractures
magnetic interference from money/credit cards
dry joints on cable plug
we're waiting for [the phone company] to fix that line
sounds like a Windows problem, try calling Microsoft support
temporary routing anomaly
somebody was calculating pi on the server
fat electrons in the lines
excess surge protection
floating point processor overflow
divide-by-zero error
POSIX compliance problem
monitor resolution too high
improperly oriented keyboard
network packets travelling uphill (use a carrier pigeon)
Decreasing electron flux
first Saturday after first full moon in Winter
radiosity depletion
CPU radiator broken
It works the way the Wang did, what's the problem
positron router malfunction
cellular telephone interference
techtonic stress
piezo-electric interference
(l)user error
working as designed
dynamic software linking table corrupted
heavy gravity fluctuation, move computer to floor rapidly
secretary plugged hairdryer into UPS
terrorist activities
not enough memory, go get system upgrade
interrupt configuration error
spaghetti cable cause packet failure
boss forgot system password
bank holiday - system operating credits  not recharged
virus attack, luser responsible
waste water tank overflowed onto computer
Complete Transient Lockout
bad ether in the cables
Bogon emissions
Change in Earth's rotational speed
Cosmic ray particles crashed through the hard disk platter
Smell from unhygienic janitorial staff wrecked the tape heads
Little hamster in running wheel had coronary; waiting for replacement to be Fedexed from Wyoming
Evil dogs hypnotised the night shift
Plumber mistook routing panel for decorative wall fixture
Electricians made popcorn in the power supply
Groundskeepers stole the root password
high pressure system failure
failed trials, system needs redesigned
system has been recalled
not approved by the FCC
need to wrap system in aluminum foil to fix problem
not properly grounded, please bury computer
CPU needs recalibration
system needs to be rebooted
bit bucket overflow
descramble code needed from software company
only available on a need to know basis
knot in cables caused data stream to become twisted and kinked
nesting roaches shorted out the ether cable
The file system is full of it
Satan did it
Daemons did it
You're out of memory
There isn't any problem
Unoptimized hard drive
Typo in the code
Yes, yes, its called a design limitation
Look, buddy:  Windows 3.1 IS A General Protection Fault.
That's a great computer you have there; have you considered how it would work as a BSD machine?
Please excuse me, I have to circuit an AC line through my head to get this database working.
Yeah, yo mama dresses you funny and you need a mouse to delete files.
Support staff hung over, send aspirin and come back LATER.

Signature

http://www.mgogala.com

Robert Klemme - 30 Jan 2006 15:21 GMT
> On Thu, 26 Jan 2006 02:22:08 -0800, vasant.naidu wrote:
>
[quoted text clipped - 104 lines]
> dresses you funny and you need a mouse to delete files.
> Support staff hung over, send aspirin and come back LATER.

Wow!  Is this list copyrighted or can I reuse it for my own purposes?

   robert
Joel Garry - 30 Jan 2006 22:02 GMT
>Wow!  Is this list copyrighted or can I reuse it for my own purposes?

Google for "BOFH excuses".

jg
--
@home.com is bogus.
http://www.cs.wisc.edu/~ballard/bofh/bofhserver.pl
Mladen Gogala - 31 Jan 2006 00:12 GMT
> Wow!  Is this list copyrighted or can I reuse it for my own purposes?
>
>     robert

The whole list is here:

http://www.cs.wisc.edu/~ballard/bofh/excuses

Signature

http://www.mgogala.com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.