Re: Quick move tablespace

From: vsevolod afanassiev <>
Date: Fri, 8 Jan 2010 19:26:00 -0800 (PST)
Message-ID: <>

>> 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. Received on Fri Jan 08 2010 - 21:26:00 CST

Original text of this message