Re: Single instance multiple database?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 1 Nov 2001 10:00:05 -0000
Message-ID: <3be11d6f$0$8510$ed9e5944@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:00:05 CST