Re: Standby database sever on 7.3.4 and NT4

From: <luk_joseph_at_hotmail.com>
Date: Sun, 05 Dec 1999 22:38:45 GMT
Message-ID: <384ae531.589913906@203.2.194.51>

Vijay,

Thanks for your sugustion. I already apply these two paramater in the Init.ora file, but it does help to apply the archived log to the standby DB server.

Here is the screen dump when I try to startup the standby DB.

Oracle Server Manager Release 2.3.4.0.0 - Production

Oracle7 Server Release 7.3.4.3.0 - Production With the distributed, replication and parallel query options PL/SQL Release 2.3.4.3.0 - Production

SVRMGR> connect internal;
Connected to an idle instance.
SVRMGR> startup nomount;
ORACLE instance started.

Total System Global Area      69531664 bytes
Fixed Size                       35760 bytes
Variable Size                 28904544 bytes
Database Buffers              40263680 bytes
Redo Buffers                    327680 bytes

SVRMGR> alter database mount standby database exclusive; Statement processed.
SVRMGR> recover standby database;
ORA-00279: Change 60580576 generated at 11/24/99 13:41:22 needed for thread 1
ORA-00289: Suggestion : G:\oracle\Q08\saparch\%ORACLE_SID%00320.001 ORA-00280: Change 60580576 for thread 1 is in sequence #320 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

The next thing I did was:-

If the archive log is located in the saparch directory then I hit the return key , it will aplly the log and asking for next one #321 . Then whenever the required log is there when I hit return key it will apply and asking the next one.

If numbers of archive log was there and I reply as AUTO it will apply all archive log and back to the same point to asking the next one.

In both caese if the archive log was not there and I hit return it just return an error and exit from the recove mode.

The problem is how can I set it up as when an new archive log has been copied to the saparch directory then it will apply it automatically.

I have been written a small program to monitor the active server whenever an archive log please in the archived directory then I copy it to the standby server -.

Is this is a normal way to handle the movement of archive log from active to standby DB or I am worng and I need to change somthing in the active DB.

Thanks for your help .

Regards,
Joseph

On Sat, 04 Dec 1999 13:15:06 GMT, vijaylamba_at_my-deja.com wrote:

>hi,
>in the parameter file (init.ora) set the following and restart the
>database:
>log_archive_start = true --this will start the arch process
> automatically
>log_archive_dest = "path where u want to store the arched files.
>
>you can also give log_archive_format to specify in what format you want
>the arched files.
>do check sys.v$parameters view in case my spellings are wrong.
>Regards
>Vijay
>In article <38472732.344663421_at_203.2.194.51>,
> jlAT_at_hotmail.com wrote:
>> I have a problem on setup standby database server, The standby server
>> is up and running but I don't know how to apply the archive log
>> automatically. I can only hit a RET kry to apply the next archived
>> log. But the backup server is at other office and I can't affort any
>> one to hit a key on a regular basie.
>>
>> Does any one have an idea how to do it.
>>
>> I am running Oracle 7.3.4 on NT4 box.
>>
>> Thanks for any help.
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sun Dec 05 1999 - 16:38:45 CST