Hello to all community members!First to mention that I came to the need of asking help after furious research i reattempts for about 3 weeks. I checked previous threads in Oracle community but nothing works for me.
I am trying to restore Oracle 11.1.0.7. multi HDD cluster production on single hdd locally on amazon ec2.
Restore is done from full back-up copy I downloaded from ftp location(I have no access to production,export and etc.) just have access to the files, i.e. I am not able to change anyhow export procedure.
So here are my steps in brief(I guess that problem might be in some of them):
1.rman target /
2.set DBID ...
3.startup nomount
4.RESTORE CONTROLFILE FROM 'file destination'
5.shutdow;startup mount;
6.Catalog the backup files to rman:
catalog backuppiece 'C:/BKUP/AL_2851492942_20151016_893271615_PGQJSFHV_1_1'; for all AL and BK files
7.sqlplus / as sysdba
8.Rename all redo files to match my local directory structure
9.rman:crosscheck backup;
Run{
10.Rename all data files to match my local directory structure
| SET UNTIL SEQUENCE 50511; | |
RESTORE DATABASE;
SWITCH DATAFILE ALL;
RECOVER DATABASE;
}
11.sqlplus sys/sys as sysdba
12.shutdown immediate; startup mount;
13.alter database noarchivelog;
14.Drop the no longer used log files:-drop these in state UNUSED left Active and Inactive
15. Drop all temp files(they point to other drive letter;
16.ALTER DATABASE OPEN;
17.ALTER TABLESPACE mytempspace
ADD TEMPFILE 'c:\oracle\............dbf'
SIZE 1G REUSE
AUTOEXTEND ON
MAXSIZE UNLIMITED;
My problem is that on my second query(get) to db through my app I receive:
ORA-01578: ORACLE data block corrupted (file # 64, block # 2559928)
ORA-01110: data file 64: 'C:\ORACLE\ORADATA\mydb\mydbLOBDATA2_1.DBF'
ORA-26040: Data block was loaded using the NOLOGGING option
ORA-06512: at "mydbUSER.POBJECTSTATE", line 78
ORA-06512: at line 1
What I was able to find with validation and it is LOBSEGMENT - Lob_ObjectState and it logically corruptred.
I try DBMS_REPAIR and with rman advise failure(which suggest to restore my copy from back-up- nothing useful).
Since back-up are refreshed every week I try with new ones form the next week,again the same problem.