8i standby database: Read Only? 
Author Message
 8i standby database: Read Only?

Is the archive destination specifying the
network service a Mandatory destination,
or is the min_succeed_dest set so that
the network destination has to succeed ?

I had a lot of trouble with managed standbys
on an 81.5 system when anything caused a
temporary stoppage, and had to restart things
manually.

Fortunately all the log_archive bits and pieces
can be set using:  'alter system set ...' so it
was usually possible to get things up again
without bouncing the primary database.

The most important change I made was to
set the networkservice as an optional destination.

--

Jonathan Lewis
Yet another Oracle-related web site:   http://www.***.com/

Practical Oracle 8i:  Building Efficient Databases

Publishers:                 Addison Wesley Longman
Book bound date:     8th Dec 2000
See a first review at:
http://www.***.com/ #practical_8i

Hello,

now I've got an other question about standby databases with oracle
8.1.6.
The docs specify that the managed standby database can be set in
read-only modus, so it can be used for reports. The docs specify that
the
standby DB can be reset to standby without shutting down. But if we set
the read-only (ex-standby) DB back to managed standby, the primary
DB cannot send any redologs to the standby DB. following error occurs
(reproducable) at primary site:
    Thu Nov 16 15:39:42 2000
    ARC1: Beginning to archive log# 3 seq# 288
    Thu Nov 16 15:39:42 2000
      Current log# 2 seq# 289 mem# 0:
/platte3/oracle8/oradata/o8i_desd/oradata/oi81
    6/redo02.log
    Thu Nov 16 15:39:42 2000
    ARC1: RFS network connection lost at host 'oi816sby.class'
    ARC1: Error 3113 creating standby archivelog file at host
'oi816sby.class'
    ARC1: Error 3113 creating archivelog file 'oi816sby.class'
    ARC1: Failed to archive log# 3 seq# 288
    ARCH: Archival stopped, error occurred. Will continue retrying
    Thu Nov 16 15:39:42 2000
    ORACLE Instance desd - Archival Error
    ARCH: Connecting to console port...
    Thu Nov 16 15:39:43 2000
    ORA-16038: log 3 sequence# 288 cannot be archived
    ORA-00000: normal, successful completion
    ORA-00312: online log 3 thread 1:
'/platte3/oracle8/oradata/o8i_desd/oradata/oi8
    16/redo01.log'
    ARCH: Connecting to console port...
    ARCH:
    ORA-16038: log 3 sequence# 288 cannot be archived
    ORA-00000: normal, successful completion
    ORA-00312: online log 3 thread 1:
'/platte3/oracle8/oradata/o8i_desd/oradata/oi8
    16/redo01.log'
or:
    Thu Nov 16 14:09:38 2000
    ARCH: Beginning to archive log# 3 seq# 207
    ARCH: Error 16040 creating standby archivelog file at host
'oi816sby.class'
    ARCH: Error 16040 creating archivelog file 'oi816sby.class'
    ARCH: Archiving not possible: error count exceeded
    ARCH: Failed to archive log# 3 seq# 207
    ORA-16014 signalled during: alter database open
    ...
at the standy site the following error occurs:
    Thu Nov 16 14:09:37 2000
    RFS: file locked log# 3 seq# 207 thrd# 1
    RFS: Forced Shutdown due to RFS_ERROR state
    Thu Nov 16 14:10:17 2000
    Media Recovery terminated with status 1013
    ORA-283 signalled during: ALTER DATABASE RECOVER   managed standby
database
    ...

Does there exist any method to switch back from read-only (standby) to
managed standby?

regards,
Andreas Boehm



Wed, 18 Jun 1902 08:00:00 GMT
 8i standby database: Read Only?

The first destination is mandatory. You can also define secondary
destination. In this case, min_succeed_dest is set to 1 if you want
primary destination to succeed and 2 if you want both to succeed. But
archiving to primary destination always has to succeed.



Quote:

> Is the archive destination specifying the
> network service a Mandatory destination,
> or is the min_succeed_dest set so that
> the network destination has to succeed ?

> I had a lot of trouble with managed standbys
> on an 81.5 system when anything caused a
> temporary stoppage, and had to restart things
> manually.

> Fortunately all the log_archive bits and pieces
> can be set using:  'alter system set ...' so it
> was usually possible to get things up again
> without bouncing the primary database.

> The most important change I made was to
> set the networkservice as an optional destination.

> --

> Jonathan Lewis
> Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

> Practical Oracle 8i:  Building Efficient Databases

> Publishers:                 Addison Wesley Longman
> Book bound date:     8th Dec 2000
> See a first review at:
> http://www.ixora.com.au/resources/index.htm#practical_8i


> Hello,

> now I've got an other question about standby databases with oracle
> 8.1.6.
> The docs specify that the managed standby database can be set in
> read-only modus, so it can be used for reports. The docs specify that
> the
> standby DB can be reset to standby without shutting down. But if we set
> the read-only (ex-standby) DB back to managed standby, the primary
> DB cannot send any redologs to the standby DB. following error occurs
> (reproducable) at primary site:
>     Thu Nov 16 15:39:42 2000
>     ARC1: Beginning to archive log# 3 seq# 288
>     Thu Nov 16 15:39:42 2000
>       Current log# 2 seq# 289 mem# 0:
> /platte3/oracle8/oradata/o8i_desd/oradata/oi81
>     6/redo02.log
>     Thu Nov 16 15:39:42 2000
>     ARC1: RFS network connection lost at host 'oi816sby.class'
>     ARC1: Error 3113 creating standby archivelog file at host
> 'oi816sby.class'
>     ARC1: Error 3113 creating archivelog file 'oi816sby.class'
>     ARC1: Failed to archive log# 3 seq# 288
>     ARCH: Archival stopped, error occurred. Will continue retrying
>     Thu Nov 16 15:39:42 2000
>     ORACLE Instance desd - Archival Error
>     ARCH: Connecting to console port...
>     Thu Nov 16 15:39:43 2000
>     ORA-16038: log 3 sequence# 288 cannot be archived
>     ORA-00000: normal, successful completion
>     ORA-00312: online log 3 thread 1:
> '/platte3/oracle8/oradata/o8i_desd/oradata/oi8
>     16/redo01.log'
>     ARCH: Connecting to console port...
>     ARCH:
>     ORA-16038: log 3 sequence# 288 cannot be archived
>     ORA-00000: normal, successful completion
>     ORA-00312: online log 3 thread 1:
> '/platte3/oracle8/oradata/o8i_desd/oradata/oi8
>     16/redo01.log'
> or:
>     Thu Nov 16 14:09:38 2000
>     ARCH: Beginning to archive log# 3 seq# 207
>     ARCH: Error 16040 creating standby archivelog file at host
> 'oi816sby.class'
>     ARCH: Error 16040 creating archivelog file 'oi816sby.class'
>     ARCH: Archiving not possible: error count exceeded
>     ARCH: Failed to archive log# 3 seq# 207
>     ORA-16014 signalled during: alter database open
>     ...
> at the standy site the following error occurs:
>     Thu Nov 16 14:09:37 2000
>     RFS: file locked log# 3 seq# 207 thrd# 1
>     RFS: Forced Shutdown due to RFS_ERROR state
>     Thu Nov 16 14:10:17 2000
>     Media Recovery terminated with status 1013
>     ORA-283 signalled during: ALTER DATABASE RECOVER   managed standby
> database
>     ...

> Does there exist any method to switch back from read-only (standby) to
> managed standby?

> regards,
> Andreas Boehm

Sent via Deja.com http://www.deja.com/
Before you buy.


Wed, 18 Jun 1902 08:00:00 GMT
 8i standby database: Read Only?
Not true in 8.1.5 if you are using the new log_archive_dest_n
parameters -all default to being optional destinations, and you have to
specifically remember to make them mandatory.  What's worse, even a
mandatory can be set to be 'deferred' -so you end up not archiving anywhere.

What you state is perfectly true for all earlier versions of Oracle, and is
also true for 8.1.5 if using the old log_archive_dest and
log_archive_duplex_dest parameters (log_archive_dest is considered as
defaulting to mandatory).

And of course the managed stanndby feature requires the use of the new
parameters.

Regards
HJR
--
---------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
---------------------------------------------------------------------------


Quote:
> The first destination is mandatory. You can also define secondary
> destination. In this case, min_succeed_dest is set to 1 if you want
> primary destination to succeed and 2 if you want both to succeed. But
> archiving to primary destination always has to succeed.



> > Is the archive destination specifying the
> > network service a Mandatory destination,
> > or is the min_succeed_dest set so that
> > the network destination has to succeed ?

> > I had a lot of trouble with managed standbys
> > on an 81.5 system when anything caused a
> > temporary stoppage, and had to restart things
> > manually.

> > Fortunately all the log_archive bits and pieces
> > can be set using:  'alter system set ...' so it
> > was usually possible to get things up again
> > without bouncing the primary database.

> > The most important change I made was to
> > set the networkservice as an optional destination.

> > --

> > Jonathan Lewis
> > Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

> > Practical Oracle 8i:  Building Efficient Databases

> > Publishers:                 Addison Wesley Longman
> > Book bound date:     8th Dec 2000
> > See a first review at:
> > http://www.ixora.com.au/resources/index.htm#practical_8i


> > Hello,

> > now I've got an other question about standby databases with oracle
> > 8.1.6.
> > The docs specify that the managed standby database can be set in
> > read-only modus, so it can be used for reports. The docs specify that
> > the
> > standby DB can be reset to standby without shutting down. But if we set
> > the read-only (ex-standby) DB back to managed standby, the primary
> > DB cannot send any redologs to the standby DB. following error occurs
> > (reproducable) at primary site:
> >     Thu Nov 16 15:39:42 2000
> >     ARC1: Beginning to archive log# 3 seq# 288
> >     Thu Nov 16 15:39:42 2000
> >       Current log# 2 seq# 289 mem# 0:
> > /platte3/oracle8/oradata/o8i_desd/oradata/oi81
> >     6/redo02.log
> >     Thu Nov 16 15:39:42 2000
> >     ARC1: RFS network connection lost at host 'oi816sby.class'
> >     ARC1: Error 3113 creating standby archivelog file at host
> > 'oi816sby.class'
> >     ARC1: Error 3113 creating archivelog file 'oi816sby.class'
> >     ARC1: Failed to archive log# 3 seq# 288
> >     ARCH: Archival stopped, error occurred. Will continue retrying
> >     Thu Nov 16 15:39:42 2000
> >     ORACLE Instance desd - Archival Error
> >     ARCH: Connecting to console port...
> >     Thu Nov 16 15:39:43 2000
> >     ORA-16038: log 3 sequence# 288 cannot be archived
> >     ORA-00000: normal, successful completion
> >     ORA-00312: online log 3 thread 1:
> > '/platte3/oracle8/oradata/o8i_desd/oradata/oi8
> >     16/redo01.log'
> >     ARCH: Connecting to console port...
> >     ARCH:
> >     ORA-16038: log 3 sequence# 288 cannot be archived
> >     ORA-00000: normal, successful completion
> >     ORA-00312: online log 3 thread 1:
> > '/platte3/oracle8/oradata/o8i_desd/oradata/oi8
> >     16/redo01.log'
> > or:
> >     Thu Nov 16 14:09:38 2000
> >     ARCH: Beginning to archive log# 3 seq# 207
> >     ARCH: Error 16040 creating standby archivelog file at host
> > 'oi816sby.class'
> >     ARCH: Error 16040 creating archivelog file 'oi816sby.class'
> >     ARCH: Archiving not possible: error count exceeded
> >     ARCH: Failed to archive log# 3 seq# 207
> >     ORA-16014 signalled during: alter database open
> >     ...
> > at the standy site the following error occurs:
> >     Thu Nov 16 14:09:37 2000
> >     RFS: file locked log# 3 seq# 207 thrd# 1
> >     RFS: Forced Shutdown due to RFS_ERROR state
> >     Thu Nov 16 14:10:17 2000
> >     Media Recovery terminated with status 1013
> >     ORA-283 signalled during: ALTER DATABASE RECOVER   managed standby
> > database
> >     ...

> > Does there exist any method to switch back from read-only (standby) to
> > managed standby?

> > regards,
> > Andreas Boehm

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Tue, 06 May 2003 09:35:11 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. PLEASE HELP: ORACLE 8i STANDBY DATABASE

2. 8i Standby database BUG ( anybody Help )

3. 8i on NT: FailSafe versus Standby Database

4. Managed Standby Database on 8i Standard

5. Backup a Read Only/Standby Database

6. Standby database setup - Primary SQL7 SP2 Standby SQL2k.

7. Managed Standby message in 8i

8. Oracle 8i Standby Complete Recovery

9. Standby Oracle 8i server as report server - Error!

10. 8i standby question

11. Current SCN in Redo, 8i Standby DB


 
Powered by phpBB® Forum Software