By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,504 Members | 1,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,504 IT Pros & Developers. It's quick & easy.

What is the problem my standby database step?

P: n/a

I want to setup standby database which reside on the same host with my
primary database
-dbSA is my primary and dbSB is my standby database.

I select v$log as follows:
SVRMGR> select thread#,sequence#,archived,status from v$log;
THREAD# SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
1 35 YES INACTIVE
1 36 YES INACTIVE
1 37 NO CURRENT
3 rows selected.
SVRMGR>

I continue to do the next step:
-i shutdown dbSA and copy all datafile to the standby path
-copy parameter file from dbSA to the dbSB and modify it with the necessary
changes.
-startup dbSA and create standby control file.
When i login to dbSB and see archive log list, it produce as follows:
Database log mode Archive Mode
Automatic archival Enabled
Archive destination
/software/oracle_817/app/oracle/admin/dbSB/arch
Oldest online log sequence 35
Next log sequence to archive 37
Current log sequence 37



The problem now it seems that my standby database can not archive log file
correctly. When i see my alert.log file, it produce following log:

Successful mount of redo thread 1, with mount id 1659962364.
Thu Apr 8 11:52:28 2004
Standby Database mounted.
Completed: alter database mount standby database
Thu Apr 8 11:52:49 2004
ALTER DATABASE RECOVER managed standby database
Thu Apr 8 11:52:49 2004
Media Recovery Start: Managed Standby Recovery
Media Recovery Log
Media Recovery Waiting for thread 1 seq# 9


HOW COME it try to search thread 1 sequence no 9? it should try to start
from 37 right?
Any feedback is appreciated.

mike


Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.