Re: Duplicate database

From: sybrandb <sybrandb_at_gmail.com>
Date: Tue, 17 Jul 2007 04:10:56 -0700
Message-ID: <1184670656.614686.90970@g12g2000prg.googlegroups.com>

On Jul 17, 9:25 am, "astalavista" <nob..._at_nowhere.com> wrote:
> Hi,
>
> To duplicate a database on the same machine (not using RMAN)
>
> On UNIX, I can mount two times the same database
> if I rename lk* or sgadef*
>
> On Windows, no lk* or sgadef* ?
> How I can do that ?
>
> Can I do that with nid ?
>
> Oracle 9.2.0.6

read the documentation on nid, and on duplicating a database, and you'll find the obvious answer.

Use RMAN's duplicate database. It works: like a charm.

Hacking is not supported here. YOYO.

--
Sybrand Bakker
Senior Oracle DBA

Received on Tue Jul 17 2007 - 06:10:56 CDT