Database – How to clone an oracle instance

databasedatabase-administrationoracleoracle10g

How do you clone an oracle instance? Basically, I want to end up copying it from d:\oracle\oldname to d:\oracle\newname.

I'm working with Oracle 10.2.

Best Answer

Look into using the RMAN DUPLICATE command. I believe this was introduced in 9i, but is certainly available in 10g. It takes care of all of those steps that used to be necessary when cloning manually such as renaming datafiles, recreating control files, resetting database name, etc.

If you have a new directory structure for data and log files you can just permanently set the clone's startup parameters to convert these automatically to the new format/location by a string replacement specification. Cloning then becomes as simple as connecting to the target ("clone from"), aux ("clone to"), and RMAN catalog databases and issuing the RMAN command "DUPLICATE DATABASE to (myNewDBname)". You can also set the "until time" to bring the clone up to an earlier point in time.

Oracle 11g adds the ability to clone directly from a live database.

By the way, if you're not backing up with RMAN, then drop everything else and start doing this now!

Related Solutions

Oracle RAC: Configure instance to depend on VIP

Solved! The trick is to re-register the instance resource. As root:

crs_stat -p ora.db.instance1.inst > /tmp/ora.db.instance1.inst.cap

Edit /tmp/ora.db.instance1.inst.cap and add the vip resource to REQUIRED_RESOURCES

Run:

crs_register ora.db.instance1.inst -d /tmp -u

the "-u", I'm guessing is update, does the magic. After that you need to re set permission (or maybe run the whole thing as "oracle" user)

crs_setperm ora.db.instance1.inst -o oracle
crs_setperm ora.db.instance1.inst -g dba
crs_setperm ora.db.instance1.inst -u pgrp:dba:rwx

That's it. Run a

crs_stat -p crs_stat -p ora.db.instance1.inst

to make sure the changes have been saved and restart the instance

This is relevent to 10.2.0.4

Database – Oracle 9i Instance Memory Usage

There's two types of memory for an Oracle instance. The SGA is shared memory, and PGA is memory only accessible to the individual processes. If you connect to an instance with appropriate privileges (eg DBA or with SELECT_CATALOG_ROLE) you can

SELECT SUM(VALUE) FROM V$SGA;

SELECT SUM(PGA_ALLOC_MEM) FROM V$PROCESS;

to see the totals for each of those.

Best Answer

Related Solutions

Oracle RAC: Configure instance to depend on VIP

Database – Oracle 9i Instance Memory Usage

Related Topic