cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle backup failing

Waqar Razi
Regular Advisor

Oracle backup failing

I have just observed that one of the database backups are failing. Here is the error log:
Begin tape backup to device /dev/nst0 on Mon Aug 3 02:09:28 EDT 2009

################################################################################
#
Entering: check_parameters
WARNING - The directory /ora_backup/prev_0/mmtest/export has nothing in it
The tape_copy will continue.
################################################################################
#
Entering: notify
Exiting: notify
################################################################################
#
WARNING - The directory /ora_backup/prev_0/mmtrain/export has nothing in it
The tape_copy will continue.
################################################################################
#
Entering: notify
Exiting: notify
################################################################################
#
Exiting: check_parameters (0)
################################################################################
#
Entering: check_device_norewind
Exiting: check_device_norewind (0)
################################################################################
#
Entering: tape_rewind
Exiting: tape_rewind (0)
################################################################################
#
Entering: build_header

Large files to be backed up in their own archive in /ora_backup/prev_0/mmlive/db
f are:
ARC# 2 MMLIVE_5355_1_693885622_2009_08_03_02:00_Mon_full
ARC# 3 MMLIVE_5356_1_693885631_2009_08_03_02:00_Mon_full
ARC# 4 MMLIVE_5357_1_693885901_2009_08_03_02:00_Mon_full
--------------------------------------------------------------------------------
-
The directory /ora_backup/prev_0/mmlive/archive and its subdirectories will be b
acked up to one archive.
The files are:
ARC# 5 /ora_backup/prev_0/mmlive/archive:
total 4
-rw-r--r-- 1 oracle dba 12 Aug 3 02:00 dbid.txt
--------------------------------------------------------------------------------
-
The directory /ora_backup/prev_0/mmlive/control and its subdirectories will be b
acked up to one archive.
The files are:
ARC# 6 /ora_backup/prev_0/mmlive/control:
total 13256
-rw-r----- 1 oracle dba 6733824 Aug 3 02:05 control01.ctl
-rw-r----- 1 oracle dba 6815744 Aug 3 02:05 MMLIVE_controlfile_autobackup_c-42
10759160-20090803-00
--------------------------------------------------------------------------------
-
The directory /ora_backup/prev_0/mmlive/log and its subdirectories will be backe
d up to one archive.
The files are:
ARC# 7 /ora_backup/prev_0/mmlive/log:
total 20
-rw-r--r-- 1 oracle dba 1377 Aug 3 02:00 mmlive.filenames
-rw-r--r-- 1 oracle dba 2778 Aug 3 02:00 initmmlive.ora
-rwxr-xr-x 1 oracle dba 5606 Aug 3 02:05 restore_db
-rw-r--r-- 1 oracle dba 216 Aug 3 02:05 rebuild_temp.sql
--------------------------------------------------------------------------------
-
Large files to be backed up in their own archive in /ora_backup/prev_0/mmhist/db
f are:
ARC# 8 MMHIST_4944_1_693885927_2009_08_03_02:05_Mon_full
ARC# 9 MMHIST_4945_1_693885932_2009_08_03_02:05_Mon_full
ARC# 10 MMHIST_4946_1_693886162_2009_08_03_02:05_Mon_full
--------------------------------------------------------------------------------
-
The directory /ora_backup/prev_0/mmhist/archive and its subdirectories will be b
acked up to one archive.
The files are:
ARC# 11 /ora_backup/prev_0/mmhist/archive:
total 4
-rw-r--r-- 1 oracle dba 12 Aug 3 02:05 dbid.txt
--------------------------------------------------------------------------------
-
The directory /ora_backup/prev_0/mmhist/control and its subdirectories will be b
acked up to one archive.
The files are:
ARC# 12 /ora_backup/prev_0/mmhist/control:
total 18064
-rw-r----- 1 oracle dba 9191424 Aug 3 02:09 control01.ctl
-rw-r----- 1 oracle dba 9273344 Aug 3 02:09 MMHIST_controlfile_autobackup_c-16
12287216-20090803-00
--------------------------------------------------------------------------------
-
The directory /ora_backup/prev_0/mmhist/log and its subdirectories will be backe
d up to one archive.
The files are:
ARC# 13 /ora_backup/prev_0/mmhist/log:
total 20
-rw-r--r-- 1 oracle dba 1701 Aug 3 02:05 mmhist.filenames
-rw-r--r-- 1 oracle dba 2764 Aug 3 02:05 initmmhist.ora
-rwxr-xr-x 1 oracle dba 5606 Aug 3 02:09 restore_db
-rw-r--r-- 1 oracle dba 216 Aug 3 02:09 rebuild_temp.sql
--------------------------------------------------------------------------------
-
The directory /ora_backup/prev_0/mmtest/export and its subdirectories will be ba
cked up to one archive.
The files are:
ARC# 14 /ora_backup/prev_0/mmtest/export:
total 0
--------------------------------------------------------------------------------
-
The directory /ora_backup/prev_0/mmtrain/export and its subdirectories will be b
acked up to one archive.
The files are:
ARC# 15 /ora_backup/prev_0/mmtrain/export:
total 0
--------------------------------------------------------------------------------
-
Exiting: build_header
################################################################################
#
Entering: tape_write_to
Begin tape copy of Tape header file 02:09:30
ARC# 1 Tape header file
The tape copy of Tape header file 02:09:32 was SUCCESSFUL
----------------------------------------------------------------------------
Begin tape copy of /ora_backup/prev_0/mmlive/dbf 02:09:32

Begin tape copy of ARC# 2 MMLIVE_5355_1_693885622_2009_08_03_02:00_Mon_full 02:0
9:32
The tape copy of MMLIVE_5355_1_693885622_2009_08_03_02:00_Mon_full 02:09:38 wa
s SUCCESSFUL
--
Begin tape copy of ARC# 3 MMLIVE_5356_1_693885631_2009_08_03_02:00_Mon_full 02:0
9:38
The tape copy of MMLIVE_5356_1_693885631_2009_08_03_02:00_Mon_full 02:11:05 wa
s SUCCESSFUL
--
Begin tape copy of ARC# 4 MMLIVE_5357_1_693885901_2009_08_03_02:00_Mon_full 02:1
1:05
The tape copy of MMLIVE_5357_1_693885901_2009_08_03_02:00_Mon_full 02:11:07 wa
s SUCCESSFUL
--

The tape copy of /ora_backup/prev_0/mmlive/dbf 02:11:07 was SUCCESSFUL
----------------------------------------------------------------------------
Begin tape copy of ARC# 5 /ora_backup/prev_0/mmlive/archive 02:11:07
The tape copy of /ora_backup/prev_0/mmlive/archive 02:11:09 was SUCCESSFUL
----------------------------------------------------------------------------
Begin tape copy of ARC# 6 /ora_backup/prev_0/mmlive/control 02:11:09
The tape copy of /ora_backup/prev_0/mmlive/control 02:11:11 was SUCCESSFUL
----------------------------------------------------------------------------
Begin tape copy of ARC# 7 /ora_backup/prev_0/mmlive/log 02:11:11
The tape copy of /ora_backup/prev_0/mmlive/log 02:11:13 was SUCCESSFUL
----------------------------------------------------------------------------
Begin tape copy of /ora_backup/prev_0/mmhist/dbf 02:11:13

Begin tape copy of ARC# 8 MMHIST_4944_1_693885927_2009_08_03_02:05_Mon_full 02:1
1:13
The tape copy of MMHIST_4944_1_693885927_2009_08_03_02:05_Mon_full 02:11:15 wa
s SUCCESSFUL
--
Begin tape copy of ARC# 9 MMHIST_4945_1_693885932_2009_08_03_02:05_Mon_full 02:1
1:15
The tape copy of MMHIST_4945_1_693885932_2009_08_03_02:05_Mon_full 02:12:15 wa
s SUCCESSFUL
--
Begin tape copy of ARC# 10 MMHIST_4946_1_693886162_2009_08_03_02:05_Mon_full 02:
12:15
The tape copy of MMHIST_4946_1_693886162_2009_08_03_02:05_Mon_full 02:12:16 wa
s SUCCESSFUL
--

The tape copy of /ora_backup/prev_0/mmhist/dbf 02:12:16 was SUCCESSFUL
----------------------------------------------------------------------------
Begin tape copy of ARC# 11 /ora_backup/prev_0/mmhist/archive 02:12:16
The tape copy of /ora_backup/prev_0/mmhist/archive 02:12:18 was SUCCESSFUL
----------------------------------------------------------------------------
Begin tape copy of ARC# 12 /ora_backup/prev_0/mmhist/control 02:12:18
The tape copy of /ora_backup/prev_0/mmhist/control 02:12:21 was SUCCESSFUL
----------------------------------------------------------------------------
Begin tape copy of ARC# 13 /ora_backup/prev_0/mmhist/log 02:12:21
The tape copy of /ora_backup/prev_0/mmhist/log 02:12:22 was SUCCESSFUL
----------------------------------------------------------------------------
Begin tape copy of ARC# 14 /ora_backup/prev_0/mmtest/export 02:12:22
tar: *: Cannot stat: No such file or directory
tar: Error exit delayed from previous errors
FATAL - The tape copy of /ora_backup/prev_0/mmtest/export 02:12:24 FAILED
----------------------------------------------------------------------------
Please review the /home/oracle/log/backup_2_tape_08_03_09_02:09.log.
Since there is a tape write failure, please replace the tape.
Exiting: main routine
The backup to tape job FAILED
End tape backup to device /dev/nst0 on Mon Aug 3 02:12:24 EDT 2009
********************************************************************************
*
################################################################################
#
Entering: tape_offline
Exiting: tape_offline(0)
################################################################################
#
Entering: notify
Exiting: notify
################################################################################
#


Can some one please give me some clue?
2 REPLIES
avizen9
Esteemed Contributor

Re: Oracle backup failing

Have you verify your tape? its in working condition?
try with another new fresh tape to take backup

also compare tape capacity and your backup size.

if you dont have new fresh tape try to verify this existing tape with dd command, hope this will help

Ivan Ferreira
Honored Contributor

Re: Oracle backup failing

Error:

Begin tape copy of ARC# 14 /ora_backup/prev_0/mmtest/export 02:12:22
tar: *: Cannot stat: No such file or directory
tar: Error exit delayed from previous errors
FATAL - The tape copy of /ora_backup/prev_0/mmtest/export 02:12:24 FAILED


Possible cause:

WARNING - The directory /ora_backup/prev_0/mmtest/export has nothing in it

I don't know what backup software is this and you should review all messages and try to identify the reason of that on your server.
Por que hacerlo dificil si es posible hacerlo facil? - Why do it the hard way, when you can do it the easy way?