First
u do not need logfiles for the standby database since it is not opened and
it is mount state.
2nd once u mount the database u can rename the datafile to which ever
location u have placed the datafile as
like
alter database rename datafile 'prod/path ' as 'standby/path '; or i think
it should be to instead of as check it out.
this u can do it when it says datafile not found.
mount the database and recover the database it will prompt saying that it
does not have the datafile,then u can rename the file
- Original Message -----
From: "Rahul" <rahul_at_ratelindo.co.id>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, December 15, 2000 3:22 AM
Subject: STANDBY DB - 2 questions
> List,
> i quick question... the Doc. does not mention anything
> regarding the online redo logs of STANDBY DB !!
>
> i have copied all the DB files to the standby host, but what about the
> online redo files of the standby DB ?? do i have to mount the
> standby DB WITHOUT any online redo logs (the standby controlfile takes
care
> of that ?)
>
> another question... i have different file locations on the standby host,
> WITHOUT using the db_file_name_convert, i HAVE to use the
> "create controlfile..." to correct the paths.. right ? now ...if i use
> "create controlfile..."
> option, i CANNOT use "alter database mount STANDBY database " !!!
> because the controlfle i'm using is not the standby controlfile !!
>
> i'm a little confused here...
> please advise
>
> Regards
>
> Rahul
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Dec 15 2000 - 07:01:50 CST
