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
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
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
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
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
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
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 implying 9i
tions 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,Indy
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, so
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 [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 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
: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
standby database until a switch log occurs...
(thinking about sustained mode too)
Have you taken that into account??
JL
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 your physical datafile remain
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 primary database
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 recovering
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
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
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 have
sequence gaps
-
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
recovery mode. NET8 have been transferring logs untill
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
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
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
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 remove the files;
3. Record the max(sequence
Managed Standby
Database Archive Logs
12/12/2002 10:04
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't been
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)
When you execute the following
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 DATABASE
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 maintain
--
[...]
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 STANDBY
DATABASE command but is unable to provide a means to implement it without
requiring the terminal session to remain
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 DATABASE
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
[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 find anything about doing managed recovery with out
having
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've
not been able to find anything about doing managed
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 recover managed standby database
-
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.
other than the whole possibility of losing data during a failover, i've
not been able to find anything about
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 the recovery. But
then, one
/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
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
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 Williams
DBA
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
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
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
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 our
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
prod = (description=
(address_list=
(failover=ON)
(load_balance=OFF)
(address=...) = points to primary db
(address=...) = points to standby db
)
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 is if anyone has
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 archive logs
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
identical system, so you
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
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
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
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
.
- 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
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 archive log files automatically copied to standby
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
:
[EMAIL PROTECTED] Subject: ADD datafile to standby database
om
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
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 not restored
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: Tuesday, April 02, 2002 9:48
, but 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
the
original.
Dick Goulet
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
original.
Dick Goulet
Reply
. 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: 4/2/2002 8:03 AM
I believe as long as it is only stand
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 02, 2002 10:28
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: 4/2/2002
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
original.
Dick Goulet
Reply
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: 4/2/2002 8:03 AM
I believe as long as it is only stand
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
original.
Dick Goulet
Reply
. 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: 4/2/2002 8:03 AM
I believe as long as it is only stand-by, no additional licensing
:
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
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
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
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 Standby Wizard
, 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 tool with its ability to duplicate even
the most
Fellow dba's,
We have come across a weird problem with a standby database.
Every timewe issue "alter database mount standby database"on
thestandby database, the primary database fails to connect through
listener. It becomes OK after primary database is shutdown and restarted
. 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 standby database
:[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 timewe issue "alter database mount standby dat
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
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
.
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 applied
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
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
day to keep it up to date.
Thanks!
Ron Smith
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
December 2001 16:16
To: Multiple recipients of list ORACLE-L
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
day to keep it up to date.
Thanks!
Ron Smith
--
Please
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
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
day to keep it up to date.
Thanks
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 is written in the log files.
The partially filled log file can be shipped to the standby location and
you can
open the standby database with the new
the log files without locking. You can use the fixed
table X$KCCLE and X$KCCCP to find how much is written in the log files.
The partially filled log file can be shipped to the standby location and
you can
open the standby database with the new control file created with NORESETLOGs
.
In this way you
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
$KCCLE and X$KCCCP to find how much is written in the log files.
The partially filled log file can be shipped to the standby location and
you can
open the standby database with the new control file created with NORESETLOGs
..
In this way you have a graceful fail over in the standby database
1 - 100 of 154 matches
Mail list logo