Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Standby server problem with v$archive_log
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
Received on Mon Nov 26 2007 - 10:37:15 CST