OraFAQ Forum: Server Administration » Building database from hot backup

Home » RDBMS Server » Server Administration » Building database from hot backup

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

Building database from hot backup [message #210790]

Fri, 22 December 2006 06:53

jaydba
Messages: 86
Registered: September 2006
Location: UK

Member

I need to create a database on the basis of hot backup from source daatbase including control files etc. to create a test environment for developers and other purpose.

Can you please suggest me the procedure how to build the same copy of database?

I've prepared the paramter file for this instance.

Do I need to create the new script for creating same database?

Do I need to take the script from my source database using ALTER DATABASE BACKUP CONTROLFILE TO .......

How to poulate this data into my new created database incluidng all the objects.

Thanks in advance.

Report message to a moderator

Re: Building database from hot backup [message #210795 is a reply to message #210790]

Fri, 22 December 2006 07:23

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> on the basis of hot backup
What kind of hot backup is this?
RMAN?
With RMAN, you can just duplicate the database to a local/remote node
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmdupdb.htm#446590
or
Just restore with RMAN
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmrecov.htm#1007360
or the old school 'alter tablespace begin backup'?
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96572/osrestore.htm#26029

[Updated on: Fri, 22 December 2006 08:02]

Report message to a moderator

Re: Building database from hot backup [message #210810 is a reply to message #210795]

Fri, 22 December 2006 08:11

jaydba
Messages: 86
Registered: September 2006
Location: UK

Member

It is hotback up without RMAN. I need the same set of database including data and all the concern objects.

Thanks in advance.

Report message to a moderator

Re: Building database from hot backup [message #210883 is a reply to message #210810]

Fri, 22 December 2006 22:59

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

Go through below link

http://www.sap-img.com/oracle-database/cloning-database-from-hot-backup.htm

hope this helps
Taj

Report message to a moderator

Previous Topic:	Accent Isensitive and Case Sensitive
Next Topic:	Problem with SID

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:38:28 CDT 2024