Re: What is the problem with my standby database step?

"Officer" <raboasia_at_pacific.net.sg> wrote in message news:<c5d3fu$7pj$1_at_nobel.pacific.net.sg>...
> > > HOW COME it try to search thread 1 sequence no 9? it should try to start
> > > from 37 right?
> >
> > They are out of synchronization. You need to copy over archived logs
> > to the archive location and recover automatic on the standby db before
> > putting it into managed standby mode. Try a log switch just before
> > the shutdown/copy, although I think this is really just a bug. In
> > general, you want to keep some number of archived logs around from
> > before a given backup.
> >
>
> I have issued alter system checkpoint global /switch logfile before i
> shutdown and make a copy to standby path.
>
>
> But always it request "thread 1 sequence no 9" which is i do not have it
> anymore because i have deleted.
>
> The dbsB which is my standby database was a stand alone database with their
> own datafile. When i check using archive log list before i convert this
> instance into my standby database , it shows sequens 489*.
>
> It means my setup (copy stanydby control file and data file from primary to
> secondary) is partly correct.
>
>
> Any ideas Expert?

Are you sure you are using the controlfile you created?

jg

--
@home.com is bogus.
Sell everything and bet it on red.