- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - Linux
- >
- Re: Oracle backup failing
Operating System - Linux
1753333
Members
5538
Online
108792
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-03-2009 08:41 AM
тАО08-03-2009 08:41 AM
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?
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 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-03-2009 11:59 PM
тАО08-03-2009 11:59 PM
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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-04-2009 05:37 AM
тАО08-04-2009 05:37 AM
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.
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?
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP