| backup failing giving error, ORA-19502, ORA-27063, Outer dbms_backup_restore.restoreCancel() [message #312814] |
Wed, 09 April 2008 18:06  |
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!
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
