OraFAQ Forum: Server Administration » Database Refresh (from demo to test)

Home » RDBMS Server » Server Administration » Database Refresh (from demo to test) (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database Refresh (from demo to test) [message #537587]

Thu, 29 December 2011 10:34

lynndba
Messages: 23
Registered: November 2011

Junior Member

Hi all

I just wanted your opinion on this little issue.

I want to do a refresh from demo to test db to make them like duplicates. Thinking of methods to use my options are using transportable tablespace but in this case limited because i have to ensure i do all tablespaces in which the user has objects in it.

Then there is import and export which will take way too long to do an a > 100GB database.

If you have done this let me know your experiences and can the database be open during imp and exp using data pump.

Report message to a moderator

Re: Database Refresh (from demo to test) [message #537590 is a reply to message #537587]

Thu, 29 December 2011 10:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

RMAN DUPLICATE

Report message to a moderator

Re: Database Refresh (from demo to test) [message #537591 is a reply to message #537590]

Thu, 29 December 2011 10:47

lynndba
Messages: 23
Registered: November 2011

Junior Member

Thanks good point why didnt I think of that

Report message to a moderator

Re: Database Refresh (from demo to test) [message #537748 is a reply to message #537591]

Fri, 30 December 2011 16:58

BeefStu
Messages: 208
Registered: October 2011

Senior Member

Or you may want to check into RMAN active clone.. I use this
on many of my databases. In summary, it lets you copy your DB,
while its in use. One drawback is if you have objects in
nologging mode that are accessed duing the clone the DB you
are cloning to will most likely come up with corrupt data
blocks

Report message to a moderator

Previous Topic:	SYSAUX tablespace
Next Topic:	dba_tablespaces does not exist

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 05:52:16 CST 2025