defragment ?
hi oracle gurus, how can I defrag a table? this table has many relations,I was going to drop them and export the table and import it again,then create the relations. this is very tedious! is their any better way? stuck with fragmented tables Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MOHAMMAD AMER INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: not able to dump buffers
Hi Arun, You have requested a BUFFER dump, rather than a BUFFERS dump. The BUFFER dump is intended to do a level 10 dump of a particular buffer. The level number to specify in the event syntax is the decimal tablespace relative data block address. Of course, there is no buffer with an RDBA of 10. That is why your trace file was empty. The levels for the BUFFERS dump are as follows. level 1 dump the buffer headers only level 2include the cache and transaction headers from each block level 3include a full dump of each block level 4 dump the working set lists and the buffer headers and the cache header for each block level 5include the transaction header from each block level 6include a full dump of each block Most levels high than 6 are equivalent to 6, except that levels 8 and 9 are the same as 4 and 5 respectively. For level 1 to 3 the information is dumped in buffer header order. For levels higher than 3, the buffers and blocks are dumped in hash chain order. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 27 April 2001 8:07 To: Multiple recipients of list ORACLE-L Hi, I am trying to take a buffer dump thro the following command alter session set events 'immediate trace name buffer level 10'; but all i am getting is a dump file which does not have any information on it can somebody let me know what i am missing here. the below said information is what there in the dump file Dump file g:\806_home\RDBMS80\trace\ORA00241.TRC Thu Apr 26 16:58:24 2001 ORACLE V8.0.6.0.0 - Production vsnsta=0 vsnsql=c vsnxtr=3 Windows NT V4.0, OS V5.101, CPU type 586 Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production With the Partitioning and Objects options PL/SQL Release 8.0.6.0.0 - Production Windows NT V4.0, OS V5.101, CPU type 586 Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 11 pid: f1 *** 2001-04-26 16:58:24.879 *** SESSION ID:(10.1) 2001-04-26 16:58:24.879 Dump of buffer cache at level 10 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Could not Connect to 8.1.6
Do you have a brain? -Original Message- Sent: April 28, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Did you update your listener? And TNSNAMES? -- Reply Separator -- Author: [EMAIL PROTECTED] (N J Neog) Date: 4/27/01 9:40 PM Hi all, We 3 Oracle server as follows. A. Oracle8 Enterprise Edition 8.0.5 B. Oracle8i Enterprise Edition 8.1.5 C. Oracle8i Enterprise Edition 8.1.6 was Installed Recently. All are in Digital Unix The problem is >From a Unix user if my ORACLE_HOME is pointing to database A(8.0.5) or B(8.1.5), we can connect from Sqlplus to Oracle Server A and B not to C (8.1.6.) But If ORACLE_HOME is pointing to C(8.1.6), Sql Plus can connect to all database. Is there a problem with 8.1.6 ? or had we Installed 8.1.6 wrongly ? Any suggestion how to rectify it assuming my ORACLE_HOME always points to 8.1.5 or 8.0.5. Thanks in advance Regards. Naba J Neog -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hutchins, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: monitoring listener.log
Hi again, Note that listener is only used while creating shadow processes on server side. Once shadow processes are created by listener, listener is never used. in other words, listener process is not a bridge between user process and server process during data transmissions. So, scanning listener.log only is not a good way to catch sql*net errors. to catch sql*net errors after connections are established, set sql*net server trace. then scan them. But, it's not be efficient. there will be a lot of trace files. rgrds... "Danisment Gazi Unal (Unal Bilisim)" wrote: Hi, Typical errors in sql*net traces are like this: nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=533, nt[1]=57, nt[2]=0 Means: You get protocol error 57. If you are using TCP/IP, check winsock errors, if I'm not wrong it should be 20057 or 10057. This error causes sql*net 533 error. 533,12560 and 12571 are result. Saurabh Sharma wrote: hey can u elaborate how do u scan each log file, and convert it in email msg.how do u do this.. saurabh sharmadba - Original Message - From:NGUYEN Philippe (Cetelem) To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 25, 2001 9:10 PM Subject: monitoring listener.log Hi list, We have a script wich monitor the alert.log for each database. This script scan the alert.log file and send an email if an ORA-xxx error occured Now, we want to write a script monitoring the listener.log file : wich kind of message or variable indicate a network problem (ORA-xxx, ...) ? ...then we 'll have the same question for the log file made by OEM ! TIA
RE: Could not Connect to 8.1.6
I haven't tried it, or seen it myself, but some people here in the state have said there is a problem connecting from an 8.0.5 home to an 8.1.6 database. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 28, 2001 12:01 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Could not Connect to 8.1.6 > > > Did you update your listener? And TNSNAMES? > -- Reply Separator -- > Author: [EMAIL PROTECTED] (N J Neog) > Date: 4/27/01 9:40 PM > > Hi all, > > We 3 Oracle server as follows. > > A. Oracle8 Enterprise Edition 8.0.5 > B. Oracle8i Enterprise Edition 8.1.5 > C. Oracle8i Enterprise Edition 8.1.6 was Installed Recently. > > All are in Digital Unix > > The problem is > > From a Unix user if my ORACLE_HOME is pointing to database > A(8.0.5) or > B(8.1.5), > > we can connect from Sqlplus to Oracle Server A and B not to C (8.1.6.) > But If ORACLE_HOME is pointing to C(8.1.6), Sql Plus can > connect to all > database. > > > Is there a problem with 8.1.6 ? or had we Installed 8.1.6 wrongly ? > Any suggestion how to rectify it assuming my ORACLE_HOME always > points to 8.1.5 or 8.0.5. > > Thanks in advance > > Regards. > > Naba J Neog > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PLEASE HELP !
Just create a different user account on Oracle for each student. This is roughly anologous to building a separate database for each user in Sybase, and easier to manage. Jared On Friday 27 April 2001 23:00, Andrea Oracle wrote: > Hi all, > > Our trainer needs to build training database/s, she is > asking the following questions: > > 1. use Sybase or Oracle as the database server? > We have some projects using Sybase databases, and > > old training database is on Sybase. > > 2. build the database on Unix vs NT platform? > > 3. She wants each trainee has his/her own > database(!!!), since she doesn't want one use to see > other user's data. And she said in Sybase it's really > easy to do this, she has a script that can create > multiple databases. Is it doable (please give some > tip or script), or is it necessary ??? > > Any idea will be greatly appreciated!!! > > > Andrea > > __ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great prices > http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Could not Connect to 8.1.6
Did you update your listener? And TNSNAMES? -- Reply Separator -- Author: [EMAIL PROTECTED] (N J Neog) Date: 4/27/01 9:40 PM Hi all, We 3 Oracle server as follows. A. Oracle8 Enterprise Edition 8.0.5 B. Oracle8i Enterprise Edition 8.1.5 C. Oracle8i Enterprise Edition 8.1.6 was Installed Recently. All are in Digital Unix The problem is >From a Unix user if my ORACLE_HOME is pointing to database A(8.0.5) or B(8.1.5), we can connect from Sqlplus to Oracle Server A and B not to C (8.1.6.) But If ORACLE_HOME is pointing to C(8.1.6), Sql Plus can connect to all database. Is there a problem with 8.1.6 ? or had we Installed 8.1.6 wrongly ? Any suggestion how to rectify it assuming my ORACLE_HOME always points to 8.1.5 or 8.0.5. Thanks in advance Regards. Naba J Neog Text
Re: PLEASE HELP !
Andrea, Where do we start here? OK, First off I'm not a SYBASE fan. Third party's are dropping support rather quickly (PeopleSoft does not support it any longer) and it's market share is dropping. Sooner of later I think it will belong to one of the three giants to remain , IBM, Oracle, or MicroSoft. SO I don't think that's such a great idea. Now if your going to do it in Oracle, where is the bulk of your DB's right now. If their on NT then go there. If their on Unix then go there. Lastly I would NOT build a seperate instance for every trainee. That is ludecrious. Now a seperate schema for each would be more reasonable, but enev then the kernel load to merge all of that data back toghether for her perusal is WAY TOO much. In this case your Trainer is the customer. She should be laying out what her requirements are. Sha has done that by saying she needs a training database and that she wants each trainee to see only their records. OK, now it's up to her to leave the rest to you. If she can't do that, if she MUST DICTATE the solution, then my answer is "Your on your own, go away and don't bother me." Dick Goulet -- Reply Separator -- Author: Andrea Oracle <[EMAIL PROTECTED]> Date: 4/27/01 10:00 PM Hi all, Our trainer needs to build training database/s, she is asking the following questions: 1. use Sybase or Oracle as the database server? We have some projects using Sybase databases, and old training database is on Sybase. 2. build the database on Unix vs NT platform? 3. She wants each trainee has his/her own database(!!!), since she doesn't want one use to see other user's data. And she said in Sybase it's really easy to do this, she has a script that can create multiple databases. Is it doable (please give some tip or script), or is it necessary ??? Any idea will be greatly appreciated!!! Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trace file does not reside in user_dump_dest. Why ?
Chor Ling, Go to the /dg1/oracle/niecomn/admin directory and run ls -al. If you see an arrow pointing to a directory description /dg1/oracle/nieora/8.1.6/rdbms/log, then it is a link. Regards, David A. BArbour Oracle DBA, OCP "CHAN Chor Ling Catherine (CSC)" wrote: > > Hi David, > > How do I know whether the udump directory is a link to the > nieora/8.1.6/rdbms/log directory? My OS is Unix & I am pretty new to Unix. > Any advice ? TIA > > Regds, > Chorling > -Original Message- > From: David A. Barbour [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 27, 2001 10:41 PM > To: Multiple recipients of list ORACLE-L > Subject:Re: Trace file does not reside in > user_dump_dest. Why ? > > Catherine, > > Just a WAG, but could the udump directory be a link to the > nieora/8.1.6/rdbms/log directory? > > David A. Barbour > Oracle DBA, OCP > > "CHAN Chor Ling Catherine (CSC)" wrote: > > > > Hi Ed, > > > > SQL> select name, value > > 2 from v$parameter > > 3 where name like '%user_dump%'; > > > > NAME VALUE > > > > > user_dump_dest > /dg1/oracle/niecomn/admin/udump > > > > The user_dump_dest is /dg1/oracle/niecomn/admin/udump but > the trace file is > > dumped into another directory > /dg1/oracle/nieora/8.1.6/rdbms/log. > > The unix permission for /dg1/oracle/niecomn/admin/udump & > > /dg1/oracle/nieora/8.1.6/rdbms/log is the same. > > > > I just don't understand why the trace file is not located > in user_dump_dest. > > > > Puzzled, > > New bee > > -Original Message- > > From: Shevtsov, Eduard > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, April 26, 2001 6:26 PM > > To: Multiple recipients of list > ORACLE-L > > Subject:RE: Trace file does not > reside in > > user_dump_dest. Why ? > > > > Hi > > > > have you got unix permissions to write to > this directory? > > Try to logon as oracle owner and check it > by writing any > > small file there. > > > > Also look at the output of the query > > > > select name, value > > from v$parameter > > where name like '%user_dump%'; > > > > It will show your actual user dump > directory > > > > HTH > > > > Ed > > > > > > > > > > > Hi, > > > > > > I forget to mention that when I show > parameter dest* in > > > server manager , the > > > user_dump_dest is pointing to the right > directory > > > /dg1/oracle/niecomn/admin/udump. > > > > > > My earlier email : > > > I issue the command "alter > database backup > > > controlfile to > > > trace", expecting my trace file to > reside in the > > > user_dump_dest directory. > > > > > > connect / as sysdba; > > > startup > > pfile=/dg1/oracle/nieora/8.1.6/dbs/initNIE.ora > > > > > > In the startup file, > > > User_dump_dest = > > /dg1/oracle/niecomn/admin/udump > > > > > > However, the trace file > resides in another > > directory > > > /dg1/oracle/nieora/8.1.6/rdbms/log. >
script to run before startup
I want to run a script after the startup of database automatically. How can I do this on NT?? Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729
which tables to cache ?
I am planning to cache some tables in my database butI can not decide on them. I have 5 big tables ,150 small tables. these 5 big tables sum is bigger than total size of database buffer cache. Is it good to cache them because I have so much complex views collecting data from these big tables.?? Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729
Re: PLEASE HELP !
Andrea, Build one database with different schemas for each user. When they log in, they'll only have access to their own data. You'll have to decide whether to use UNIX or NT depending on a variety of factors, but if you have the available resources, I'd go with UNIX (multiple users performing multiple tasks). Regards, David A. Barbour Oracle DBA, OCP Andrea Oracle wrote: > > Hi all, > > Our trainer needs to build training database/s, she is > asking the following questions: > > 1. use Sybase or Oracle as the database server? > We have some projects using Sybase databases, and > > old training database is on Sybase. > > 2. build the database on Unix vs NT platform? > > 3. She wants each trainee has his/her own > database(!!!), since she doesn't want one use to see > other user's data. And she said in Sybase it's really > easy to do this, she has a script that can create > multiple databases. Is it doable (please give some > tip or script), or is it necessary ??? > > Any idea will be greatly appreciated!!! > > Andrea > > __ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great prices > http://auctions.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andrea Oracle > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Software Company in Seattle needs an Oracle DBA...
Leading edge software company in Seattle Washington Needs an Oracle DBA to join its' I.T. team. This is a full time staff position, so no contractors or third parties please. *Description: Primary focus of the position is proactive management of logical and physical Oracle database components for client's Ecommerce systems. This person will participate in developing and administering best practices necessary to meet business critical 24x7 availability requirements. The role will initially be a mid-level administrator, with an opportunity to increase responsibilities as skills and capabilities are demonstrated. Requirements: 3+ years administering large (multi terabyte) Oracle databases on clustered Sun/Solaris platforms in a dynamic data center environment with in-depth knowledge of Veritas/UNIX/LINUX, I/O and highly available system designs. Also required is: Oracle 8i, parallel server, snap-shot replication, partition, data warehouse, star schema, and hot standby experience. * U.S. citizenship or permanent residency is also required. This position offers: * Opportunity to become a key member of the team * Base Salary very competitive..D.O.E. * Great Benefits * Relocation package NO sub contracting positions available. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as a Word attachment to: Orastaff, Inc. Email: [EMAIL PROTECTED] *PLEASE do not send your resume or call if you need sponsorship or are a third party! Phone: 1-800-549-8502 The job code is: One/DBA/Seattle/Barbara Note: This is only one of the many opportunities that we have available across the U.S. for candidates with Oracle skills. So if this one is not a match for you, we invite you to send us your resume- as we quite possibly have the opportunity that you are seeking. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
a minor clarification: SQL tuning is not a problem anymore ?
Hi, I would like to add a minor clarification. I saw some non SQL/event10046 trace files are uploaded. let's note that it's not possible to analyze SQLs if they are not traced by SQL_TRACE/Event10046. for report.txt, you can use Anjo's page at www.oraperf.com regards... unal-bilisim wrote: - Original Message - From: Danisment Gazi Unal (Unal Bilisim) To: Multiple recipients of list ORACLE-LSent: Saturday, April 28, 2001 12:16 AMSubject: SQL tuning is not a problem anymore ? Hi gurus, I developed a web based tool which formats SQL and Event10046 traces. This tool is superior to tkprof but It works on WEB and formats Binds variables and Waits for SQLs in trace files. and gives tuning advises and costs of SQLs. You can compare these costs with other SQLs (unlike in Oracle). so, you can easly see improvements in your SQLs after re-writing it. You can not only see waits, but also sub-waits. For example, you can see: - time waited on specific Enqueue suchs as (TX), etc. - time waited on specific latch such as "latch wait list", etc. - time waited on specific file - time waited on specific block Product is at http://www.unal-bilisim.com/products/itrprof/itrprof_index.html And, I would like to thank to my dear friends Gopal, Young and people in Turkey for their interests about itrprof. Thank you friends... you can ask your any questions and send recomendations... hope You enjoy
RE: Real-life Stand-by DB implementation stories?
1. We did not use remote archival in case of a network failaure. (The customer had a pretty overloaded ATM network that crashed two three times a day. 2. What I ment by dedicated server is that we did not allow any other application of functionallity to be installed on the primary or secondary database host, apart from backup and recovery SW. No file server, only the database and the backup SW. Not even print server ( some years back we had our Windows NT server crash because an errorous Word file got stuck in the spool...). 3. Failing back to the primary site is not that difficult, since in our case we can offer an off time for the failing back to primary. In this case we make cold backup from the standby, move it to the primary site via LAN ( it's already a 256 Mbit LAN). After backing up the control files from the newly created primary site, life can go on. Failing back can be done when business is low i.e. on a weekend night. I have got a question about Data Guard: Do you have to have Enterprise Edition for it to work? We did not use Managed Standby Database functionallity, because it needed Enterprise Edition licence - and it meens a huge extra cost. Regards, Tamas Szecsy == -Original Message- Sent: 2001.04.27. 6:31 PM To: Multiple recipients of list ORACLE-L I have recently implemented it at Cox, San Diego. I faced lot of problems in switching between Read Only and sunstained recovery modes with 8.1.6. I could not conclude anything about this, may be bug in 8.1.6. I am observing everyone mentioning about scheduling a job to transfer arch files to secondary.Why not using the feature of remote archival. I have used it and I didn't have any problems. Only script I had to develop was the one to monitor errors on Primary and Standby sites to take care of Archival and recovery breaks. Suren -Original Message- Sent: Friday, April 27, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Yes we did. It's on windows NT. We have implemented manually managed standby database, with a db job on the primary database archiving online redo log files every five minutes to minimize data loss in case of a crash of the primary database. The standby database server ftps *iwth a windows nt scheduled job, running every 15 minutes) new archive log files to it's local drive and applies them to the standby database if it's not in read-only mode for reporting. It's working since a more than a year, never had any problems with it. If Windows NT server is kept away from frequent install/deinstall of various applications then within my experience it is a stable solution. By the way, if Oracle Technet can be believed, Oracle 9i will have an automatic fail over feature for the standby database. My view is that you should use Oracle 8.1.7. Oracle 8.1.6 has some problems with read-only mode combined with managed standby database - or so I heard. Regards, Tamas Szecsy === Anyone implemented SBDBs recenetly? A client is comparing them to a cluster solution involving Fail-Safe. We are recommending SBDB and trying to go to 817 also (on 80521 now). Also this is NT if that makes a difference. Thanks, Earl Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, se
