no funcioa

Jul 5, 2022 4:38PM

SQL> Recover database using backup controlfile until cancel ;

ORA-00279: change 8911847998953 generated at 03/09/2022 08:37:06 needed for thread 1

ORA-00289: suggestion : +DG_DATA

ORA-15173: entry 'ARCHIVELOG' does not exist in directory 'ADM1'

ORA-00280: change 8911847998953 for thread 1 is in sequence #108721

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

cancel

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: data file 1: '+DG_DATA/ADM1/DATAFILE/system.1012.1109002189'

ORA-01112: media recovery not started

SQL> Alter database open resetlogs ;

Alter database open resetlogs

*

ERROR at line 1:

ORA-01152: file 1 was not restored from a sufficiently old backup

Database Backup and Recovery (MOSC)