"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<4083effd$0$6018$afc38c87_at_news.optusnet.com.au>...
> yls177 wrote:
>
> > Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:<af50801qbk7bsvlibn15j2vvq35tr6siv4_at_4ax.com>...
> >
> >>On 16 Apr 2004 08:21:28 -0700, yls177_at_hotmail.com (yls177) wrote:
> >>
> >>
> >>>hrishys_at_yahoo.co.uk (hrishy) wrote in message news:<4ef2a838.0404160014.26068408_at_posting.google.com>...
> >>>
> >>>>Hi Yes
> >>>>
> >>>>You are doing a sort of standby database..remember you shouldnt be
> >>>>doing any transactions in your test database.
> >>>>
> >>>>regards
> >>>>Hrishy
> >>>>
> >>>>yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0404150445.2d9e2f99_at_posting.google.com>...
> >>>>
> >>>>>if i take the production server backup (full) and restore to test
> >>>>>server, and opened it. and then after some time, took the online
> >>>>>backup of production with its control file , and restore to the test
> >>>>>server, i am able to do so , right?
> >>>>>
> >>>>>also, i am able to apply archived logs after the online backup so that
> >>>>>i have a latest production backup in the test server as the original
> >>>>>production backup?
> >>>
> >>>
> >>>
> >>>not doing any transactions as in "open the database"?
> >>
> >>It doesn't really matter. You are trying to hack yourself out already,
> >>so it really doesn't matter how you accomplish your goal.
> >>Obviously you *CAN'T* synchronize your 'test' database using the
> >>archives from a production database, because as soon as you do
> >>*ANYTHING* on that database, the SCNs of 'test' and production
> >>databases are going out of sync.
> >>Do you really believe you can 'merge' 2 databases using archives. Try
> >>to *understand* how Oracle keeps track of transactions by reading
> >>documentation and do not simply *assume* it will be possible.
> >
> >
> >
> > one says can and the other say not...
> > so how?
>
> Er, one says "remember you shouldn't be doing any transactions in your
> test database". The other says "as soon as you do anything on [your test
> ] database the SCNS... are going to be out of sync".
>
> They are actually agreeing with each other that a working, operating
> "TEST" database cannot be updated/refreshed by archives produced on a
> "PRODUCTION" database in the way you describe.
>
> Where Hrishy is slightly misleading is the suggestion that you can open
> TEST and it will be OK provided you don't do any transactions. That's
> wrong, since the very act of opening TEST counts for the purposes of
> disrupting the SCNs between TEST and PRODUCTION.
>
> That aside, both say you can't do it given the details you originally
> posted, and if it helps any to settle things in your mind, here's a
> third voice saying it can't be done.
>
> Regards
> HJR
i heard the voice clearly.. thanks
Received on Mon Apr 19 2004 - 23:49:26 CDT
