=3Dsuggested | filename | AUTO | FROM logsource | = CANCEL} =20 CANCEL 12. alter database open resetlogs ORA-01152: file 1 was not restored from a sufficiently old backup =20 ORA-01110: data file 1: '/data1/BASE/db716/sys_db716.dbf' =20 Does that I need to restore system datafile mentioned above ? Please advise. Thanks in advance. Indra ------=_NextPart_000_000C_01C04035.5E7BF440 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Dear DBA,

I have a problem when doing an = incomplete=20 recovery test as follows :

1. create emp table

2. insert 4 records

3. alter system switch logfile, = produced :=20 ind1_17.dbf

4. truncate table emp

5. alter system switch logfile, = produced :=20 ind1_18.dbf

6. I wanted to recover back to point = 2.

7. shutdown db

8. restore back datafile from recent = cold=20 backup

9. start sqldba

10. startup mount

11. recover database until = cancel

ORA-00279: Change 5539 generated at = 10/27/00=20 16:40:09 needed for thread 1
ORA-00289: Suggestion :=20 /data1/USERS/indra/dafarc/ind1_17.dbf = =20
Specify log: {<RET>=3Dsuggested | filename | AUTO | FROM = logsource |=20 CANCEL}

Log applied

ORA-00279: Change 5540 generated at = 10/27/00=20 16:40:09 needed for thread 1
ORA-00289: Suggestion :=20 /data1/USERS/indra/dafarc/ind1_18.dbf = =20
Specify log: {<RET>=3Dsuggested | filename | AUTO | FROM = logsource |=20 CANCEL}

CANCEL

12. alter database open resetlogs

ORA-01152: file 1 was not restored from a = sufficiently old=20 backup
ORA-01110: data file 1:=20 '/data1/BASE/db716/sys_db716.dbf' &nbs= p; =20

Does that I need to restore system datafile = mentioned above=20 ?

Please advise. Thanks in advance.

Indra