Home » RDBMS Server » Backup & Recovery » Recovery Issue
 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri May 02 12:19:12 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
