Need Help : SAP restore without archive logs
We had a server crash and we had a backup of december 2016 and with no archive logs.
we had restored the old backup of december and we were trying to recover the database it asked for archive as system dbf needs recovery
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1.3863E+10 bytes
Fixed Size 2241464 bytes
Variable Size 6979325000 bytes
Database Buffers 6845104128 bytes
Redo Buffers 36691968 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 2876863015 generated at 12/06/2016 00:10:28 needed for thread
1
ORA-00289: suggestion : /oracle/ECP/112_64/dbs/DEFER1_154449_820020147.dbf
ORA-00280: change 2876863015 for thread 1 is in sequence #154449
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/ECP/sapdata1/system_1/system.data1'
ORA-01112: media recovery not started
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/ECP/sapdata1/system_1/system.data1'
Oracle version : Release 11.2.0.3.0 Production
Backup method BRBACKUP
REstore method is BRRESTORE
i am ok with getting the database up with rest logs as i am aware that i do not have archive logs
now the disk of the server which has crashed has been put for recovery and they saw that the archive logs were being written in the default oracle home directory of $ORACLE_HOME/dbs , however the archive logs have the format as
DEFER1_136646_820020147.dbf 32.0 MB 27-02-2016 04:57:39
DEFER1_136648_820020147.dbf 31.3 MB 27-02-2016 05:12:49
DEFER1_136650_820020147.dbf 32.4 MB 27-02-2016 05:57:21
DEFER1_136655_820020147.dbf 31.3 MB 27-02-2016 12:26:41
If we were to recover the disks will i be able to recover the db
to clarify
backup without archive logs were of : dec 6 2016
and archive logs which are present in the disk whose snapshot was given by the disk recovery company
are from feb 2016 to june 2017
my doubt is that the archive files which we will get recovered are of the above format and i am wondering why the archive sequences are not ordered
or they are not sequence numbers ?
Any help will be highly appreciated