Home » RDBMS Server » Backup & Recovery » backup failing giving error, ORA-19502, ORA-27063, Outer dbms_backup_restore.restoreCancel() (oracle 9i db, oracle 10g catalog, netbackup.)
backup failing giving error, ORA-19502, ORA-27063, Outer dbms_backup_restore.restoreCancel() [message #312814] Wed, 09 April 2008 18:06 Go to next message
geeklol
Messages: 59
Registered: March 2005
Member
i am trying to backup a 9i database (sun solaris), using a 10g catalog (linux redhat 5.0) and netbackup.

I have the db up in nomount mode.
i have all the directory structures that it is looking for in place with the right permissions.
The backup kicks off correctly and starts restoring the datafiles, but half way into the restore it dies giving the following error.
ORA-19502: write error on file "/db02/oradata/kbankprd/data/lrndb_dta_tbs01_01.dbf", blockno 58977 (blocksize=8192)
ORA-27063: number of bytes read/written is incorrect
Additional information: 114688
Additional information: 131072
Outer dbms_backup_restore.restoreCancel() failed
failover to previous backup

Any ideas?

RMAN> run {
2> allocate channel K00B type 'sbt_tape';
3> SEND 'NB_ORA_SERV=laxas4bkp01';
4> SEND 'NB_ORA_CLIENT=laxs90ldb01';
restore database;
5> 6> }

allocated channel: K00B
channel K00B: sid=486 devtype=SBT_TAPE
channel K00B: VERITAS NetBackup for Oracle - Release 5.1 (2004082014)

sent command to channel: K00B

sent command to channel: K00B

Starting restore at 04-09-2008 03:31:30

channel K00B: starting datafile backupset restore
channel K00B: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /db02/oradata/kbankprd/data/system01.dbf
restoring datafile 00002 to /db02/oradata/kbankprd/data/undotbs01.dbf
restoring datafile 00003 to /db02/oradata/kbankprd/data/lrndb_clb_ndx_tbs01_01.dbf
restoring datafile 00004 to /db02/oradata/kbankprd/data/lrndb_clb_tbs01_01.dbf
restoring datafile 00005 to /db02/oradata/kbankprd/data/lrndb_dta_tbs01_01.dbf
restoring datafile 00006 to /db02/oradata/kbankprd/data/lrndb_ndx_tbs01_01.dbf
restoring datafile 00007 to /db02/oradata/kbankprd/data/lrndb_vol_tbs01_01.dbf
restoring datafile 00008 to /db02/oradata/kbankprd/data/tools_01_01.dbf
restoring datafile 00009 to /db02/oradata/kbankprd/data/users_01_01.dbf
restoring datafile 00010 to /db01/oradata/kbankprd/data/tools_01_02.dbf
channel K00B: reading from backup piece bk_709_1_651593094
i ORA-19870: error reading backup piece bk_709_1_651593094
ORA-19502: write error on file "/db02/oradata/kbankprd/data/lrndb_dta_tbs01_01.dbf", blockno 58977 (blocksize=8192)
ORA-27063: number of bytes read/written is incorrect
Additional information: 114688
Additional information: 131072
Outer dbms_backup_restore.restoreCancel() failed
failover to previous backup

released channel: K00B
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/09/2008 15:40:25
ORA-19590: conversation already active

Thank you!
Re: backup failing giving error, ORA-19502, ORA-27063, Outer dbms_backup_restore.restoreCancel() [message #312815 is a reply to message #312814] Wed, 09 April 2008 18:14 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>ORA-19502: write error on file "/db02/oradata/kbankprd/data/lrndb_dta_tbs01_01.dbf", blockno 58977 (blocksize=8192)
>ORA-27063: number of bytes read/written is incorrect

did the disk fill up 100% FULL?
Re: backup failing giving error, ORA-19502, ORA-27063, Outer dbms_backup_restore.restoreCancel() [message #312816 is a reply to message #312814] Wed, 09 April 2008 18:16 Go to previous message
geeklol
Messages: 59
Registered: March 2005
Member
No. there is plenty of space -- more than 50% -- on all the disks.
Previous Topic: Snapshot Controlfile Configuration
Next Topic: One backup command but RMAN does backup twice?
Goto Forum:
  


Current Time: Fri Dec 09 04:10:47 CST 2016

Total time taken to generate the page: 0.12145 seconds