Re: Standby server problem with v$archive_log

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@xxxxxxxxx>
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...@xxxxxxxxxx> 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



.

Relevant Pages