08-12-2010
Oracle backup failures after SAN change.
Hi,
We are moving the RMAN oracle backup to tape on daily basis.After they went for SAN change in the solaris server , we started receiveing ora-600 errors and backup is getting fails.
I am from Oracle DBA team.I need to know whether any command for check SAN change or root cause for this issue.
Your suggestion will help me to communciate with Solaris Team.
Thanks in advance.
Regards,
Rocky.
---------- Post updated at 04:46 PM ---------- Previous update was at 03:32 PM ----------
I could see the different between two below output which taken from different server respectively using mount command(difference has marked in RED) .Both the server are running in the solaris. After SAN change , i could find this difference. Could you please explain what is qio and will it cause for Oracle backup failure?
Please suggest me on this.
Test server 1:
/dev/vx/dsk/dg/dgftdb01 on /appl/testdb/db01 type vxfs read/write/setuid/mincache=direct/convosync=direct/delaylog/largefiles/ioerror
=mwdisable/dev=13df01b on Sat Aug 7 21:57:01 2010
Test server 2:
/dev/vx/dsk/tdg/4db01 on /appl/testdb/db01 type vxfs read/write/setuid/mincache=direct/convosync=direct/delaylog/largefiles/
qio/ioerror=mwdisable/dev=43c9091 on Sat Aug 7 22:27:41 201
10 More Discussions You Might Find Interesting
1. Solaris
Hi:
I am in the process of configuring the SAN for Solaris to host 6 oracle 9i databases. We have 30 -146 GB disks stiped with RAID 10 for SAN. Of which 11 are dedicated for databsaes related things. Then we have 2 v880 Sun Servers with 16 -73 GB disks and 24 GB memory.
The questions... (1 Reply)
Discussion started by: oracle_dba
1 Replies
2. Shell Programming and Scripting
I have written a script to perfrom a cold backup on an oracle database. The script is failing everytime. Can anyone tell me what (stupid) error I am making.
The output from the uname command follows
Linux rayora 2.2.14-6.1.1smp #1 SMP Thu Apr 13 19:55:55 EDT 2000 i686 unknown
The error... (8 Replies)
Discussion started by: beilstwh
8 Replies
3. Shell Programming and Scripting
I have a script like this ..
#!/bin/ksh
database=$(echo $@ | sed 's/.*-S \(*\).*/\1/')
instance=$(grep "$database" /var/opt/oracle/oratab | awk -F : '{print $1}')
command=$(echo $@ | sed 's/"$database"/"$instance"/')
echo $command
when I tried to execute the script like this ...
ksh... (5 Replies)
Discussion started by: talashil
5 Replies
4. Solaris
Dear All,
Can anyone tell what is SAN and LAN backup and what
is the diference between them? (2 Replies)
Discussion started by: masthan25
2 Replies
5. UNIX for Advanced & Expert Users
I have some T3's we just purchased and we are looking to carve these up into LDOMS's.
Just wondering if anyone can give me a quick run down or pro / cons on SAN vs local internal for the LDOM itself. These will external SAN storage for their applications. (0 Replies)
Discussion started by: jlouki01
0 Replies
6. HP-UX
We have omni backup of oracle database about 40Gb, tablespaces are distributed over 2 partitions . But because of some reason both partition are not available more .
Now we are in need to restore the entire data on new partitions .Can any guru's confirm if tried so earlier will this going to... (1 Reply)
Discussion started by: Shirishlnx
1 Replies
7. Emergency UNIX and Linux Support
Setup:
Multiple Virtual Machines running OEL5 / Oracle RDBMS 11.2
OVM 2 / Xen 3.4.0 Cluster consisting of 3 Machines
Shared SAN Storage synced with OCFS2
SAN connected with 4GB FC on 4 Paths per LUN
SAN target are 2 EMC Clariion mirroring each other
The problems we're facing are that... (6 Replies)
Discussion started by: pludi
6 Replies
8. Shell Programming and Scripting
Hello All,
I am very new to Linux i have assignment to take offline backup in linux and restore it to new database oracle 10g?
Help me out any script of it and steps i will be very thankful
Regards,
Sameer (0 Replies)
Discussion started by: sameer_123
0 Replies
9. Shell Programming and Scripting
Hi All
I am able to connect my oracle database with Perl and able to execute the queries.
There is one schema names master19 which contains 50 table.
I want to take backup of each table in and store at a given directory location in Perl
For example suppose if a table student is present in... (1 Reply)
Discussion started by: parthmittal2007
1 Replies
10. Shell Programming and Scripting
Hi All
I am able to connect my oracle database with Perl and able to execute the queries.
There is one schema names master19 which contains 50 table.
I want to take backup of each table in and store at a given directory location in Perl
For example suppose if a table student is present in... (3 Replies)
Discussion started by: parthmittal2007
3 Replies
LEARN ABOUT REDHAT
backup_apropos
BACKUP_APROPOS(8) AFS Command Reference BACKUP_APROPOS(8)
NAME
backup_apropos - Displays each help entry containing a keyword string
SYNOPSIS
backup apropos -topic <help string> [-help]
backup ap -t <help string> [-h]
DESCRIPTION
The backup apropos command displays the first line of the online help entry for any backup command that has in its name or short
description the string specified by the -topic argument.
To display the syntax for a command, use the backup help command.
OPTIONS
-topic <help string>
Specifies the keyword string to match, in lowercase letters only. If the string is more than a single word, surround it with double
quotes (" ") or other delimiters.
-help
Prints the online help for this command. All other valid options are ignored.
OUTPUT
The first line of a command's online help entry names it and briefly describes its function. This command displays the first line for any
backup command where the string specified with the -topic argument is part of the command name or first line.
EXAMPLES
The following example lists all backup commands that include the word "tape" in their names or short descriptions:
% backup apropos tape
labeltape: label a tape
readlabel: read the label on tape
scantape: dump information recovery from tape
status: get tape coordinator status
PRIVILEGE REQUIRED
None
SEE ALSO
backup(8), backup_help(8)
COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 BACKUP_APROPOS(8)