Re: Quick move tablespace

From: joel garry <>
Date: Sat, 9 Jan 2010 15:18:40 -0800 (PST)
Message-ID: <>

On Jan 8, 7:26 pm, vsevolod afanassiev <> 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.


-- is bogus.
Received on Sat Jan 09 2010 - 17:18:40 CST

Original text of this message