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
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
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 is written in the log files.
The partially filled log file can be shipped to the standby location and
you can
open the standby
edo 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 is written in the log files.
The partially filled log file can be shi
y 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 this sound good?
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
CCCP 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 and no
committed
Transa
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
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. In either
case, there are no guarantees. If the primary site goes away in a
tornado, the redo lo
. 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 in
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 h
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
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 in
, 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 pote
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 depe
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
7;"sys/password@connect_string 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 loca
ipt.
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 files so that users
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 redire
t; Use your 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.
2001 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 sit
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 w
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 that
PROTECTED]
>To: Multiple recipients of list ORACLE-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 datab
EY/NL)
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
D]>
>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
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
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 si
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
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 fin
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
0:28 AM
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&
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 a
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
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/he
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
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 l
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/ad
, 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
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 can
riginal Message-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 menti
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 m
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
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. c
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 data
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 m
> 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
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> recov
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 failur
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§ÿðÃ
+iöªrºØh¬6§
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&a
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
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 /
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 FA
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 here
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?
>
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 to export/import, I lost data and constraints. So now I'm
considering
replication or standby database.
Do you have a good solution?
Thanks
CLE-L
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 to export/import, I lost data and constraints. So now I'm
considering
replication or standby database.
Do you have a good
Sent: Wednesday, January 31, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L
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 to export/import, I lost data and constraints. So now I&#
ORACLE-L
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 to export/import, I lost data and constraints. So now I'm
considering
replication or standby database.
Do you have a g
Ji
-Original Message-
Taylor
Sent: Wednesday, January 31, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L
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 to
8.1.6 database to any 8.1.6 database, 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.or
CLE-L
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 to export/import, I lost data and constraints. So now I'm
considering
replication or standby database.
Do you have a goo
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 to export/import, I lost data and constraints. So now I'm
considering
replication or standby database.
Do you have a good sol
101 - 168 of 168 matches
Mail list logo
