Re: Quick move tablespace
From: joel garry <joel-garry_at_home.com>
Date: Sat, 9 Jan 2010 15:18:40 -0800 (PST)
Message-ID: <ec641816-1fc0-4700-999c-9001495d05fc_at_22g2000yqr.googlegroups.com>
On Jan 8, 7:26 pm, vsevolod afanassiev <vsevolod.afanass..._at_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.
Date: Sat, 9 Jan 2010 15:18:40 -0800 (PST)
Message-ID: <ec641816-1fc0-4700-999c-9001495d05fc_at_22g2000yqr.googlegroups.com>
On Jan 8, 7:26 pm, vsevolod afanassiev <vsevolod.afanass..._at_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
-- _at_home.com is bogus. http://developers.slashdot.org/story/10/01/09/136244/Why-Oracle-Cant-Easily-Kill-PostgreSQL?art_pos=9Received on Sat Jan 09 2010 - 17:18:40 CST