Printable View
I am having problems restoring from a cold backup to my dev environment. We recently upgraded from NT4.0 to 2000. We are on 8.1.7. I have copied over the datafiles from the coldbackup that was done after a normal shutdown to our dev environment. After that I can not get the database to come backup.
Can anyone please help? Step by Step instructions would be great for this struggling NEWBIE.
Thanks
you have to copy datafiles, control files, and redo logs from your cold backup not just datafiles
what errors are you getting?
Well, to be precise, you only need datafiles and controlfiles to restore from the cold backup.
As to the original question, it would be very usefull if you provide us with the error messages you get when you try to start the database. It could be *many* different things that can couse database not be able to start normaly.
true you dont need to restore the redo logs since datafiles and control files are in sync
my bad :o !
ahh, but I recently restored a database from a cold backup, and it would not start because the existing (not backed up) redo logs did not sync with the restored datafiles. Nor could I drop them and create new ones. After more than a few anxious moments I finally found & used the alter database clear logfiles command and I was up & running, I immediatly altered my cold backup scripts so that they copied the online redo logs as well so they could be restored as well if need be.
yea you have to recreate them after restroing a cold backup
I just dont use cold backup whatsoever that's why I forgot in the ILT books suggested that there is no need copying redo logs and the need of recreating them after restoring a cold backup
This restore is from PROD to DEV. I could be wrong on my steps. After I copy over the datafiles, and delete the control files. I have not started the OracleService for the db. In NT4.0 we always had an OracleStartDB and an OracleServiceDB, 2000 only has the oracleservice. In the past I have always started the oracleservice but not the oraclestart. Thats the problem I get an Oracle not available error in SVRMGRL. If I start the oracleservice, when I get to the alter database open resetlogs step it errors with the datafile needs more recovery.
Hopefully this helps. If you can help I will answer questions all day long
Thanks
If you have the datafiles from cold backup ? Why don't you give "CREATE DATABASE" a try ? Its normally the process for cloning a db, but can be useful to you...
Note that 'justageek' never mentioned if he has his DB in archivelog mode. If not he has to restore also the log files from the cold backup!
No, why would he need online logs if his database is in archivelog? You never need online redologs during recovery, so there is no point for backing them up in the first place. Online redologs are needed only during *instance* recovery, for which you don't need any backup at all.Quote:
Originally posted by julian
Note that 'justageek' never mentioned if he has his DB in archivelog mode. If not he has to restore also the log files from the cold backup!
Restore from cold backup simply means open the new database in a state as it was prior to cold backup. For this you don't need online redologs from your backup.
In fact you never have to backup online redologs, neither during cold nor during hot backup. It is particulary *dangerous* to backup online archivelogs during hot backup and one should *never* include them in the hot-backup procedure. With cold backup they are harmless, but they are also useless :). You simply don't need them. Having the above mentioned treath of having online redologs in your hot-backup set in mind, one could simply adopt the habit not to backup online redologs during cold-backup procedure too.
'justageek' never used the word online. For non-archive system's cold backups you do want the log files - when restoring you copy data, control and log files and startup, that's all.
you dont need the online redo logs because they are not needed for recover whatsoever in restoring a cold backup, you can back them up as jmodic mentioned, it is harmless but not necessary
Can he just recreate the control file
by issuing first the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command?
And for this trace file in bdump to identify
what are the necessary files to be copied from production
to development. Then edit it, customize the new directories
and new database name?
before he can use this script to actually duplicate the original database except perhaps of the new database name
and the new directory locations of the new db?
Just make sure that if your going to create the same
database in the same machine your switching your current
ORACLE_SID(maybe PRD) to the new ORACLE_SID(maybe DEV).
Before you clone the production database.
True, but "redo logs" and "online redo logs" mean exactly the same in this context. I used word "online" just to be very specific, so that noone will confuse "redo logs" with "archived redo logs".Quote:
Originally posted by julian
'justageek' never used the word online.
I do not understand why are you emphasizing the difference between archivelog and noarchivelog systems as regarding to cold backup. There is absolutely no difference between the two when performing cold backup. Yo only need to backup data files and controlfiles, that's all. You don't need to backup redo logs (=online redologs) in either of the configurations.Quote:
For non-archive system's cold backups you do want the log files - when restoring you copy data, control and log files and startup, that's all.
[/QUOTE]
I do not understand ...[/QUOTE]
Let me explain. In order to perform cold backup, and pay attention, the subject of this thread is cold backup, you shutdown normal, trans. or immed., then you back up all data files, redo lof files, control files, password files and parameters files (ref.: Oracle UNiversity B&R ILT) 4-10). When you backup a nonarchive DB you restore all those files after the shutdown abort. Then open (ref: Couchman's book page 736).
I just want to go back what justageek had ask:
When you(justageek) are talking about two environment (dev and prod),
did you mean two database in the same machine or two machines with
Production in one machine and development in second machine?
Keep it cool.
Julian,
Pls remember that when u shutdown abort..u need to have an instance recovery and ofcourse u need redo logs for that but to me a proper cold backup would be one that was shutdown normal which again means no need for redo logs.
I would go by jmodic.
Regards,
julian
you can back them up but they are NOT necessary because you shutdown the database cleanly
Just that the downside is you have to recreate the redo logs when you restore the cold backup
You can check Oracle 8i ILT page 4-5 Enterprise DBA Part 1B: Backup and Recovery Workshop (it´s page 4-5 on my PDF, if you have the book it may be in a different page)
[Edited by pando on 09-13-2001 at 06:46 AM]
Well, tell me what's easier: coping the 3-6 (whatever amount) of 4-10M files along with all the other ones or start recreating log files?
A consistent full backup of a non-archivelog DB is one containg the logs, even the init.ora and pwd files!
This discussion leads to nowhere... You may backup whatever you want, it's your database :-)
Redologs are recreated automatically! You don't need to recreate them manually! All you have to do is to add one word when starting the database after restore: RESETLOGS. So what's easier ? For me adding the word RESETLOGS is easier.Quote:
Originally posted by julian
Well, tell me what's easier: coping the 3-6 (whatever amount) of 4-10M files along with all the other ones or start recreating log files?
A consistent full backup (aka cold backup) *both in archivelog and non-archivelog* (as there is no difference, as I've allready said), DOES NOT NEED REDOLOG FILES. Not that it does not need them, Oracle Corp. explicitely discurage including redo logs in any kind of backup sets. See the manuals: http://otn.oracle.com/docs/products/...pst.htm#425901Quote:
A consistent full backup of a non-archivelog DB is one containg the logs, even the init.ora and pwd files!
Maybe you'll belive it from the mouth of Thomas Kyte:
==================================
an offline backup is "easy". do a shutdown (not shutdown abort)
and copy all
o datafiles
o controlfiles
to another location. You've just done your cold backup (or use backup manager). do not copy redo.
http://asktom.oracle.com/pls/ask/f?p...0_P8_DISPLAYID,F4950_P8_CRITERIA:1430804148892
==================================
Sure, you can include them, but hey, why not simply backup the whole system, this way you surely won't forget anything :). On one of the databases I'm looking after, we have 5 redo groups of 100M each. So why would I backup them, wasting half gigabytes of storage? And there are 2 members in each group. Should I include them in backup also, wasting another 500megs?
True.Quote:
This discussion leads to nowhere... You may backup whatever you want, it's your database :-)
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.Quote:
Maybe you'll belive it from the mouth of Thomas Kyte:
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*.