Re: Backup Oracle ? Online Redo Log.

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 13 Jan 2002 14:02:43 -0800
Message-ID: <a1t06301pt4@drn.newsguy.com>

In article <ug234us4d8t6hdof58q31ujhnfjf4d9loq_at_4ax.com>, Han says...
>
>On 10 Jan 2002 10:06:52 -0800, Thomas Kyte <tkyte_at_us.oracle.com> wrote:
>
>>you would roll forward through all of the archived redo logs you have.
>>
>>if the current online redo logs are available (the ones that were current as of
>>the crash), you will apply them as well -- else you lose their work.
>
>Question: Would you have to rename those to the same format as your archived
>redo logs and apply them in the same fasion, or can you just leave them in the
>original location after restoring the (cold) backups of the control and
>datafiles, after which Oracle will take care of it?
>
>I think i renamed them once as archived log files, and that worked.
>

you could but you could also just give us the file name as we recovered -- it'll say something like "need to apply this suggested filename foo.log", you can just put in the other name if you like...

along the lines of this:

...
As a log file is needed, Oracle suggests the name of the file. For example, if you are using SQL*Plus, it returns the following lines and prompts:

ORA-00279: Change #### generated at DD/MM/YY HH:MM:SS needed for thread #
ORA-00289: Suggestion : logfile
ORA-00280: Change #### for thread # is in sequence #

Specify log: [<RET> for suggested | AUTO | FROM logsource | CANCEL ] ....

>Cheers,
>Han.
>
>+----------------------------------------------------------+
>| Han Thomas 25/1 Moo 2 Pa Bong, Saraphee |
>| Han_at_Royal.net Chiang Mai 50140 THAILAND |
>+----------------------------------------------------------+

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Sun Jan 13 2002 - 16:02:43 CST