RE: incomplete recovery help

From: Javier Morales <Javier_at_infojobs.net>
Date: Fri, 27 Oct 2000 13:18:09 +0200
Message-Id: <10662.120417@fatcity.com>

In this case you would need to use TSPITR (Tablespace point in time recovery) but It's recommend to make it with Oracle Support other side of the phone...

... and put some candles and PRAY !! hihi... ;-)

-----Mensaje original-----
De: nlzanen1_at_ey.nl [mailto:nlzanen1_at_ey.nl] Enviado el: viernes 27 de octubre de 2000 14:13 Para: Multiple recipients of list ORACLE-L Asunto: Re: incomplete recovery help

Hi,

You can only go back in time with your complete database and not just one datafile

Jack

"Indra Harimurti" <indra_at_sofrecom.co.id>@fatcity.com on 27-10-2000 12:50:48

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Dear DBA,
I have a problem when doing an incomplete recovery test as follows :

1. create emp table
2. insert 4 records
3. alter system switch logfile, produced : ind1_17.dbf
4. truncate table emp
5. alter system switch logfile, produced : ind1_18.dbf
6. I wanted to recover back to point 2.
7. shutdown db
8. restore back datafile from recent cold backup
9. start sqldba
10. startup mount
11. recover database until cancel ORA-00279: Change 5539 generated at 10/27/00 16:40:09 needed for thread 1

ORA-00289: Suggestion : /data1/USERS/indra/dafarc/ind1_17.dbf

Specify log: {<RET>=suggested | filename | AUTO | FROM logsource | CANCEL} Log applied

ORA-00279: Change 5540 generated at 10/27/00 16:40:09 needed for thread 1

ORA-00289: Suggestion : /data1/USERS/indra/dafarc/ind1_18.dbf

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

1. alter database open resetlogs ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/data1/BASE/db716/sys_db716.dbf' Does that I need to restore system datafile mentioned above ? Please advise. Thanks in advance.

Indra

---

De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.

---

The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.

---

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: nlzanen1_at_ey.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Fri Oct 27 2000 - 06:18:09 CDT