Re: Single instance multiple database?

How about if I have cold backup and recover.

Is it possible to recover only a tablespace to a specific moment in time from a cold backup?

Regards,
HK Chang
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3be11d6f$0$8510$ed9e5944_at_reading.news.pipex.net...
> Depends on what you mean by recover.
>
> You can export,import on a schema by schema basis. You can also recover a
> tablespace to a specific moment in time so this might allow conventional
> recovery of a schema if your object locatiuons are sensible. I must admit
> though I tend to think of recover as an all or nothing event.
>
> If your schemas have entirely different purposes (say development and live
> or two different apps) you are better off with multiple databases and
> instances.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission Uk
> "HK Chang" <hkchang_at_hgc.com.hk> wrote in message
> news:9rr41t$2qtm$1_at_news.net-yan.com...
> > Is it possible to recover only one schema in the database, but the other
> > schemas remains unchanged?
> >
> > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > news:tu234jb65vthbc_at_corp.supernews.com...
> > >
> > > "HK Chang" <hkchang_at_hgc.com.hk> wrote in message
> > > news:9rqtf6$2mvr$1_at_news.net-yan.com...
> > > > Hello,
> > > >
> > > > Is it possible to use single instance to manage multiple database in
> > > Oracle?
> > > >
> > > > Thanks.
> > > >
> > > > Regards,
> > > > HK Chang.
> > > >
> > > >
> > > No
> > > database in sqlserver <---> schema in Oracle.
> > >
> > > I once had to learn to play from 16th century music notation, which
very
> > > much looks like modern notation. Within a few hours I discovered the
> only
> > > way to master it was to forget for a while about modern notation.
> > > Learning Oracle is very much similar.
> > >
> > > Regards
> > >
> > >
> > > --
> > > Sybrand Bakker
> > > Senior Oracle DBA
> > >
> > > to reply remove '-verwijderdit' from my e-mail address
> > >
> > >
> > >
> >
> >
>
>
Received on Thu Nov 01 2001 - 04:07:57 CST