Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Create new database from cold backup files.

579749Mar 21 2009 — edited Mar 21 2009

Dear Experts,

I have an oracle 10g databae on windows 2003 server.
The database is in Archive log mode and backup strategy is Taking cold backup ever night.
Backup steps:
shut down database.
copy data files, control files, redo logs, archive logs and parameter files to safe location.
Startup.

I have taken a backup at Tuesdaay 1AM and I have archive logs also.
On Wednesday, I want to Create a new database on another server with the available cold backup files and archive logs. I want to recover the database upto 4PM Wednesday. How can I do this.

I am not using control file auto backup or control file backup to trace.

Please help me how can I do this. I am new to oracle database Administration.

--Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2009

Added on Mar 21 2009

#general-database-discussions

5 comments

1,572 views