Home » RDBMS Server » Server Administration » Building database from hot backup
Building database from hot backup [message #210790] Fri, 22 December 2006 06:53 Go to next message
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.
Re: Building database from hot backup [message #210795 is a reply to message #210790] Fri, 22 December 2006 07:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
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.
Re: Building database from hot backup [message #210883 is a reply to message #210810] Fri, 22 December 2006 22:59 Go to previous message
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
Previous Topic: Accent Isensitive and Case Sensitive
Next Topic: Problem with SID
Goto Forum:
  


Current Time: Tue Dec 06 10:28:54 CST 2016

Total time taken to generate the page: 0.11706 seconds