| Recovery Issue [message #265152] |
Wed, 05 September 2007 09:58  |
sbaker
Messages: 12
Registered: April 2006
|
Junior Member |
|
|
Hello Everyone,
I'm trying to figure this out and I was hoping some of you pros could give me a little insight.
We are changing out backup process from incremental thoughout the week to a HOT LEVEL 0 every day. The follwing script is used.
run {
allocate channel ch1 type disk format 'd:\oracle\backup%d_DB_% u_%s_%p';
backup database;
backup archivelog all;
release channel ch1;
}
The control file is backed up on O/S level right after this backup completes. Now I've been trying to simulate a disater recovery scenario... so we can be sure it works.
Everything on the server is good to go I just cannot get the database to restore. I can get all the DBF files there and the control file but I never can get the database to open correctly.
Here is my Recovery script....
run {
startup mount pfile=c:\Oracle\Admin\TSH1\pfile\init.ora;
allocate channel ch1 type disk;
restore database;
recover database UNTIL CANCEL;
release channel ch1;
}
No matter how many times I try I get this same error.
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'G:\ORACLE\ORADATA\PTMN\SYSTEM01.DBF'
I know to resolve this error you have to restore that file... but apparently I'm doing something wrong in my backup or restore process..... I did also notice the archivelogs are not restoring like the DBF files...Any suggestions would be MOST helpful.
Now for the shocker.... this is Oracle 8.1.7  OH NO!
[Updated on: Wed, 05 September 2007 09:59] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: Recovery Issue [message #265635 is a reply to message #265624] |
Thu, 06 September 2007 15:06  |
mson77
Messages: 208
Registered: August 2007
Location: Brazil
|
Senior Member |
|
|
Hello sbaker,
We all here want to help people.. like you too. Believe.
But as a new user... or new in town... don't you believe that you should start following the guidelines of this forum?
Do you believe that this forum is a community?
How can you say:
| Quote: | Looks fine to me. Take about 60 secs to read.
|
Looks fine to you... means looks fine to everyone?
Do you care about the others? Really care?
Try to reconsider and start from the beginning... using what is written in the Forum Guideline.
What Michel Cadot says is: Specially the code... format them to be easy read. Not for you... but for the community... because you are here in the community asking for help.
The community will help you... but you have to help the community too.
Regards,
mson77
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
