Re: Standby database on same machine

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Mon, 7 Dec 1998 22:41:29 -0800
Message-ID: <Pine.OSF.3.95.981207223349.27738A-100000@gonzo.wolfenet.com>

On Tue, 8 Dec 1998, David Sisk wrote:
>
> You can't have two Oracle instances with the same SID running on the same
> host.

You certainly can! It seems peculiar, but look at the LOCK_NAME_SPACE, DB_FILE_NAME_CONVERT, and LOG_FILE_NAME_CONVERT initialization parameters. They will allow you to run a second (standby if you want) database with the same SID on the same host.

If your main database is named foo, you can set the following parameters on your standby database's init.ora (start it up with "startup pfile=initsb_foo.ora"):

db_file_name_convert = (foo,sb_foo)
log_file_name_convert = (foo,sb_foo)
lock_name_space = sb_foo

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Tue Dec 08 1998 - 00:41:29 CST