Building database from hot backup

[dbajay]

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.

[pareshjavkar]

Dear dbajay,

Just restore the Hot-backup on the Disk.

Create controlfile at mount stage from the trace created by changing the appropriate paths.

apply logs (Archive logs) at mount stage to bring the database to consistent state and open the database.

[dbajay]

How to apply archive log files?

I think that I need to apply as below from the mount stage

Restore database
recover database

Can you please check it?

[pareshjavkar]

Yes, in case you have RMAN Backup.

[hacketta1]

For detailed instructions on doing this the old fashioned way e.g. without RMAN refer to MetaLink Note 135651.1, otherwise:

http://download-uk.oracle.com/docs/c...db.htm#1006085

[dbajay]

Thanks. I'll go through this doc.

[yxez]

Hi Friends,

I see the examples are using catalog is it the same procedure
if im using nocatalog(controlfile) rman backups?


Thanks

[hacketta1]

I've only ever performed this procedure in an environment where a catalog is available, however, I believe that the process is the same without a catalog.

[chduarte]

When you don't have a RMAN catalog the controlfile is the catalog. When you do a hot backup without the catalog, after the RMAN backup has finished you have to issue following command:

RMAN> backup current controlfile;

If you need to restore your backup, the first step on RMAN recover is:

RMAN> restore controlfile from '/backup/rman_ctl_bkp';

Follow the standard process to restore/recover whole database.