Re: standby database configuration in 9iR2 SE ?

2003-12-27 Thread Tim Gorman
JP, Juan, and Prem, Prem is correct. Standby is certainly a feature of SE, just not the "managed recovery" and "SQL*Net log shipping" parts, which only come with EE. Essentially, Standby Database features in SE is just like Standby Database features from 7.3 through 8.0

RE: standby database configuration in 9iR2 SE ?

2003-12-17 Thread Niall Litchfield
keep track of log gaps manually. Niall > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Prem Khanna J > Sent: 16 December 2003 08:04 > To: Multiple recipients of list ORACLE-L > Subject: RE: standby database configuration in 9i

RE: standby database configuration in 9iR2 SE ?

2003-12-16 Thread Prem Khanna J
No Juan . SE also has the feature but "Managed Recovery" is not possible as in EE . A metalink doc says : Basic Standby Database is a feature of SE . that is it Allows the DBA to manually clone a database, and to copy and to apply log files to the standby anyway i'm look

RE: standby database configuration in 9iR2 SE ?

2003-12-16 Thread Juan Miranda
Standby is only for Enterprise Ed. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Prem Khanna J Enviado el: martes, 16 de diciembre de 2003 8:24 Para: Multiple recipients of list ORACLE-L Asunto: standby database configuration in 9iR2 SE ? List, Can

standby database configuration in 9iR2 SE ?

2003-12-16 Thread Prem Khanna J
List, Can someone give me a doc/URL for the steps invloved in standby database configuration ( manual recovery mode ) on 9iR2 SE ? I do have a doc for standby database configuration ( managed recovery mode ) for 8i EE . except automatic log transfer which is not a feature of SE , will the

RE: Oracle Standby database.

2003-09-25 Thread Avnish.Rastogi
Its possible 'cause we are two different OS and DB versions. Would it be possible if we upgrade source database from 816 to 8174 and then use Standby database. -Original Message- Sent: Thursday, September 25, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Avnish: That i

Re: Oracle Standby database.

2003-09-25 Thread K Gopalakrishnan
Avnish: That is not possible in 8.1.7. You need to be atleast 9.2 to do that. --- [EMAIL PROTECTED] wrote: > We are planning to migrate one 600GB OPS (2 nodes) database from AIX > 433 Oracle 816 to AIX5.1 Non OPS Oracle 8174. Is it possible to use > Oracle standby database of two

Oracle Standby database.

2003-09-25 Thread Avnish.Rastogi
We are planning to migrate one 600GB OPS (2 nodes) database from AIX 433 Oracle 816 to AIX5.1 Non OPS Oracle 8174. Is it possible to use Oracle standby database of two different versions of OS and database. DISCLAIMER: This message is intended for the sole use of the individual to whom it is

Re: Oracle Standby Database Backups.

2003-09-05 Thread Arup Nanda
ve more questions on this.   Arup Nanda www.proligence.com - Original Message - From: VIVEK_SHARMA To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 05, 2003 3:09 AM Subject: RE: Oracle Standby Database Backups. Arup,

RE: Oracle Standby Database Backups.

2003-09-05 Thread VIVEK_SHARMA
Arup,Indy, List   Some Clarifications please   If the Primary Database is in ARCHIVELOG Mode (Physical Standby) & archived files there from are being shipped & applied to the Standby Database, What is the need to run the Standby Database in ARCHIVELOG Mode?   Are you imp

Re: rename data file on standby database

2003-09-04 Thread Kader Ben
Many thanks Louis for your input, Have nice day, Kader --- Jose Luis Delgado <[EMAIL PROTECTED]> wrote: > Hi Kader... > > you do not need to do the same on the standby > database... > > That logical changes are reflected automatically... > The only thing is that yo

RE: Oracle Standby Database Backups.

2003-09-04 Thread Jose Luis Delgado
Tom I was wondering about the last log file on your primary database that still hasn't been sent to your standby database until a switch log occurs... (thinking about sustained mode too) Have you taken that into account?? JL --- "Mercadante, Thomas F" <[EMAIL PROTECT

RE: Oracle Standby Database Backups.

2003-09-04 Thread Jose Luis Delgado
ied Professional > > > -Original Message- > Sent: Thursday, September 04, 2003 11:29 AM > To: Multiple recipients of list ORACLE-L > > > Tom > > I was wondering about the last log file on your > primary database that still hasn't been sent to your >

Re: rename data file on standby database

2003-09-04 Thread Jose Luis Delgado
Hi Kader... you do not need to do the same on the standby database... That logical changes are reflected automatically... The only thing is that your physical datafile remain as initially, but your controlfile has the changes. Was I clear? note that the only changes that you need to do at

RE: Oracle Standby Database Backups.

2003-09-04 Thread Mercadante, Thomas F
ipients of list ORACLE-L Tom I was wondering about the last log file on your primary database that still hasn't been sent to your standby database until a switch log occurs... (thinking about sustained mode too) Have you taken that into account?? JL --- "Mercadante, Thomas F"

RE: Oracle Standby Database Backups.

2003-09-04 Thread Mercadante, Thomas F
Arup,   Thanks for the reply.  So I am assuming that the Standby database is in archivelog mode?  Good idea performing the backup on the standby rather than the Primary.  Our Primary is supposed to grow to 3TB, so your idea has merit.  And our servers will be in two different buildings

Re: Oracle Standby Database Backups.

2003-09-03 Thread Indy Johal
Tom As long as your standby database is Physical Standby DB [ Not for Logical Standby Database where you also need to take the standby database backup] If the Database size is very big [ Not even in TB but few hundred GB ], If the Database is 24*7 If the Network connection is good [ We are not

Re: Oracle Standby Database Backups.

2003-09-03 Thread Arup Nanda
Tom,   You should perform backups from the Standby database, regular RMAN backups, no need to shutdown the database. Make sure you backup the archived log files from there too. Contrary to what the docs might _imply_, I use the word "imply" rather than "state", since the

rename data file on standby database

2003-09-03 Thread Kader Ben
Hi Listers, I have standby database working fine (until now!). I have renamed one datafile on the primary database and I'm wondering if I have to do the same thing on the standby database to reflect the structure change. I have renamed the file yesterday and the standby database stil recov

Oracle Standby Database Backups.

2003-09-03 Thread Mercadante, Thomas F
considering using Oracle Standby to have the database available as much as possible.   Do I need to perform regular backups of the Standby database?  Sounds like a silly question, but how do I do this?  Using Rman?  Or do I shut it down and perform a cold backup?  I will definitely use Rman on the

Standby database & ORA-16016

2003-08-14 Thread Bob Metelsky
ORA-16016 archived log for thread string sequence# string unavailable Hello All I have a standby database oracle 8.1.7.4 on win2k running in "managed recovery mode". NET8 have been transferring logs untill somehow the primary or standby server must have rebooted and I have now hav

Re: Standby database & ORA-16016

2003-08-09 Thread Tanel Poder
- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 08, 2003 10:59 PM > ORA-16016 archived log for thread string sequence# string unavailable > > Hello All > > I have a standby database oracle 8.1.7.4 on win2k running in "managed >

Re: Purging Managed Standby Database Archive Logs

2002-12-16 Thread Shaleen
Title: RE: Purging Managed Standby Database Archive Logs For pre 9i release2 there is following Note on metalink Doc ID: Note:190311.1 Subject: ** How to delete an Operating System file from PL/SQL   This uses a java stored

Re: Purging Managed Standby Database Archive Logs

2002-12-16 Thread Yechiel Adar
Title: RE: Purging Managed Standby Database Archive Logs Hello Steve   If you are on 9.2 you can use utl_file.fremove directly from the sql.   Yechiel AdarMehish - Original Message - From: Orr, Steve To: Multiple recipients of list ORACLE-L Sent: Thursday, December 12

RE: Purging Managed Standby Database Archive Logs

2002-12-12 Thread Orr, Steve
Title: RE: Purging Managed Standby Database Archive Logs Hi John, Keeping things simple sometimes complicates things when they go haywire. I thought about the simple shotgun approach but wanted something a little more robust and I didn't want to risk deleting an archive log that hadn&#

Re: Purging Managed Standby Database Archive Logs

2002-12-12 Thread JApplewhite
[EMAIL PROTECTED] Subject: Purging Managed Standby Database Archive Logs

Re: Purging Managed Standby Database Archive Logs

2002-12-12 Thread John Carlson
ves which have been automagically applied to a managed standby database? I figure it needs to: 1. Query v$archived_log and v$log_history to get a list of the archive logs (v$archived_log.name) where sequence# > [the max number you purged the last time]; 2. Cycle through the above list and

Purging Managed Standby Database Archive Logs

2002-12-12 Thread Orr, Steve
Title: Purging Managed Standby Database Archive Logs Any one have a ready-made routine to purge the unneeded archives which have been automagically applied to a managed standby database? I figure it needs to: 1. Query v$archived_log and v$log_history to get a list of the archive logs (v

Re: Implementing Continuous Managed Recovery on a Standby Database

2002-12-07 Thread Connor McDonald
upgrade to 9... SQL> recover ... disconnect hth connor --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > Problem: How to keep a standby database in > continuous managed recovery > without having to maintain an open terminal session. > (Version 8.1.7.2) >

Re: Implementing Continuous Managed Recovery on a Standby Database

2002-12-06 Thread Peter Barnett
blem: How to keep a standby database in > continuous managed recovery > without having to maintain an open terminal session. > (Version 8.1.7.2) > > When you execute the following... > ------ >

Re: Implementing Continuous Managed Recovery on a Standby Database

2002-12-06 Thread Joerg Jost
- > sqlplus "/ as sysdba" @managed_recov.sql standby.log & > -- [...] > Is there a better way to do this? I submitted a TAR but OWS hasn't been any > help. Doesn't it seem lame that Oracle gives the "RECOVER MANAGED STAN

Re: Implementing Continuous Managed Recovery on a Standby Database

2002-12-06 Thread Jeff Herrick
right thing by redirecting stdoutstdin was already pointing to the script file. I would go one more paranoid step further and redirect stderr too. Jeff Herrick On Fri, 6 Dec 2002, Orr, Steve wrote: > Problem: How to keep a standby database in continuous managed recovery > without having to

Implementing Continuous Managed Recovery on a Standby Database

2002-12-06 Thread Orr, Steve
Problem: How to keep a standby database in continuous managed recovery without having to maintain an open terminal session. (Version 8.1.7.2) When you execute the following... -- SQL> RECOVER MANAGED STANDBY DATAB

Re: standby database question.

2002-10-23 Thread Rajesh . Rao
That would be the manual mode. "Recover standby database". With 8i, and the multiple archive destinations, you have the sustained recovery mode. "Recover managed standby database". A sustained recovery mode will lock your telnet window, and will be dedicated to doing just th

Re: standby database question.

2002-10-23 Thread Ray Stell
> - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, October 23, 2002 10:14 AM > > > > I'm back on 8i for a different client who wants to implement standby > > database. > > > >

Re: standby database question.

2002-10-23 Thread Joe Testa
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. SQL>

Re: standby database question.

2002-10-23 Thread Rachel Carmichael
ld restart it and check for more. Worked pretty well.. Rachel --- Joe Testa <[EMAIL PROTECTED]> wrote: > 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'v

Re: standby database question.

2002-10-23 Thread Tim Gorman
of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, October 23, 2002 10:14 AM > 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

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 rec

9i QUESTIONS: STANDBY DATABASE IMPLEMENTATION

2002-09-26 Thread Johan Muller
/failure/gotchas. The config that is planned is to put the standby database on a separate AIX platform attached to another Shark storage unit. 3. If there is a canned, step-by-step proc anywhere, would anybody be kind enough to post the same. I vaguely recall this topic from previous posts, but as per

RE: Advantage of Standby Database in 9i vs 8i

2002-09-11 Thread Rachel Carmichael
not quite. only if you are using logical standby, which applies sql statements to the standby database instead of physical standby which applies archived redo logs There is an entire manual dedicated to standby database (now called Data Guard) in the 9i doc set online. There is, as was pointed

RE: Advantage of Standby Database in 9i vs 8i

2002-09-11 Thread DENNIS WILLIAMS
Vivek - In 8i the standby database must either be in standby mode (applying log files) or open for read-only querying. In 9i it can do both simultaneously. I haven't use all the correct terms here, but maybe it will irritate someone into providing a more complete response.   Dennis William

Advantage of Standby Database in 9i vs 8i

2002-09-11 Thread VIVEK_SHARMA
What is the Advantage of Standby Database in 9i vs 8i ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Solution to Microsoft Transaction Server/Standby database problem

2002-06-03 Thread Miller, Jay
Some of you may recall a question I posted on a problem with MTS connection pooling. MTS continued to try to connect to our old IP address after switching between production and standby. This happened even though we switched the IP address the DNS Name was pointing to. Well, we finally managed

Re: Microsoft Transaction Server & Standby database problem

2002-05-20 Thread Tim Gorman
Sorry, I've never used MS-MTS... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 3:48 PM > Thanks, > > We tried this syntax in our test environment and it worked very well but of > course had no way of knowing if it solved o

RE: Microsoft Transaction Server & Standby database problem

2002-05-20 Thread Miller, Jay
Thanks, We tried this syntax in our test environment and it worked very well but of course had no way of knowing if it solved our problem since that didn't show up in the test environment even in normal circumstances. Have you actually had experience using this when Microsoft Transaction Server w

Re: Microsoft Transaction Server & Standby database problem

2002-05-17 Thread Tim Gorman
prod = (description= (address_list= (failover=ON) (load_balance=OFF) (address=...) <= points to primary db (address=...) <= points to standby db ) (conn

Microsoft Transaction Server & Standby database problem

2002-05-17 Thread Miller, Jay
When we switch between production and standby databases our procedure is to change the DNS Name to point to the new ip address. This works perfectly for all our old Powerbuilder client/server apps. However, our connections that go through Microsoft Transaction Server as a middle tier apparently c

RE: Quick one about Standby database

2002-04-29 Thread CC Harvest
You can try. I use the XP as the primary and Win2000 as the standy database machine. It works fine. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Pablo - Usually you create the standby database by > copying all the data > files from the production system. Then it is an > id

RE: Quick one about Standby database

2002-04-29 Thread DENNIS WILLIAMS
Pablo - Usually you create the standby database by copying all the data files from the production system. Then it is an identical system, so you can apply the archive logs from production. With different systems, you couldn't copy the data files. I'm not even sure you could move the ar

Quick one about Standby database

2002-04-29 Thread Pablo ksksksk
I've read that Oracle does not advise (or may be support) to have a standby database on a plataform different to the original one. I have a database on Solaris and I'd like to create a standby for this db over HP. Can that be done? I KNOW IT'S NOT SUPPORTED. All I want to know i

Re: Standby Database-No space on Disk

2002-04-24 Thread Connor McDonald
If you are using a tempfile for tempoary tablespace on the primary, then you don't need this at all on the standby (whilst its recovering) hth connor --- Hussain Ahmed Qadri <[EMAIL PROTECTED]> wrote: > > Hello All > Oracle 8.1.7, WINNT4. > On our standby Database

Standby Database-No space on Disk

2002-04-24 Thread Hussain Ahmed Qadri
Title: Standby Database-No space on Disk Hello All Oracle 8.1.7, WINNT4. On our standby Database box, we have run out of space on the partition which was holding the Temporary tablespace. Now the problem is that when ever I try to start the recovery, it gives the message that there is no

Re: STANDBY DATABASE QUESTION?

2002-04-19 Thread Bunyamin K. Karadeniz
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 > au

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.

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
Vikas, you need to read the docs also, you can have the logs automatically shipped and applied to the standby database, it all depends on how you set it up. the docs are a wonderful thing. joe Vikas Khanna wrote: > > Original Message- > *From:* Bunyamin K.

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 s

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
yes , if you put in "maneged mode"  , archived logs are copied and applýed   to standby site from master site. - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Friday, April 19, 2002 12:03 PM Subjec

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 problem ???

2002-04-10 Thread Steve McClure
I got this error when I first set up my standby database. If you generate a log switch, and then recover again you will not see the problem. If I recall correctly, the issue arises when the redo log that was active when you created your standby control file has not been archived. If you issue

Re: ADD datafile to standby database

2002-04-10 Thread Brian_P_MacLean
cc: [EMAIL PROTECTED] Subject: ADD datafile to standby database

ADD datafile to standby database

2002-04-10 Thread Rick_Cale
Hi all, I am somewhat new to standby databases and I need to add a datafile. What exactly do I need to do or point me to some sources that clearly explains this. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Networ

RE: standby database problem ???

2002-04-09 Thread Reardon, Bruce (CALBBAY)
the database being opened. HTH, Bruce Reardon -Original Message- Sent: Wednesday, 10 April 2002 12:58 Hi, I created a primary and a standby database. Both are 9i on Win2000, the same host. Everything was fine, except the last step: SQL> RECOVER MANAGED STANDBY DATABASE TIMEOUT 20;

standby database problem ???

2002-04-09 Thread Janet Linsy
Hi, I created a primary and a standby database. Both are 9i on Win2000, the same host. Everything was fine, except the last step: SQL> RECOVER MANAGED STANDBY DATABASE TIMEOUT 20; ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was

RE: RE: License standby database?

2002-04-04 Thread Jon Baker
Title: RE: RE: License standby database? That's what I was told 2 years ago. But as we have seen, Oracle has an 'evolving' licensing standard.  Or was that 'revolving'? Jon -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tue

RE: RE: License standby database?

2002-04-03 Thread Steve McClure
We just ran the licensing gauntlett with Oracle ourselves. Our sales rep made it quite clear that if we installed the binaries we had to license it. This in response to my manager trying all concievable options to avoid licensing our standby database. I am not sure the standby has to be

RE: RE: License standby database?

2002-04-03 Thread Gene Sais
base is mounted is why you need the > license. > > > > Now, if you have a copy of all the files, and the > > executables on > > another machine, but DON'T run anything, THEN you > > don't need another > > license > > > > > > --- [EMAIL P

RE: RE: License standby database?

2002-04-03 Thread Sakthi , Raj
t; even if you don't > > use it for read-only the fact that the > > executables are running and > > the database is mounted is why you need the > license. > > > > Now, if you have a copy of all the files, and the > > executables on > >

RE: RE: License standby database?

2002-04-03 Thread Gene Sais
mounted is why you need the license. > > Now, if you have a copy of all the files, and the > executables on > another machine, but DON'T run anything, THEN you > don't need another > license > > > --- [EMAIL PROTECTED] wrote: > > Jon, > &

RE: RE: License standby database?

2002-04-03 Thread Sakthi , Raj
running and > the database is mounted is why you need the license. > > Now, if you have a copy of all the files, and the > executables on > another machine, but DON'T run anything, THEN you > don't need another > license > > > --- [EMAIL PROTECTED] wrote

RE: RE: License standby database?

2002-04-02 Thread Rachel Carmichael
> Now, if you have a copy of all the files, and the executables on > another machine, but DON'T run anything, THEN you don't need another > license > > > --- [EMAIL PROTECTED] wrote: > > Jon, > > > > Wrong. You must license the second server ident

Re:RE: RE: License standby database?

2002-04-02 Thread dgoulet
se the second server identically to the > original. The > reason is that a standby database can be used as a read only copy of > the > original. > > Dick Goulet > > Reply Separator > Author: Jon Baker <[EMAIL PROTECTED]&g

RE: RE: License standby database?

2002-04-02 Thread Post, Ethan
anything, THEN you don't need another license --- [EMAIL PROTECTED] wrote: > Jon, > > Wrong. You must license the second server identically to the > original. The > reason is that a standby database can be used as a read only copy of > the > origin

RE: RE: License standby database?

2002-04-02 Thread DENNIS WILLIAMS
You must license the second server identically to the > original. The > reason is that a standby database can be used as a read only copy of > the > original. > > Dick Goulet > > Reply Separator > Author: Jon Baker <[EMAIL PROTECTED]

Re:RE: License standby database?

2002-04-02 Thread Rachel Carmichael
DON'T run anything, THEN you don't need another license --- [EMAIL PROTECTED] wrote: > Jon, > > Wrong. You must license the second server identically to the > original. The > reason is that a standby database can be used as a read only copy of

Re:RE: License standby database?

2002-04-02 Thread dgoulet
Jon, Wrong. You must license the second server identically to the original. The reason is that a standby database can be used as a read only copy of the original. Dick Goulet Reply Separator Author: Jon Baker <[EMAIL PROTECTED]> Date:

RE: License standby database?

2002-04-02 Thread Jon Baker
Title: RE: License standby database? I believe as long as it is only stand-by, no additional licensing required.  Only one system is "functional" at a time. Jon [EMAIL PROTECTED] -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 0

License standby database?

2002-04-02 Thread DENNIS WILLIAMS
Can someone tell me - if you have a standby database, must you carry a full Oracle license on it? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network

RE: Standby Database Problem

2002-03-19 Thread Jack C. Applewhite
Title: Standby Database Problem Hussain,   As long as none of your datafiles were corrupted by what I assume was the crash of your Standby Instance, you can reinstall 8i and bring up the Standby just as you describe.  The datafiles don't care at all where Oracle Home is.   I recently h

Standby Database Problem

2002-03-18 Thread Hussain Ahmed Qadri
Title: Standby Database Problem Hi While trying to install developer6 on our standby database test server (OS NT4, Oracle 8.1.7), I have some how corrupted the 8i, and hence the standby database is not working. Its actually the Oracle Suite tools which are not working. I am going to

Re: Automated Standby Database tool for Unix & Linux

2002-03-05 Thread Joe Testa
omates the creation, maintenance, and fail-over > functions of Oracle's standby database paradigm. With > the Standby Wizard you can create an unlimited number > of exact duplicate databases from your production > database. The Standby Wizard also makes a great QA > and testing

Automated Standby Database tool for Unix & Linux

2002-03-05 Thread James Forgy
March 5, 2002: Relational Database Consultants, Inc. (RDC) - Proudly announces the release of the Standby Wizard For Unix & Linux. The Standby Wizard is a GUI interface that automates the creation, maintenance, and fail-over functions of Oracle's standby database paradigm. With the Stand

RE: Problem with standby database & listener

2002-02-21 Thread Aponte, Tony
ndert [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 21, 2002 3:59 PMTo: Multiple recipients of list ORACLE-LSubject: Problem with standby database & listener Fellow dba's,   We have come across a weird problem with a standby database. Every time we issue "alter dat

RE: Problem with standby database & listener

2002-02-21 Thread Ross Collado
ry db. Everything's scripted. Clear as mud? HTH. Ross -Original Message- Sent: Friday, 22 February 2002 7:59 To: Multiple recipients of list ORACLE-L Fellow dba's, We have come across a weird problem with a standby database. Every time we issue "alter database mount stan

Problem with standby database & listener

2002-02-21 Thread Stephen Andert
Fellow dba's,   We have come across a weird problem with a standby database. Every time we issue "alter database mount standby database" on the standby database, the primary database fails to connect through listener. It becomes OK after primary database is shutdown and

How to find current mode of standby database

2002-02-04 Thread Anand Prakash
Which dynamic performance view can provide me information whether a standby database (mounted) is in a) managed recovery mode  or b) manual recovery mode or c) just mounted.   Thanks. Anand Prakash            

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

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 lis

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 c

RE: Standby database question

2002-01-25 Thread Jeremiah Wilton
rdo wrote: > 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 nomount > &g

RE: Standby database question

2002-01-25 Thread Molina, Gerardo
. startup nomount alter database mount standby database HTH, Gerardo -Original Message- Sent: Friday, January 25, 2002 12:01 PM To: Multiple recipients of list ORACLE-L On Fri, 25 Jan 2002, [EMAIL PROTECTED] wrote: > One of the co-workers has a hot standby database. Logs are appl

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

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

Standby database foible

2002-01-24 Thread Steve McClure
Allright listers, I have been experimenting with creating a standby database for our production server. After moving all the required files files, configuring the init files, and initiating recovery on the standby instance, I saw the following error. 01547:warning RECOVER succeeded but OPEN

Re: Standby Database - Log Shipping

2001-12-12 Thread Anjan Thakuria
testing it as of now and looks good so far. HTH "Smith, Ron L." wrote: > Does anyone know where I can find a paper on how to set up a standby > database? I am talking > about a database that is always in recovery mode and archive logs are > applied throughout the >

Re: Standby Database - Log Shipping

2001-12-12 Thread Rachel Carmichael
check out metalink and search for anything by Lawrence To he's in Oracle's Center for Expertise and he concentrates on standby. his papers are fantastic -- he's my idol :) --- "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > Does anyone know where I can find

RE: Standby Database - Log Shipping

2001-12-12 Thread Baker, Barbara
Lawrence To has a couple. I believe I got both of them from metalink Oracle8i Standby Database (try 76451.1 Graceful Switchover and Switchback HTH Barb > -- > From: Smith, Ron L.[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTE

  1   2   >