Re: standby database question.
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 can always create a shell script, and run it in the background
with nohup, assuming you are on Unix.
The latest issue of Ora Magazine has a good write up on standby database in
9i, and the FAL (Is that the name?) process.
Raj
The oramag also mentiones Carl Dudley to be the DBA of the year, and also
features x$ Gopal.
Rachel
Carmichael To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subject: Re: standby database question.
Sent by:
root@fatcity.
com
October 23,
2002 12:49 PM
Please
respond to
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 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 recovery with out
> having a dedicated session to put the database in managed recovery
> mode.
>
> SQL> recover managed standby database;
>
>
> this does not fork into the background but is a foreground process,
> that
> ties that window up as it receives and applies logs, that is correct
> right?
>
> Its not until 9i where we get the luxury of managed recovery being a
> background proces, right?
>
> thanks, joe
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Testa
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
Re: standby database question.
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 accomplish this with the gnu screen command. It is a pretty nice addon that lets you detach/reattach/multiplex tty sessions. I use this alot for long running commands and what to go home and check on them later. http://www.gnu.org/software/screen/screen.html > - Original Message - > 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 doing managed recovery with out > > having a dedicated session to put the database in managed recovery mode. > > > > SQL> recover managed standby database; > > > > > > this does not fork into the background but is a foreground process, that > > ties that window up as it receives and applies logs, that is correct > > right? > > > > Its not until 9i where we get the luxury of managed recovery being a > > background proces, right? > > > > thanks, joe > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Joe Testa > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tim Gorman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: standby database question.
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 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 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 recovery with out having a dedicated session to put the database in managed recovery mode. SQL> recover managed standby database; this does not fork into the background but is a foreground process, that ties that window up as it receives and applies logs, that is correct right? Its not until 9i where we get the luxury of managed recovery being a background proces, right? thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: standby database question.
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 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 recovery with out > having a dedicated session to put the database in managed recovery > mode. > > SQL> recover managed standby database; > > > this does not fork into the background but is a foreground process, > that > ties that window up as it receives and applies logs, that is correct > right? > > Its not until 9i where we get the luxury of managed recovery being a > background proces, right? > > thanks, joe > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: standby database question.
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" <[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 a dedicated session to put the database in managed recovery mode. > > SQL> recover managed standby database; > > > this does not fork into the background but is a foreground process, that > ties that window up as it receives and applies logs, that is correct > right? > > Its not until 9i where we get the luxury of managed recovery being a > background proces, right? > > thanks, joe > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
standby database question.
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. SQL> recover managed standby database; this does not fork into the background but is a foreground process, that ties that window up as it receives and applies logs, that is correct right? Its not until 9i where we get the luxury of managed recovery being a background proces, right? thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: STANDBY DATABASE QUESTION?
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 Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 6:18 PM 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. 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 > server , or do I move it manually . ??? > > > > And my second question is on my Win2000 Adv. Server C:\ drive , > PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so > big ? I know that it is because of SWAP . But I am sure that there must > not be swap since I have 8 GB ram and only 40 users use database for now. . > > . > > > > > > 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. > -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donald Bricker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: STANDBY DATABASE QUESTION?
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. 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 > server , or do I move it manually . ??? > > > > And my second question is on my Win2000 Adv. Server C:\ drive , > PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so > big ? I know that it is because of SWAP . But I am sure that there must > not be swap since I have 8 GB ram and only 40 users use database for now. . > > . > > > > > > 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. > -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donald Bricker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: STANDBY DATABASE QUESTION?
Arslan, not exactly managed mode applies the logs, you need to setup the primary init.ora to have the shipped from primary site to standby site. joe Arslan Bahar wrote: > 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 <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 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 , > PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it > so big ? I know that it is because of SWAP . But I am sure that > there must not be swap since I have 8 GB ram and only 40 users use > database for now. . > > . > > > > > > 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. > -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: STANDBY DATABASE QUESTION?
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:[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 > automatic , is the archive log files automatically copied to standby > server , or do I move it manually . ??? > [Vikas Khanna] You have do transfer them manually to the standy by > server. OR you can write automated scripts to do the job for you. > > > > And my second question is on my Win2000 Adv. Server C:\ drive , > PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it > so big ? I know that it is because of SWAP . But I am sure that > there must not be swap since I have 8 GB ram and only 40 users use > database for now. . > [Vikas Khanna] Its the max limit for the size of the file which > this OS support. Even if you might have 8 GB RAM what depends is > your SGA Size. > > . > > > > > > 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. > -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: STANDBY DATABASE QUESTION?
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 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 , > PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so > big ? I know that it is because of SWAP . But I am sure that there must > not be swap since I have 8 GB ram and only 40 users use database for now. . > > . > > > > > > 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. > -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: STANDBY DATABASE QUESTION?
>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 .. > 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 . ??? > [Vikas Khanna] You have do transfer them manually to > the standy by server. > OR you can write automated scripts to do the job for > you. > > And my second question is on my Win2000 Adv. Server > C:\ drive , PAGEFILE.SYS > file is nearly 2 GB , AND does not increase , Why is > it so big ? I know that > it is because of SWAP . But I am sure that there > must not be swap since I > have 8 GB ram and only 40 users use database for > now. . > [Vikas Khanna] Its the max limit for the size of > the file which this OS > support. Even if you might have 8 GB RAM what > depends is your SGA Size. > . > > > 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. > > > = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: STANDBY DATABASE QUESTION?
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 wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ???[Vikas Khanna] You have do transfer them manually to the standy by server. OR you can write automated scripts to do the job for you. And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . [Vikas Khanna] Its the max limit for the size of the file which this OS support. Even if you might have 8 GB RAM what depends is your SGA Size. . Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
Re: STANDBY DATABASE QUESTION?
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: 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 , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . . Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
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 , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . . Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
RE: Standby database question
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 Wilton http://www.speakeasy.net/~jwilton > -Original Message- > Sent: Monday, January 28, 2002 2:25 PM > To: Multiple recipients of list ORACLE-L > > 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 to the primary database control file. Refresh the standby > database control file after making major structural changes to the primary > database, such as adding or dropping files. > > (Then the steps for refreshing the control file are given). > > Let me know if this is not the case. > > One thing we've noticed is that the status (from v$datafile) of the added > data file shows "RECOVER" unless standby control file is not refreshed. > > -Original Message- > Sent: Friday, January 25, 2002 2:00 PM > To: Multiple recipients of list ORACLE-L > > On Fri, 25 Jan 2002, Molina, Gerardo wrote: > > > There is one last, but important step. > > > > You need to recreate standby control file... > > Why do you have to do that? It doesn't say to do that in the > documentation. The new datafiles are reflected in the standby > controlfile through normal recovery and by issuing the 'alter database > create datafile' command. > > There is no need to re-dump and copy a new standby controlfile, and > definitely no need to shut any database down. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Standby database question
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 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 to the primary database control file. Refresh the standby database control file after making major structural changes to the primary database, such as adding or dropping files. (Then the steps for refreshing the control file are given). Let me know if this is not the case. One thing we've noticed is that the status (from v$datafile) of the added data file shows "RECOVER" unless standby control file is not refreshed. Thanks, Gerardo -Original Message- Sent: Friday, January 25, 2002 2:00 PM To: Multiple recipients of list ORACLE-L On Fri, 25 Jan 2002, Molina, Gerardo wrote: > There is one last, but important step. > > You need to recreate standby control file... Why do you have to do that? It doesn't say to do that in the documentation. The new datafiles are reflected in the standby controlfile through normal recovery and by issuing the 'alter database create datafile' command. There is no need to re-dump and copy a new standby controlfile, and definitely no need to shut any database down. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 25 Jan 2002, Molina, Gerardo wrote: > on primary: > > alter database create standby controlfile as ''; > > ftp this new file to standby > > on standby: > > shutdown immediate > > copy new control file to appropriate locations with correct file name. > > startup nomount > > alter database mount standby database > > -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 > > 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 Administration Manual. > > http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ > a76995/standbys.htm#27363 > > In short, you just add the tablespace to the primary, wait for the > standby to fail with ORA-01157, then issue the following command on > the standby: > > SQL> alter database create datafile '' as ''; > > Where foo is the location of the datafile on the primary, and bar is > the location on the standby (usually the same). > > If you create a tablespace with several datafiles, you will have to > issue this command a few times after recovering the standby and > waiting for the ORA-01157 each time. > > Don't fall into the trap some people do where they think they have to > copy the new file over to the standby every time they create a > datafile. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGur
RE: Standby database question
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 to the primary database control file. Refresh the standby database control file after making major structural changes to the primary database, such as adding or dropping files. (Then the steps for refreshing the control file are given). Let me know if this is not the case. One thing we've noticed is that the status (from v$datafile) of the added data file shows "RECOVER" unless standby control file is not refreshed. Thanks, Gerardo -Original Message- Sent: Friday, January 25, 2002 2:00 PM To: Multiple recipients of list ORACLE-L On Fri, 25 Jan 2002, Molina, Gerardo wrote: > There is one last, but important step. > > You need to recreate standby control file... Why do you have to do that? It doesn't say to do that in the documentation. The new datafiles are reflected in the standby controlfile through normal recovery and by issuing the 'alter database create datafile' command. There is no need to re-dump and copy a new standby controlfile, and definitely no need to shut any database down. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 25 Jan 2002, Molina, Gerardo wrote: > on primary: > > alter database create standby controlfile as ''; > > ftp this new file to standby > > on standby: > > shutdown immediate > > copy new control file to appropriate locations with correct file name. > > startup nomount > > alter database mount standby database > > -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 > > 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 Administration Manual. > > http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ > a76995/standbys.htm#27363 > > In short, you just add the tablespace to the primary, wait for the > standby to fail with ORA-01157, then issue the following command on > the standby: > > SQL> alter database create datafile '' as ''; > > Where foo is the location of the datafile on the primary, and bar is > the location on the standby (usually the same). > > If you create a tablespace with several datafiles, you will have to > issue this command a few times after recovering the standby and > waiting for the ORA-01157 each time. > > Don't fall into the trap some people do where they think they have to > copy the new file over to the standby every time they create a > datafile. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Standby database question
On Fri, 25 Jan 2002, Molina, Gerardo wrote: > There is one last, but important step. > > You need to recreate standby control file... Why do you have to do that? It doesn't say to do that in the documentation. The new datafiles are reflected in the standby controlfile through normal recovery and by issuing the 'alter database create datafile' command. There is no need to re-dump and copy a new standby controlfile, and definitely no need to shut any database down. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 25 Jan 2002, Molina, Gerardo wrote: > on primary: > > alter database create standby controlfile as ''; > > ftp this new file to standby > > on standby: > > shutdown immediate > > copy new control file to appropriate locations with correct file name. > > startup nomount > > alter database mount standby database > > -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 > > 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 Administration Manual. > > http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ > a76995/standbys.htm#27363 > > In short, you just add the tablespace to the primary, wait for the > standby to fail with ORA-01157, then issue the following command on > the standby: > > SQL> alter database create datafile '' as ''; > > Where foo is the location of the datafile on the primary, and bar is > the location on the standby (usually the same). > > If you create a tablespace with several datafiles, you will have to > issue this command a few times after recovering the standby and > waiting for the ORA-01157 each time. > > Don't fall into the trap some people do where they think they have to > copy the new file over to the standby every time they create a > datafile. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Standby database question
There is one last, but important step. You need to recreate standby control file... on primary: alter database create standby controlfile as ''; ftp this new file to standby on standby: shutdown immediate copy new control file to appropriate locations with correct file name. 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 > 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 Administration Manual. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76995/standbys.htm#27363 In short, you just add the tablespace to the primary, wait for the standby to fail with ORA-01157, then issue the following command on the standby: SQL> alter database create datafile '' as ''; Where foo is the location of the datafile on the primary, and bar is the location on the standby (usually the same). If you create a tablespace with several datafiles, you will have to issue this command a few times after recovering the standby and waiting for the ORA-01157 each time. Don't fall into the trap some people do where they think they have to copy the new file over to the standby every time they create a datafile. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Standby database question
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 Administration Manual. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76995/standbys.htm#27363 In short, you just add the tablespace to the primary, wait for the standby to fail with ORA-01157, then issue the following command on the standby: SQL> alter database create datafile '' as ''; Where foo is the location of the datafile on the primary, and bar is the location on the standby (usually the same). If you create a tablespace with several datafiles, you will have to issue this command a few times after recovering the standby and waiting for the ORA-01157 each time. Don't fall into the trap some people do where they think they have to copy the new file over to the standby every time they create a datafile. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Standby database question
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 PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: standby database question - solved
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 > -- > Author: Anjan Thakuria > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- 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 FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: standby database question - solved
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 / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
standby database question - solved
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 FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Standby database question
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. thanks, 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 FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
