|
|
Replies |
Author |
Last Post |
loss of data using a SAN
Hi, we are testing failovers for two Windows 2008 servers using an Oracle 11g R2 database on a SAN. The SAN is disabled/enabled between these 2 servers.
In the documentation it says:
Loss of data if the SAN drive is being written to when the HBA card is disabled. You must ensure that all interfaces are shutdown before implementing the failover process.
Question: How can you lose data on the SAN? Surely the SAN is just a set of disks and Oracle can recover using the redo logs once you enabled the SAN onto the secondary server?
Thank you. |
2 |
juliet clark |
juliet clark
Fri Jul 30, 2010 |
database shutdown and error in alertlog
Hi all,
Can you please guide me. It has started since two days getting error in alert log. Also databse shutdown by itself at night. Then i have to restart it ever morning since two days: here is the text from Alertlog file:
Thu Jul 22 00:07:20 2010
Errors in file /LOcation/DBISNTANCE/admin/bdump/DBISNTANCE_lgwr_22648.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/LOcation/DBISNTANCE/oradata/DBISNTANCE_redo02.log'
ORA-27086: skgfglk: unable to lock file - already in use
SVR4 Error: 11: Resource temporarily unavailable
Additional information: 8
Thu Jul 22 00:07:20 2010
Doing block recovery for fno: 2 blk: 78
Thu Jul 22 00:07:20 2010
Errors in file /LOcation/DBISNTANCE/admin/bdump/DBISNTANCE_lgwr_22648.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/LOcation/DBISNTANCE/oradata/DBISNTANCE_redo02.log'
ORA-27086: skgfglk: unable to lock file - already in use
SVR4 Error: 11: Resource temporarily unavailable
Additional information: 8
Thu Jul 22 00:07:20 2010
LGWR: terminating instance due to error 313
Instance terminated by LGWR, pid = 22648
what is the solution?
thanks |
2 |
juliet clark |
juliet clark
Fri Jul 30, 2010 |
Removing un committed transaction from datafiles?
Hi anybody can u please explain to me how oracle internally deleted un committed transaction from the data files, i know by using redo log files but i want to know how it works. |
2 |
juliet clark |
juliet clark
Fri Jul 30, 2010 |
Oracle streams for certain users
Does anybody know of an EASY to follow document or a script I can run,
which will setup schema replication for several users in my DB. I want to
be able to add data in DB1 and have it automatically copy to DB2 and vice versa.
Thanks in advance to all who answer this post. |
2 |
juliet clark |
juliet clark
Fri Jul 30, 2010 |
Download Oracle Database 10g Express Edition
http://www.oracle.com/technetwork/database/express-edition/downloads/index.html |
1 |
juliet clark |
juliet clark
Fri Jul 30, 2010 |
Oracle Database 10g Express Edition
Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that's free to develop, deploy, and distribute; fast to download; and simple to administer. Oracle Database XE is a great starter database for:
* Developers working on PHP, Java, .NET, XML, and Open Source applications
* DBAs who need a free, starter database for training and deployment
* Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge
* Educational institutions and students who need a free database for their curriculum |
1 |
juliet clark |
juliet clark
Fri Jul 30, 2010 |
Monitoring Memory Consumption on 11g
Hello All,
We have an WEB application that is running against an 11g 11.1.0.7 database and would like to see what th actually memory consumption is when that application runs and spawns sessions and processes. We only have 1GB of RAM for the SGA and was wondering if it east that up and times out. Nothing in the error log tells us anything.
Appreciate your help. |
1 |
John Gates |
John Gates
Thu May 27, 2010 |
Invite Friends
Error : Sorry this job does not exist or deleted from our database.