re Applying ArchiveLogs after an Instane Recovery -- was RE: NetApp flier - based snapshots and db backups

If you perform instance recovery (ie Crash Recovery) on the cloned database (because you have the controlfiles and online redo logs -- not my caveat that the controlfiles
and online redo logs must be from the same snapshot as the datafiles, in my earlier email
titled "Re: NetApp flier - based snapshots and db backups -- CAVEATS"

and are able to open it without having to do a RESETLOGS, there are ways to apply "future" Archivelogs to it.

See
http://hemantoracledba.blogspot.com/2007/05/rollforward-from-cold-backup.html or MetaLink note 271916.1

Hemant K CHitale
At 06:08 AM Saturday, Allen, Brandon wrote:
>Just to help clarify, and make sure I understand correctly - I think
>what you're both saying is that you could use the copied data,
>control and online log files to start another copy of the database
>instance, which would then perform crash recovery, i.e. roll forward
>through the online logs and then rollback any uncommitted
>transactions. However you could not apply any archived logs to the
>copied database. Please let me know if I've got it wrong.
>
>Thanks,
>Brandon
>
>
>----------
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Closson, Kevin A
>no, it will look like you powered off the system by physically
>pulling the electrical cord. It is restartable, but you can't use it
>on some other system and apply logs to roll it forward.
>
>
>----------
>From: amit poddar [mailto:amit.poddar_at_yale.edu]
>It would be like a shutdown abort copy right ?
>i.e when started oracle would do a crash recovery since the snapshot
>includes online logs.
>
>Privileged/Confidential Information may be contained in this message
>or attachments hereto. Please advise immediately if you or your
>employer do not consent to Internet email for messages of this kind.
>Opinions, conclusions and other information in this message that do
>not relate to the official business of this company shall be
>understood as neither given nor endorsed by it.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantscribbles.blogspot.com
and
http://hemantoracledba.blogspot.com

"First they ignore you, then they laugh at you, then they fight you, then you win" !"
Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html

--
http://www.freelists.org/webpage/oracle-l