Restore from Cold Backup

Quote:

---

Maybe you'll belive it from the mouth of Thomas Kyte:

---

I quote Metalink and put an end to this debate :-) I already quoted Orcale ILT B&R plus Couchman. So 3 sources. Could they be all wrong. I do not know who Mr. Kyte is.

Now, METALINK:

[del]

OVERVIEW
--------

This command file dynamically creates the necessary command file and scripts needed to perform a cold (offline) database backup of an Oracle database on MS Windows NT/2000.

All database files are backed up:
- datafiles
- control files (both physical and logical)
- online redo log files <-----------------------------
- password file
- instance parameter file

[del]

Now, of course you will be able to open the DB without the redo log if you mount and then open with RESETLOGS. But if you restore from backup the redo logs too, then you could open directly the database.

I suggest we concentrate on more interesting issues.

HELLO!!! Back to my original question. I have what I want backed up control files, datafiles, redologs. YES THIS IS AN OFFLINE COLDBACKUP. This is what we have backed up in the past and it has always worked! I am refreshing our dev environment on a different server. I have restored the filesre to where they need to be.

WHERE DO I GO FROM HERE. THE INSTRUCTIONS I HAVE ARE FOR NT4.0 AND ORACLE 8.1.5. I NEED HELP IF YALL ARE GOING TO CONTINUE TO BICKER THEN DON'T BOTHER ANSWERING. I HAVE READ THE ORACLE 8.1.7 BACKUP DOCUMENTATION. I HAVE BACKED UP WHAT THE BOOK SAYS I NEED. I NEED TO KNOW WHERE TO GO FROM HERE.

1. Restore all the files from your backup to their proper location
2. Start the service
3. Open DOS prompt, set the ORACLE_SID env variable
4. Connect internal
5. startup nomount
6. alter database mount;
7. alter database open;

Please specify in which step does it fail and provide *exactly which errormesseges are returned*.