Re: Backup & Recovery/Standby Server Question

From: Jeff <jeff_at_work.com>
Date: Fri, 01 Feb 2002 20:56:13 GMT
Message-ID: <a3evde$4ok$1@cronkite.cc.uga.edu>

In article <3c5aa7b4$1_1_at_corp-news.newsgroups.com>, "news4.sucknews.com" <bgt_0990_at_msn.com> wrote:
>I would think
>#2 Re-create the control file for the standby database.
>#3 alter database rename datafile from x to x

I think #3 wouldn't normally be necessary if it's already handled by the db_file_name_convert parameter. Maybe that's why the "alter database create datafile ... as ..." command is preferred... to avoid the situation where the datafile is added to a directory not handled by the conversion parameter above.

>the Alter Database command should occur at the primary server, then the dat
>file copied over to the stand by server

No. The datafile has already been created on the primary database... the alter database create datafile" adds it to the standby controlfile. Received on Fri Feb 01 2002 - 14:56:13 CST