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 MOJAVE
set_color
set_color(1) fish set_color(1)
NAME
set_color - set_color - set the terminal color
set_color - set the terminal color
Synopsis
set_color [-v --version] [-h --help] [-b --background COLOR] [COLOR]
Description
Change the foreground and/or background color of the terminal. COLOR is one of black, red, green, brown, yellow, blue, magenta, purple,
cyan, white and normal.
o -b, --background Set the background color
o -c, --print-colors Prints a list of all valid color names
o -h, --help Display help message and exit
o -o, --bold Set bold or extra bright mode
o -u, --underline Set underlined mode
o -v, --version Display version and exit
Calling set_color normal will set the terminal color to whatever is the default color of the terminal.
Some terminals use the --bold escape sequence to switch to a brighter color set. On such terminals, set_color white will result in a grey
font color, while set_color --bold white will result in a white font color.
Not all terminal emulators support all these features. This is not a bug in set_color but a missing feature in the terminal emulator.
set_color uses the terminfo database to look up how to change terminal colors on whatever terminal is in use. Some systems have old and
incomplete terminfo databases, and may lack color information for terminals that support it. Download and install the latest version of
ncurses and recompile fish against it in order to fix this issue.
Version 1.23.1 Sun Jan 8 2012 set_color(1)