Re: standby database question.

2002-10-23 Thread Rajesh . Rao
Carmichael To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: standby database question.

Re: standby database question.

2002-10-23 Thread Ray Stell
On Wed, Oct 23, 2002 at 08:49:49AM -0800, Tim Gorman wrote: > Correct. > > ...though you can achieve the same thing in 8i by running the SQL*Plus or > SvrMgr process in a "backgrounded" script. Stopping the backgrounded script > is easy using the RECOVER CANCEL command from any other session...

Re: standby database question.

2002-10-23 Thread Joe Testa
nope its unix(solaris flavor). thanks for the idea, thats probably what I'll do versus trying to setup data guard on the nodes. joe Rachel Carmichael wrote: Windows? I used to do this with a 7.3.4 instance on Unix, I had a shell script that would run every x minutes, and would first check to

Re: standby database question.

2002-10-23 Thread Rachel Carmichael
Windows? I used to do this with a 7.3.4 instance on Unix, I had a shell script that would run every x minutes, and would first check to see it if was already running. If not, it would do the recover automatic. It would "fail" when it ran out of archived logs to apply, but the cron would restart it

Re: standby database question.

2002-10-23 Thread Tim Gorman
Correct. ...though you can achieve the same thing in 8i by running the SQL*Plus or SvrMgr process in a "backgrounded" script. Stopping the backgrounded script is easy using the RECOVER CANCEL command from any other session... - Original Message - To: "Multiple recipients of list ORACLE-L

standby database question.

2002-10-23 Thread Joe Testa
I'm back on 8i for a different client who wants to implement standby database. other than the whole possibility of losing data during a failover, i've not been able to find anything about doing managed recovery with out having a dedicated session to put the database in managed recovery mode. S

Re: STANDBY DATABASE QUESTION?

2002-04-19 Thread Bunyamin K. Karadeniz
thank you all... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Messag

Re: STANDBY DATABASE QUESTION?

2002-04-19 Thread Donald Bricker
I will be in training the week of April 22nd to April 25th. I will respond to your e-mail when I return on April 26th. Don >>> ORACLE-L 04/19/02 09:48 >>> 1. Read the oracle docs on either 8i standby database, 9i data guard, log transport services and log apply services. joe Bunyamin K. Ka

Re: STANDBY DATABASE QUESTION?

2002-04-19 Thread Joseph S Testa
from master site. > > - Original Message - > > *From:* Bunyamin K. Karadeniz <mailto:[EMAIL PROTECTED]> > > *To:* Multiple recipients of list ORACLE-L > <mailto:[EMAIL PROTECTED]> > > *Sent:* Friday, April 19, 2002

Re: STANDBY DATABASE QUESTION?

2002-04-19 Thread Joseph S Testa
Karadeniz [mailto:[EMAIL PROTECTED]] > *Sent:* Friday, April 19, 2002 2:33 PM > *To:* Multiple recipients of list ORACLE-L > *Subject:* STANDBY DATABASE QUESTION? > > > > Dear Gurus , > > I want to ask something .. > > I want to apply a st

Re: STANDBY DATABASE QUESTION?

2002-04-19 Thread Joseph S Testa
1. Read the oracle docs on either 8i standby database, 9i data guard, log transport services and log apply services. joe Bunyamin K. Karadeniz wrote: > > > Dear Gurus , > > I want to ask something .. > > I want to apply a standby server ,What I wonder is , if I set it up > automatic ,

RE: STANDBY DATABASE QUESTION?

2002-04-19 Thread Connor McDonald
>From 8.1, the primary node can automatically transfer the logs to the standby node. hth connor --- Vikas Khanna <[EMAIL PROTECTED]> wrote: > Original Message- > Sent: Friday, April 19, 2002 2:33 PM > To: Multiple recipients of list ORACLE-L > > > > Dear Gurus , > I want to ask some

RE: STANDBY DATABASE QUESTION?

2002-04-19 Thread Vikas Khanna
Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 2:33 PMTo: Multiple recipients of list ORACLE-LSubject: STANDBY DATABASE QUESTION?   Dear Gurus , I want to ask something .. I want to apply a standby server ,What I

Re: STANDBY DATABASE QUESTION?

2002-04-19 Thread Arslan Bahar
t: STANDBY DATABASE QUESTION?   Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder  is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ???   And my second question is on

STANDBY DATABASE QUESTION?

2002-04-19 Thread Bunyamin K. Karadeniz
  Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder  is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ???   And my second question is on my Win2000 Adv. Server C:\ drive , PAGEF

RE: Standby database question

2002-01-31 Thread Jeremiah Wilton
On Mon, 28 Jan 2002, Molina, Gerardo wrote: > The status of the data file (on the standby database) shows > "RECOVER" unless the standby control file is refreshed. This status makes no difference in recovering/opening/using the standby. I believe the assertion in the doc is incorrect. -- Jerem

RE: Standby database question

2002-01-28 Thread Molina, Gerardo
Please pardon my poor grammar. I should have said... The status of the data file (on the standby database) shows "RECOVER" unless the standby control file is refreshed. Thanks, Gerardo -Original Message- Sent: Monday, January 28, 2002 2:25 PM To: Multiple recipients of list ORACLE-L

RE: Standby database question

2002-01-28 Thread Molina, Gerardo
Jeremiah, According to the "Oracle8i Standby Database Concepts and Administration Guide" on the online Generic Doc CD (I'm looking at the 8.1.6 Doc CD). Page 4-15 Refreshing the Standby Database Control File The following steps describe how to refresh, or create a copy, of changes you have made

RE: Standby database question

2002-01-25 Thread Jeremiah Wilton
On Fri, 25 Jan 2002, Molina, Gerardo wrote: > There is one last, but important step. > > You need to recreate standby control file... Why do you have to do that? It doesn't say to do that in the documentation. The new datafiles are reflected in the standby controlfile through normal recovery

RE: Standby database question

2002-01-25 Thread Molina, Gerardo
There is one last, but important step. You need to recreate standby control file... on primary: alter database create standby controlfile as ''; ftp this new file to standby on standby: shutdown immediate copy new control file to appropriate locations with correct file name. startup nomou

Re: Standby database question

2002-01-25 Thread Jeremiah Wilton
On Fri, 25 Jan 2002, [EMAIL PROTECTED] wrote: > One of the co-workers has a hot standby database. Logs are applied > at some interval. He has to add a tablespace. What is necessay to > make standby database aware of this? This is clearly documented in the Oracle8i Standby Database Concepts an

Standby database question

2002-01-25 Thread Rick_Cale
Hi DBAs, One of the co-workers has a hot standby database. Logs are applied at some interval. He has to add a tablespace. What is necessay to make standby database aware of this? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECT

Re: standby database question - solved

2001-03-04 Thread Joseph S. Testa
read the documentatio on standby databases. it in the 8.1.7 docs(which nowadays are online), there is a whole book on standby databases. joe Anjan Thakuria wrote: > > can u please tell me how to monitor it . > > TIA > > Anjan > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.c

Re: standby database question - solved

2001-03-04 Thread Anjan Thakuria
can u please tell me how to monitor it . TIA Anjan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /

standby database question - solved

2001-02-28 Thread Joseph S. Testa
never mind, i found it, the RFS(remote file server) process handles it. joe -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FA

Standby database question

2001-02-28 Thread Joseph S. Testa
So my standby is in managed recovery mode. i was curious internally how does oracle send the archive logs across from primary to standby machine(they are physically separate). i know it goes via net8, does it do some internal fopen to write it out and apply it, or am i way out in left field here