Dear frirends
our database is 11.20.4 as dataguard primary that we manually
recover it everyday for 10 days ego (it is in mount mode)
ALTER DATABASE RECOVER automatic DATABASE UNTIL TIME 'SYSDATE-10' USING -BACKUP CONTROLFILE;
-------------------- after
alter database create datafile 72 as NEW;
alter database create datafile 73 as NEW;
and
after
ALTER DATABASE RECOVER automatic DATABASE UNTIL TIME 'SYSDATE-10' USING -BACKUP CONTROLFILE;
we gets the following error ( we have only archivelog for 30 days !!! )
ORA-00279: change 1104932 generated at 10/10/2014 11:24:17 needed for thread 1
ORA-00289: suggestion : /reco1/<sid/archivelogs/thread_1_seq_13_86050xxxx.arc
ORA-00280: change 1104932 for thread 1 is in sequence #13
ORA-00278: log file '/reco1/<sis>/archivelogs/thread_1_seq_13_86050xxxx.arc' no
longer needed for this recovery
ORA-00308: cannot open archived log
'/reco1/<sid>abim/archivelogs/thread_1_seq_13_86050xxxx.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
---------------------- 2 file checkpoing is different from other --------
SQL> select fuzzy, status, error, recover, checkpoint_change#, checkpoint_time, count(*) from v$datafile_header group by fuzzy, status, error, recover, checkpoint_change#, checkpoint_time ;
FUZ STATUS ERROR
--- ------- -----------------------------------------------------------------
REC CHECKPOINT_CHANGE# CHECKPOINT_TIME COUNT(*)
--- ------------------ ------------------- ----------
NO ONLINE
1104932 10/10/2014 11:24:17 1
NO ONLINE
3.4414E+11 07/06/2022 00:41:30 1
NO ONLINE
3.4414E+11 07/06/2022 00:41:35 82
SQL>
------------------------
how to recover 2 datafile only (fuzzy in checkpoint_time )
regards
orasiya