Oracle backup failures after SAN change.


 
Thread Tools Search this Thread
Operating Systems Solaris Oracle backup failures after SAN change.
# 1  
Old 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
# 2  
Old 08-12-2010
qio is a setting telling it to use Veritas QuickIO for direct I/O instead of buffered I/O. A few years ago when I administered Solaris servers with Oracle on them the Oracle DBAs usually wanted their volumes mounted with this option set.
# 3  
Old 08-16-2010
Thanks for the explanation.it is very useful.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Oracle Data BackUp with Help Of Perl

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

2. Shell Programming and Scripting

Oracle Data BackUp with Help Of Perl

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

3. Shell Programming and Scripting

Cold backup oracle and Restore to new db

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

4. Emergency UNIX and Linux Support

Oracle/Xen/OVM/OCFS2/Multipath/SAN Problems

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

5. HP-UX

Can we restore omni oracle db backup

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

6. UNIX for Advanced & Expert Users

Oracle VM / T3 SAN or Local for LDOMS?

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

7. Solaris

what is SAN and LAN backup -give difference

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

8. Shell Programming and Scripting

Help with sed in Oracle DB backup script.

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

9. Shell Programming and Scripting

Need help with oracle backup script

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

10. Solaris

How to configure my SAN with Sun V880 servers to run Oracle 9i

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
Login or Register to Ask a Question