Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: URGENT ! Recovery until time or by logfile
A copy of this was sent to "Alexander Moan" <alexmoan_at_online.no>
(if that email address didn't require changing)
On Sat, 29 Aug 1998 12:08:39 +0200, you wrote:
>I have just done a reorganisation of my database and need to do some roll
>forward for
>the last changes done on friday after complete backup.
>- Backup (thusday-friday)
>- Shutdown, startup noarchivelog
>- dropped two users(fragmented data)
>- removed several minor datafiles, added new and bigger datafile
>- imported data for the two users
>- NEED TO ROLL FORWARD TO TIME OR USING 4 ARCHIVEFILES
>
>Get : 'Media recovery not neccesary' ! I KNOW THAT, but I want the data
>anyway.
>Tried alter database recover logfile 'filename' but then it is neccesary to
>do alter database recover tablespace according to doc. That is not
>neccesary.
>
>What am I doing wrong ?
>How do I do it ?
>
>
What is there to roll forward? according to your timeline above you've never performed a restore? once you got into noarchivelog mode -- you cannot perform point in time recoveries either.
I don't see "what data" you could possibly get from any archived redo log files given the above scenario.
What exactly are you trying to do?
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Aug 29 1998 - 08:20:45 CDT