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.
I have some shell scrip
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
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 looking for "manual re
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 so
Hi!
I think archive log gap management is a new feature in 9i Data Guard. Check
9i's docs. You might have to build custom scripts for gap management in 8i.
Also, I recommend you to use documentation from authentic location,
http://tahiti.oracle.com
Tanel.
- Original Message -
To: "Multi
Carmichael To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subject: Re: standby database question.
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...
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
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
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
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 box, we have run out of
> sp
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
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
Arslan, not exactly managed mode applies the logs, you need to setup the
primary init.ora to have the shipped from primary site to standby site.
joe
Arslan Bahar wrote:
> yes , if you put in "maneged mode" , archived logs are copied and
> applıed to standby site from master site.
>
>
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. Karadeniz [mailto
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 ,
>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
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
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
Subject: STANDBY DATABAS
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 a
Janet,
I have found that on NT a shutdown immediate can still lead to recovery being required
when the database is started back up.
That is, maybe you didn't really have a consistent cold backup of your primary.
I have instead opted for a shutdown immediate, startup, shutdown normal sequence to
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 had to r
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
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
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
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
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
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
Ron,
There is an excellent paper on how to set it up step-by-step for managed
recovery (logs applied automatically) on metalink. I like to follow these
to start with and read the manual for details.
They are 149286.1, 97010.1, 120855.1, 67488.1 etc. to start with.
Also consieder dataguard I am
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 a paper on how to set up a standby
>
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 PROTECTED]
> Sent: Wedn
Metalink Note : 120855.1
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018
-Original Message-
Sent: 12 Decembe
Richard,
You are right. It is close to Zero data loss. Not exactly Zero Data loss.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Friday, November 30, 2001 6:45 AM
To: Multiple recipients of list ORACLE-L
Kay, thanks for the explanation. Sorry for being a pa
Kay, thanks for the explanation. Sorry for being a pain in butt. But I see
that the C program will write IMMEDIATELY AS SOON AS the log is written.
But this is not the same as doing it simultaneously. So there is a chance (very very
small of course) that after LGWR writes the committed transac
Richard,
Comments inline..
-Original Message-
Sent: Thursday, November 29, 2001 6:40 AM
To: Multiple recipients of list ORACLE-L
This sounds good, but I have a couple of questions. How do you guarantee
that
you won't lose any committed transactions? I mean, the C program could lag
b
naman"
.com>cc:
Sent by: Subject: Re: Sta
Title: RE: Standby Database
Shareplex is a great tool, i have heard anecdotally. Of course, it
ain't cheap, either.
Both
facts need to be addressed.
Is
there any interest in sharing that kind of sales information? For, say, a Sun
6500, 12 processors, 8GB RAM,
"sharep
Title: RE: Standby Database
I usually don't do these kind of posts... but I've seen a lot of activity on this topic lately.
What is really the problem we are trying to solve here? Maybe we are using the wrong tool.
If you are looking for data protection in the event of
This sounds good, but I have a couple of questions. How do you guarantee that
you won't lose any committed transactions? I mean, the C program could lag behind
the LGWR since it's only reading it without lock and it's copying the online redo over
to a remote machine. So for a busy database, the
Ditto this. Pretty much exactly what I suspected, but I was certain someone
here had dealt with this already and might have better insight.
Thanks,
Ed
- Original Message -
> Excellent post Don!
>
> This one's going straight in to my "special" folder :P
--
Please see the official O
Excellent post Don!
This one's going straight in to my "special" folder :P
-Original Message-
Granaman
Sent: 29 November 2001 08:05
To: Multiple recipients of list ORACLE-L
Quick question, long answer...
You are not only making sense, you have hit the primary issue with the
Oracle sta
There may be some solutions available at the hardware level as well..
For example-SRDF on an EMC cabinet... and define the online redo
logs/archive logs as part of the data transfer.. But there are performance
problems with that as well.
greg
-Original Message-
Sent: Thursday, Novem
K Gopalakrishnan wrote:
>
> If you want to Zero data loss in standby you can copy the online redo logs
> thru an external C program. You can copy the online redo log files when
> the LGWR is writing to it.
>
> The program should read the log files without locking. You can use the fixed
> table
Quick question, long answer...
You are not only making sense, you have hit the primary issue with the
Oracle standby database directly on the head. With DataGuard in 9i
(or 8i on HP-UX or Solaris only), you can *try* to retrieve redo log
files. You could also do it manually - with any version.
If you want to Zero data loss in standby you can copy the online redo logs
thru an external C program. You can copy the online redo log files when
the LGWR is writing to it.
The program should read the log files without locking. You can use the fixed
table X$KCCLE and X$KCCCP to find how much
I am also facing the same problem. All these disadvantages in 8i standby DB
have been taken care of in oracle 9i version. The other solution could be to
buy an expensive Veritas Cluster server/Database edition.
Thanks,
-- Janardhana babu
-Original Message-
Sent: Wednesday, November 28, 2
Jack
Hadn't thought of that yet. Thanks
That'll do the trick for us.
Jack
"Rachel Carmichael" <[EMAIL PROTECTED]>@fatcity.com on 04-09-2001
00:36:47
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(
Hi
I forgot to mention that the database I'm to create the standby for is not
alone on this machine. IP-switching is therefore not an option (I'm not
doing standby for the whole system). We are currently using HACMP with EMC
but this is giving us much grieve (UNIX people anyway) so they want to
Well, you can configure the tnsnames.ora to check multiple listeners, so you
do that... the first listener/port you check is the primary, the second is
the standby
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: St
On Mon, Sep 03, 2001 at 08:45:24AM -0800, [EMAIL PROTECTED] wrote:
>
>
> Hi All,
>
>
> I'm resaerching standby database on 8.0.5 here and have a question.
> Setting up the standby database is quite well documented, but how to
> configure the clients in such a way that they will first try the p
Nope u do not have to copy the online redologfiles to the standby, this has
to be done only in the case of switch over from production to the standby
database.
The online redos are only read when the database is getting opened it will
not be read during recovery until and unless u specify the onli
I was able to configure the standby database.I am not clear about the redo
log files.Oracle
Standby database creation dod doesn't talk of moving the redo log files.Do
we have to move
the redo log files from the primary database to the standby database.But the
standby database
iw working fine and i
ly 06, 2001 9:46
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Standby Database
Rich, no problems other than, the "performance" issue, if
they are hitting it hard and oracle lags in trying to post the logs to the
standby database.
other than that it should be
Richard,
As long as the 2nd instance doesn't interfere with the application of
archived redo logs to the standby, I don't see a problem.
I routinely use the extra CPU available on our standby server (Win2K) to zip
up exports from production and other, similar tasks that would otherwise put
extra
Rich, no problems other than, the "performance" issue, if they
are hitting it hard and oracle lags in trying to post the logs to the standby
database.
other than that it should be fine.
Joe
>>> [EMAIL PROTECTED] 07/06/01 11:27AM
>>>Just wondering if anyone sees any problems with creatin
CLE-L
> Subject: Re: Standby database
>
> Lisa, did one for 8.1.5, what are you wanting to monitor?
>
> joe
>
>
>
> >>> [EMAIL PROTECTED] 07/03/01 09:41AM >>>
> Hi List,
>
> I would like to know if anyone has setup standby database in
Lisa, did one for 8.1.5, what are you wanting to
monitor?
joe
>>> [EMAIL PROTECTED] 07/03/01 09:41AM >>>Hi
List,I would like to know if anyone has setup standby database in
oracle8i.Also do you have any monitoring scripts developed?I would
appreciate an insight/help since I need to setup
What is your standby_archive_dest set to? can u show us the params from the
init.ora
> -Original Message-
> From: Richard Huntley [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 03, 2001 10:21 AM
> To: Multiple recipients of list ORACLE-L
> Subject: FW: standby database in managed recove
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
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 /
60 matches
Mail list logo