Sponsored Content
Operating Systems Solaris Oracle backup failures after SAN change. Post 302444551 by nokiae63 on Thursday 12th of August 2010 07:16:09 AM
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
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
st_ats_enabled(5)						     OBSOLETED							 st_ats_enabled(5)

NAME
st_ats_enabled - determine whether to reserve a tape device on open (OBSOLETED) VALUES
Default Allowed values or Recommended values DESCRIPTION
Note: this tunable is obsoleted and has been renamed to beginning with release HP-UX 11i v3. This tunable notifies the stape or estape driver whether it needs to reserve a tape device on open and subsequently release it on close. When this tunable is on the stape or estape driver will attempt to reserve any tape device on open. The driver has a few tape devices flagged as suitable devices for this functionality including DLT 8000, DLT 7000, STK 9840, HP Ultrium, and others. DDS drives are not flagged for this functionality. The tunable allows the safe sharing of tape devices in multinode configurations like MC/ServiceGuard's Advanced Tape Sharing. The auto- matic reserve and release protects the tape device from being accessed from multiple nodes which would corrupt a backup. If the reserve portion of the stape or estape driver's open routine fails, a status of is returned. Who Is Expected to Change This Tunable? Anyone. Restrictions on Changing Changes to this tunable take effect immediately and are used during the next open or close. When Should the Tunable Be Turned On? This tunable should be turned on if the system will be used in an MC/ServiceGuard Advanced Tape Sharing configuration or the user wants the stape or estape driver to use automatic reserve or release on open and close for multinode manageability. What Are the Side Effects of Turning the Tunable On? A reserve is sent to the tape device by the stape or estape driver on open and a release is sent on close. No other initiator or HBA will be able to access the tape device while it is opened on another initiator or HBA. When Should the Tunable Be Turned Off? This tunable should be turned off for any SAN tape sharing solution configuration other than ATS. Most multinode backup applications (for example, Omniback) manage device reservation themselves and any interference by the stape or estape driver may produce problems. This tun- able should also be turned off for any multiplatform SAN configuration to keep tape access across platforms more uniform. What Are the Side Effects of Turning the Tunable Off? Unauthorized access from another initiator might interfere with any current tape operation. What Other Tunables Should Be Changed at the Same Time? None. WARNINGS
All HP-UX kernel tunable parameters are release specific. This parameter may be removed or have its meaning changed in future releases of HP-UX. Installation of optional kernel software, from HP or other vendors, may cause changes to tunable parameter values. After installation, some tunable parameters may no longer be at the default or recommended values. For information about the effects of installation on tun- able values, consult the documentation for the kernel software being installed. For information about optional kernel software that was factory installed on your system, see at AUTHOR
was developed by HP. SEE ALSO
st_ats_enable(5), scsi_tape(7), scsimgr_estape(7). Tunable Kernel Parameters st_ats_enabled(5)
All times are GMT -4. The time now is 10:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy