. 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 have a graceful fail over
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. In either
case, there are no guarantees. If the primary site goes away in a
tornado, the redo logs and possibly
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
.
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 and no
committed
Transaction is lost in the standby database
Does
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
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 and no
committed
Transaction is lost in the standby database
Does this sound good?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
Quick question. Is it a fair statement to say that using Oracle's hot
standby database allows you recoverability up to the last archive log, but
would NOT recover to the latest redo log (prior to a log switch). In other
words, the potential to lose transactions is very high if you depend
, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
Quick question. Is it a fair statement to say that using Oracle's hot
standby database allows you recoverability up to the last archive log, but
would NOT recover to the latest redo log (prior to a log switch). In other
words, the potential
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 and no
committed
Transaction is lost
tring as sysdba'" it still asks
me for a password. What am I doing wrong.
2. This is an academic question. Am I
correct in assuming that password changes done in the production is passed
onto the standby database.
3. I try to logon to the standby database locally
as follows
sqlplus 'sys
. Am I correct in assuming that
password changes done in the production is passed onto the standby
database.
3.I try to logon to the standby database locally as follows
sqlplus 'sys as sysdba' and get the following.. ORA-01033 Oracle
initialization or shutdown in progress
Any help
. Perform an alter database activate standby database on the standby --
simple script using svrmgrl on a unix box.
5. Apply the logs -- Recover database command
6. Shut down the listener -- lsnrctl stop
7. Copy in the new listener configuration files so that users are now
pointing to the standby
Dear gurus !
I'm about to implement Oracle standby database using oracle 8.0.5 .
I need automatic switchover in case of primary site failure , i.e. i need
the standby (secondary) database to get opened automatically should the
primary site fail.
Is there a way to achieve this ?
I know
recipients of list ORACLE-L
Dear gurus !
I'm about to implement Oracle standby database using oracle 8.0.5 .
I need automatic switchover in case of primary site failure , i.e. i need
the standby (secondary) database to get opened automatically should the
primary site fail.
Is there a way
12:50 PM
To: Multiple recipients of list ORACLE-L
Dear gurus !
I'm about to implement Oracle standby database using oracle 8.0.5 .
I need automatic switchover in case of primary site failure , i.e. i need
the standby (secondary) database to get opened automatically should the
primary site fail
same process
you are using now or a seperate script.
4. Perform an alter database activate standby database on the standby --
simple script using svrmgrl on a unix box.
5. Apply the logs -- Recover database command
6. Shut down the listener -- lsnrctl stop
7. Copy in the new listener configuration
Title: RE: switchover with standby database
I would simplify step #7 by adding a second ADDRESS entry in the tnsnames.ora file. Below is a snippet of one of our tnsnames.ora file that could be used for automating the re-pointing of the users. Actually, it's more of a silent redirection than
, 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
site and if that's
-L [EMAIL PROTECTED]
Subject: Standby database
Date: Mon, 03 Sep 2001 08:45:24 -0800
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
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
site and if that's not responding try the standby site. Oracle
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
database
Date: Mon, 03 Sep 2001 08:45:24 -0800
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
site and if that's
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
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
Just wondering if anyone sees any problems with creating a second instance
and DB on a standby database server that would be used for reporting
querying against a small dataset??? Running the standby DB in read only
mode is not an option since I'm applying archived logs every 10 minutes
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 wit
To: Multiple recipients of list ORACLE-L
Just wondering if anyone sees any problems with creating a second instance
and DB on a standby database server that would be used for reporting
querying against a small dataset??? Running the standby DB in read only
mode is not an option since I'm applying
I need to implement the
standby database for the Txn. Proc. Prod. system. I have a few doubts. If the
failure/disaster happens to prod DB, and can't open the DB, then How to transfer
the contents of online logs to standby database? My logs would switch once every
hour, and so, I would lose
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 production.
Thanks,
Lisa
_
Get
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
: 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
On Jun 13, 2001 at 01:05:45PM, Kevin Lange wrote:
Trouble is its the Databae that generated the corrupt log, its not the
transfer between file-systems. It would not help if we generated checksums
on the files before and after transport.
On 8.0.5 you can use dbv to check the archived log
Has anyone heard of Oracle corrupting the Archive Logs when the Archive Area
fills up ??
After we clean up the space issue we try and bring the standby up to date.
Here is the message we get when trying to recover the Standby Database:
SVRMGR recover automatic standby database until cancel
, 2001 3:07 PM
To: Multiple recipients of list ORACLE-L
Disk
Has anyone heard of Oracle corrupting the Archive Logs when the Archive Area
fills up ??
After we clean up the space issue we try and bring the standby up to date.
Here is the message we get when trying to recover the Standby Database
the Standby Database:
SVRMGR recover automatic standby database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 3328 change 3854699 time 06/13/01
07:37:33
ORA-00334: archived log: '/u09/app/oracle/admin/ENCP
hi all,
I need ur help urgently. i've
created a standby database with the below mentioned steps..
1. copied consistent backup of
datafiles folder to standby site.
2. created standby control file and
sent to target location.
3. switch logfile current and
copied to target.
4. copied
Actually there may be no problem at all. Your standby
database might be up to date, the last available archive log file has been
applied to your standby database and Oracle tried to apply the next archive log
file 'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001 and did not find it, since
you
has log 505 made it over to the standby yet, you should start reading
the docs, if log 505 is not there yet, than that is the way its SUPPOSED
to work.
joe
Saurabh Sharma wrote:
hi all,
I need ur help urgently. i've created a standby database with the
below mentioned steps..
1. copied
e-From: Saurabh Sharma
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 06, 2001 3:21
AMTo: Multiple recipients of list ORACLE-LSubject:
Trouble.. Standby Database. Urgent!!
hi all,
I need ur help urgently. i've
created a standby database with the below mentioned steps..
Check the size of the archive log which it complains on primary.I have seen situation when the log has transmitted partially and the recovery comes to a standstill.
After getting all the archives properly, run a
recover automatic standby database;
then try to put it in managed recovery mode.
HTH
Suggestions anyone?? I'm attempting to get a standby database to run in
managed recovery mode, so that the archived logs
are automatically applied, however, when running the command 'recover
managed standby database' I receive the following error message:
SVRMGR recover managed standby
Suggestions anyone?? I'm attempting to get a standby database to run in
managed recovery mode, so that the archived logs
are automatically applied, however, when running the command 'recover
managed standby database' I receive the following error message:
SVRMGR recover managed standby database
Has anyone tried to use their standby database as a read-only database
through db links and mapped to synonyms? I'm having problems creating one
(12145 e.g.) and am now wondering whether it is even possible. This is to
alleviate the downtime in the event of single table failures
Hi ;
I have to put a copy of database in "standby" mode, under Ora 7.3 ,
Soalris, with 100GB size.
Anybody know some tips to share, or some tool like "Shareplex" , useful to
replicate the DB
ant ready to use on-line.
Thanks in advance.
Daniel.
æ¬zǶ¨}ø©ND ±@Bm§ÿðÃ
Hi all;
I have to put a database with a secondary standby database (Ora 7.3
,Solaris , size:100 GB ).
Anybody know some tips to share ? And :Anybody know some other tool like
"SharePlex", useful to
replicate the database ?
Thanks in advance .
Daniel
W±ëzØ^¡÷âr¥9
Hello all,
We are planning to create a standby database on another machine. I was going
through metalink documents was unable to find how i will keep it
consistent. What my question is, do i only have to copy the archived log
files generated from production db to standby db apply them
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
Why donot you use transportable tablespace concept. If you need more about
it let me know .
--Neena
Larry Taylor wrote:
Can anyone tell me which would be better to use for copy a 12 gig schema
from one 8.1.6 database to any 8.1.6 database, Standby-Database or
Replication?
I tried
, Standby-Database or
Replication?
I tried to export/import, I lost data and constraints. So now I'm
considering
replication or standby database.
Do you have a good solution?
Thanks in advance.
Larry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Larry Taylor
INET
101 - 154 of 154 matches
Mail list logo