Prev: Timestamp in the trace files
Next: Extracting 2.5 million rows
From: joel garry on 9 Jan 2010 18:18
On Jan 8, 7:26 pm, vsevolod afanassiev <vsevolod.afanass...(a)gmail.com>
wrote:
> >> there
> >> are still transactions in the online redo log when the copied file is
> >> bought online,
>
> Yes, and these online redo log files belong to the same database so
> they will be used during recovery.
>
> Let's say you have a database in archivelog mode, you place one
> tablespace in hot backup mode
> (alter tablespace begin backup) and 10 minutes later database crashes.
> If you try to start the database it won't start,
> it will complain that files in this tablespace require recovery. Why?
> Because when you put tablespace in
> backup mode Oracle stops updating SCN in the file header, so it looks
> like files require recovery.
> You don't need to run recovery, simply do 'alter database datafile end
> backup'. But if you try recovery it will work.
> It may require archivelog files, and after getting all information
> from archiveelogs it will get transactions from redo logs.
>
> Copying file to a different location is similar.

Ah yes, of course. I think most confusion comes from people getting
excited and trying "using backup controlfile" syntax for recovery,
when they could just recover. Thanks.

jg
--
@home.com is bogus.
http://developers.slashdot.org/story/10/01/09/136244/Why-Oracle-Cant-Easily-Kill-PostgreSQL?art_pos=9
First  |  Prev  | 
Pages: 1 2 3
Prev: Timestamp in the trace files
Next: Extracting 2.5 million rows