Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Single instance multiple database?

Re: Single instance multiple database?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 1 Nov 2001 10:30:46 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA72C1BCD@lnewton.leeds.lfs.co.uk>


A cold backup is a snapshot of a closed database taken at a specific point in time.
When you recover from a cold backup, it is all or nothing - every single user schema in the database goes back to that point.

So, if you have a database with, say, a dev and a live user (schema) set up, and you trash the dev one, but not the live. When you restore back to 'last nights dump', live goes back as well.

HTH
Norman.



Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com

------------------------------------------------------------------------

-----Original Message-----

From: HK Chang [mailto:hkchang_at_hgc.com.hk] Posted At: Thursday, November 01, 2001 10:08 AM Posted To: server
Conversation: Single instance multiple database? Subject: 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? Received on Thu Nov 01 2001 - 04:30:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US