Re: Standby server problem with v$archive

From: robert <r.opieczynski_at_interia.pl>
Date: Mon, 26 Nov 2007 23:24:50 +0100
Message-ID: <fifhar$jks$1@mx1.internetia.pl>

THX for replay :)
sorry for my grammar im from poland
this error is beacouse i set automatic recovery and standby server wait for next file with log with number ( last one +1 ) and if this file yet dont exist then show this error i repear synchronize standby phisycal server and i just releaze its work !!! ( i check tables by select ,and after few hours data from main server were in standby server )
but in every text about standby
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ps.htm http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96653/manage_ps.htm server wrote then i must have rows in V$ARCHIVED_LOG ,and i HAVEN'T and my v$archived_log on primery server don't show that log was sent:

RECID    STAMP                DEST_ID      RESETLOGS_TIME
21588     639034115             1                  2004-02-22 18:32:34
21587     639034110             1                  2004-02-22 18:32:34


FIRST_CHANGE#     FIRST_TIME                     NEXT_CHANGE# NEXT_TIME
2572582156                 2007-11-26 21:33:312572582411        2007-11-26 
21:57:12
2572581897                 2007-11-26 21:05:34         2572582156

2007-11-26 21:33:31

CREATOR REGISTRAR STANDBY_DEST ARCHIVED APPLIED DELETED STATUS

ARCH         ARCH             NO                         YES 
NO         NO             A
ARCH         ARCH             NO                         YES 
NO         NO             A

COMPLETION_TIME DICTIONARY_BEGIN DICTIONARY_END END_OF_REDO BACKUP_COUNT ARCHIVAL_THREAD# ACTIVATION#

2007-11-26 21:57:13    NO                                     NO 
NO                     0                                 1 
1046606402
 2007-11-26 21:33:32    NO                                     NO 
NO                     0                                 1

1046606402

i worry that something go wrong but i dont know what

Original Message ----- From: "Steve Howard" <stevedhoward_at_gmail.com> Newsgroups: comp.databases.oracle.server Sent: Monday, November 26, 2007 8:44 PM Subject: Re: Standby server problem with v$archive_log

> On Nov 26, 11:37 am, "robert" <r.opieczyn..._at_interia.pl> wrote:
>> goodmorning :)
>> i have a big problem ,one of my archive logs was broken and i must
>> re-synced
>> standby phisycal server ,copy files from main server and use recover
>> automatic
>> standby database . Now archive logs copy to standby database and register
>> files with no errors . but when i see "select * from v$archive_log; " on
>> standby database i have
>> "no rows selected " !!!
>> what i do wrong and how fix it ? :)
>>
>> oracle 9.2
>> my alert.log :
>> "
>> alter database mount standby database
>> ORA-1100 signalled during: alter database mount standby database...
>> Mon Nov 26 10:05:00 2007
>> ALTER DATABASE RECOVER automatic standby database
>> All dispatchers and shared servers shutdown
>> Mon Nov 26 10:05:00 2007
>> SMON: disabling cache recovery
>> Mon Nov 26 10:05:00 2007
>> Media Recovery Start
>> Mon Nov 26 10:05:01 2007
>> Media Recovery Log /oracle/oradata2/archive/1_55065.dbf
>> Mon Nov 26 10:06:01 2007
>> idle dispatcher 'D000' terminated, pid = (9, 31)
>> Mon Nov 26 10:06:27 2007
>> Media Recovery Log /oracle/oradata2/archive/1_55066.dbf
>> Mon Nov 26 10:07:59 2007
>> Media Recovery Log /oracle/oradata2/archive/1_55067.dbf
>> Errors with log /oracle/oradata2/archive/1_55067.dbf
>> ORA-279 signalled during: ALTER DATABASE RECOVER automatic standby
>> database...
>> Mon Nov 26 10:07:59 2007
>> ALTER DATABASE RECOVER CONTINUE DEFAULT
>> Mon Nov 26 10:07:59 2007
>> Media Recovery Log /oracle/oradata2/archive/1_55067.dbf
>> Errors with log /oracle/oradata2/archive/1_55067.dbf
>> ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
>> Mon Nov 26 10:07:59 2007
>> ALTER DATABASE RECOVER CANCEL
>> Mon Nov 26 10:08:00 2007
>> Media Recovery Cancelled
>> Completed: ALTER DATABASE RECOVER CANCEL
>> Mon Nov 26 10:08:00 2007
>> alter database open read only
>> Mon Nov 26 10:08:00 2007
>> SMON: enabling cache recovery
>> Mon Nov 26 10:08:00 2007
>> Completed: alter database open read only
>> Starting ORACLE instance (normal)
>> Mon Nov 26 12:05:00 2007
>> alter database mount standby database
>> ORA-1100 signalled during: alter database mount standby database...
>> Mon Nov 26 12:05:00 2007
>> ALTER DATABASE RECOVER automatic standby database
>> All dispatchers and shared servers shutdown
>> Mon Nov 26 12:05:00 2007
>> SMON: disabling cache recovery
>> Mon Nov 26 12:05:00 2007
>> Media Recovery Start
>> Mon Nov 26 12:05:00 2007
>> Media Recovery Log /oracle/oradata2/archive/1_55067.dbf
>> Mon Nov 26 12:06:00 2007
>> idle dispatcher 'D000' terminated, pid = (9, 32)
>> Mon Nov 26 12:06:30 2007
>
> Hi Robert,
>
> What do you mean by "archive logs was broken"? On the primary server
> or the standby?
>
>>>Errors with log /oracle/oradata2/archive/1_55067.dbf <<
>
> If this log is still available on the primary, just copy it over and
> run manual recovery on the standby supplying logs when requested, so
> you can see any errors as you go.
>
> HTH,
>
> Steve
>
Received on Mon Nov 26 2007 - 16:24:50 CST

Re: Standby server problem with v$archive_log