Hi ALL,
11g
RHEL5
I want to avoid the dreaded error in backup recovery which is below:
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: '/ora/prod/proddata/system01.dbf'
I tried already recover until CANCEL but it did not work.
Hence, I want to recover using SCN.
How do I know which SCN has complete set of write to the database in an archive log? such that when I run > recover database until SCN, I can open resetlogs my databas successfully?
This is my actual scenario.
1. Our database generates average two archivelogs of size 2Gb, daily.
2. We made a full backup using frozen VM image, (the database is up while the VM image is being done)
We are testing the restored frozen VM image.
I startup mount the database,
Then run :
RMAN> recover database;
Starting recover at 11-AUG-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
starting media recovery
archive log thread 1 sequence 526 is already on disk as file /ora/prod/proddata/log03a.dbf
archive log filename=/ora/prod/proddata/log03a.dbf thread=1 sequence=528
Oracle 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: '/ora/prod/proddata/system01.dbf'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/11/2017 16:09:34
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/ora/prod/proddata/log03a.dbf'
ORA-00310: archived log contains sequence 526; sequence 528 required
ORA-00334: archived log: '/ora/prod/proddata/log03a.dbf'
I have the following archive logs,
-rw-r----- 1 oratest dba 2097151488 Aug 8 08:32 1_528.dbf
-rw-r----- 1 oratest dba 2097151488 Aug 9 18:45 1_529.dbf
-rw-r----- 1 oratest dba 2097151488 Aug 10 15:26 1_530.dbf
-rw-r----- 1 oratest dba 2097151488 Aug 11 15:32 1_531.dbf
How can I display the how many set of SCN inside arch 1_528.dbf?
How can I find the SCN that will enable the complete recovery which can be opened resetlogs?
Please help....
Kind regards,
jc