Recovery from a "Cold Backup"

cdecker5 · #1 (**permalink**) 04-23-03, 20:59

Does anyone have any experience recovering from a cold backup? Specifically, if I perform the copy...can I reinstall Oracle 9i, then put the dbf's ect.. in the same location?

Hings · #2 (**permalink**) 04-24-03, 00:04

Dear cdecker5,

I guess You can do that provided you have the same database name, same Instance name.

Hings

==========

Still Learning...

OBRP · #3 (**permalink**) 04-24-03, 02:32

Sure you can, having controlfile trace provides you more options.

Regards,
OBRP

cdecker5 · #4 (**permalink**) 04-24-03, 14:18

Quote:

Originally posted by OBRP
Sure you can, having controlfile trace provides you more options.

Regards,
OBRP

Where/what is controlfile trace?

OBRP · #5 (**permalink**) 04-25-03, 02:23

Conrolfile trace is text file with steps necessary to recreate your database. You can get it issuing command:
alter database backup controlfile to trace;
Trace file is placed into udump dir of your sid's admin directory.