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 - 13:44:55 CST