Re: 10g Recovery Wizard

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Thu, 13 Jul 2006 23:10:40 GMT
Message-Id: <pan.2006.07.13.23.12.40.647925@gmail.com>

On Thu, 13 Jul 2006 08:52:03 -0700, RogBaker wrote:

>
> HansF wrote:

>> On Thu, 13 Jul 2006 07:49:01 -0700, RogBaker wrote:
>>
>> > Is it possible to use the OEM Database Control Recovery Wizard to
>> > restore a database with a backup of a different database? (Piece of
>> > cake in SQL Server). I don't seem to find that functionality in there.
>> > The backupset pieces have the database name as part of the file name,
>> > so maybe if you copy them to the correct location and rename them
>> > appropriately....
>>
>> Are you mixing definitions of Database?  SQL Server uses a completely
>> different definition than Oracle, and you may be comparing cake with
>> trucks.
>> 

> No, not mixing defintions.
> In Oracle 10g, Suppose I want to make another copy of my production
> database to test something, or if I want to refresh a Test database
> with copy of production. Typically I would do EXP/IMP or DPEXP/DPIMP.
> This is a pain, running scripts to drop existing objects in the target
> database, etc.

Two things, used together, that come to mind: - duplicate (clone) database from backup - transportable tablespace

SQL Server database is roughly equivalent to an Oracle schema.

If you organize your Oracle test environment to segregate schemas to separate tablespaces, you can quickly and easily drop and replace a complete data set which happens to match one or more tablespaces.

Still requires scripting, and probably will not help with performance tuning (as you still need apporpriate statistics), but should be fairly quick and relatively easy to implement.

Note that transportable tablespace can be obtained from the production system directly - getting it from the backup clone is a bonus. <?g?>

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Thu Jul 13 2006 - 18:10:40 CDT