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.
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
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 ,
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: STANDB
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
:[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 standby server ,What I wonder is , if I set it up
.
- Original Message -
*From:* Bunyamin K. Karadeniz mailto:[EMAIL PROTECTED]
*To:* Multiple recipients of list ORACLE-L
mailto:[EMAIL PROTECTED]
*Sent:* Friday, April 19, 2002 12:03 PM
*Subject:* STANDBY DATABASE QUESTION?
Dear Gurus ,
I
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
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
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
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.
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
--
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
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
25 matches
Mail list logo
