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 scripts
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 9iR2 SE ?
No Juan . SE also
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
No Juan . SE also has the feature but Managed Recovery
is not possible as in EE .
A metalink doc says :
quote
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
/quote
anyway i'm looking for
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:
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
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
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
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...
I
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
wisernet100@cc:
yahoo.com Subject: Re: standby database question
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
space on
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 DATABASE
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
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 something ..
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 , is the
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
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
appled to standby site from master site.
-
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.
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
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
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.
Irecently had to
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.
--
Jeremiah
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
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
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
and
There is one last, but important step.
You need to recreate standby control file...
on primary:
alter database create standby controlfile as 'file_name';
ftp this new file to standby
on standby:
shutdown immediate
copy new control file to appropriate locations with correct file name.
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
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:
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
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
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
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
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.
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
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,
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
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
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,
Title: RE: Standby Database
/begin_plug
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
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,
"sharepl
:
Sent by: Subject: Re: Standby Database
[EMAIL PROTECTED]
om
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
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,
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
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
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:(bcc:
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 primary
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: Standby
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
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
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 creating a
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
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 fine.
Joe
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 one in
: 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 oracle8i.
Also do you have any monitoring scripts developed?
I would appreciate an insight
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 /
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.com
--
57 matches
Mail list logo