Re: Oracle Standby.

2004-01-10 Thread Gudmundur Josepsson
> Does anybody have any good resources (links/whitepapers) on setting up, > managing and monitoring an Oracle Standby environment? I found Oracle Backup & Recovery 101 by Stephan Haisley and Kenny Smith to be useful. Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- A

RE: Oracle Standby.

2004-01-09 Thread Paul Drake
--- "Shrake, Jolene" <[EMAIL PROTECTED]> wrote: > There are good documents on Metalink (one in > particular by Lawrence To). > The Oracle RDBMS manuals are informative as well. > > I run a script bat file on Windows on the primary to > transfer the logs > every half hour to the secondary. And a

Re: Oracle Standby.

2004-01-09 Thread Jose Luis Delgado
Hi Mark... I have a good one... if you wanna copy email me off-list... Regards! JL --- Mark Leith <[EMAIL PROTECTED]> wrote: > Hi All, > > Does anybody have any good resources > (links/whitepapers) on setting up, > managing and monitoring an Oracle Standby > environment? > > It will be a windo

RE: Oracle Standby.

2004-01-09 Thread Mark Leith
Thanks, I've grabbed the whitepaper by Lawrence To (from http://otn.oracle.com/deploy/availability/pdf/stby8i_twp.pdf if anyone is interested). I'll take that home for bed time reading ;) If I have any more specific questions I'll give you all a shout again! ;) Many thanks Mark -Original M

RE: Oracle Standby.

2004-01-09 Thread Shrake, Jolene
There are good documents on Metalink (one in particular by Lawrence To). The Oracle RDBMS manuals are informative as well. I run a script bat file on Windows on the primary to transfer the logs every half hour to the secondary. And a bat file once a day on the secondary to apply the logs. I use

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 is not po

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 different ver

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
ject: Re: Oracle Standby Database Backups.   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

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 PROTECTED]> wrote: > Arup, >

RE: Oracle Standby Database Backups.

2003-09-04 Thread Jose Luis Delgado
Tom it's me again... I have a (I consider) really good document about stand by databases... (old, maybe, but still applies to 8i standby databases)... if you are interested... I can send you a copy... it focuses about the 'details' with theses databases... HTH JL --- "Mercadante, Thomas F"

RE: Oracle Standby Database Backups.

2003-09-04 Thread Mercadante, Thomas F
Jose, I've taken nothing into account. I'm still asking theoretical questions, trying to prepare for a discussion I will be having this afternoon. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, September 04, 2003 11:29 AM To: Multiple recipients of list

RE: Oracle Standby Database Backups.

2003-09-04 Thread Mercadante, Thomas F
PMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle Standby Database Backups. 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

Re: Oracle Standby Database Backups.

2003-09-03 Thread Indy Johal
ECTED]> Sent by: [EMAIL PROTECTED] 09/03/03 03:04 PM Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        Re: Oracle Standby Database Backups. Tom,   You should perform backups from th

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 docs have been kind

RE: Oracle standby strange behavior

2002-02-01 Thread Yuval Arnon
: Vadim Gorbounov [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 30, 2002 2:26 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle standby strange behavior Hi, Yuval. Did you make sure, you've got latest data transferred and applied? I bet, these two tables

RE: Oracle standby strange behavior

2002-01-30 Thread Yuval Arnon
lto:[EMAIL PROTECTED]]Sent: Wednesday, January 30, 2002 2:26 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle standby strange behavior Hi, Yuval. Did you make sure, you've got latest data transferred and applied? I bet, these two tables have largest OBJECT_ID in

RE: Oracle standby strange behavior

2002-01-30 Thread Vadim Gorbounov
Title: Oracle standby strange behavior Hi, Yuval. Did you make sure, you've got latest data transferred and applied? I bet, these two tables have largest OBJECT_ID in the original DB.   Before you activate standby, do 1. On production   SQL> alter system switch logfile;   2. Transfer all a