Re: RECOVER question : how to force to apply logs from a clean but old database back-up

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 29 Apr 1999 10:56:54 -0700
Message-ID: <37289D66.F802FED1@us.oracle.com>

Ah, an oldie but a goodie. Traps people all the time this one. You need to keep the control file there from Friday, so that Oracle knows the datafiles that you restored from Monday's backup have a different log sequence number than the control file, and thus that recovery is needed.

HTH. Pete

Jean-François VINCENT wrote:

> Hi,
>
> In an archivelog mode.
> All my database is on /database
> and all my archived log are on /log
>
> I stop my database monday and i back-up all the files of /database to a
> tape and i restart the database
> Friday, all the filesystem /database crashes
>
> so i restore all the filesystem /database from the tape
> and i restart the database, and i start the recover command from the
> system manager
> and :
>
> recover database :
>
> it says me : nothing to recover because all the files are the monday
> files
>
> How to force oracle to apply all the archived logs to now (friday) ?
>
> thank you.
>
> J-Fr.

--

Regards

Pete

---

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark   2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

---

Received on Thu Apr 29 1999 - 12:56:54 CDT