Yes it is quite possible to do just that.
The only thing is that you have to generate a "CREATE DATABASE" command
from the source DB by "ALTER DATABASE BACKUP CONTROLFILE TO TRACE" command.
Note the "CONTROLFILE" does not have a space in it !
You then alter the contents of the Trace file to SET
Hello again,
thanks all that have replied.
I have another question. Is it possible to clone a database just only through
OS operations? For example, is it possible to overwrite the files related
with one database (.dbf, .ctl..) with the one related with the database to
'clone'?
Maybe it sounds cr
AFAIK, RMAN has a duplicate command, which will initiate a backup, copy the
concerned datafiles onto the target host, and then perform an incomplete
recovery using the archived logs. This will also generate a unique DBID for
the new cloned database. I have never used this. But am curious to know
-L
With all my respect, this is not always the case
Best regards,
Serge
-Original Message-
Sent: Wednesday, January 09, 2002 10:15 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Clone a database
easier perhaps only if you have the exact same disk layouts and sp
list ORACLE-L
With all my respect, this is not always the case
Best regards,
Serge
-Original Message-
Sent: Wednesday, January 09, 2002 10:15 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Clone a database
easier perhaps only if you have the exact same disk layo
tp://www.speakeasy.net/~jwilton
>
> On Wed, 9 Jan 2002, Babich , Sergey wrote:
>
> > With all my respect, this is not always the case
> > Best regards,
> > Serge
> >
> > -Original Message-
> > Sent: Wednesday, January 09, 2002 10:15 AM
&
Thanks
-Original Message-
Sent: Wednesday, January 09, 2002 1:25 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Clone a database
This message uses a character set that is not supported by the Internet
Service. To view the original message content, open the
ents of list ORACLE-L
> Subject: RE: Clone a database
>
> easier perhaps only if you have the exact same disk layouts and space
> available.
>
> and certainly MUCH more time to create -- an import takes anywhere from
> 2-4 times as long as the export did.
>
> --- &qu
Hi,
If the backup was made using OEM, especially in later versions then the backup
is
a RMAN backup. Please look at your script contents to verify. The documentation
discusses how to use rman backups to clone a database.
John
[EMAIL PROTECTED] wrote:
easier perhaps only if you have the
I have test system (pandora) with the EXACT same disk layout as my production box.
I run the SQL below which generates a shell script.
While the DB is down for cold backups, I have the operator run clone-db.ksh;
which takes less time to complete than the backups.
Once it completes I just start th
With all my respect, this is not always the case
Best regards,
Serge
-Original Message-
Sent: Wednesday, January 09, 2002 10:15 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Clone a database
easier perhaps only if you have the exact same disk layouts and space
easier perhaps only if you have the exact same disk layouts and space
available.
and certainly MUCH more time to create -- an import takes anywhere from
2-4 times as long as the export did.
--- "Babich , Sergey" <[EMAIL PROTECTED]> wrote:
> Hi, Beatriz,
> If you want to create an identical copy
Hello Beatriz
Oracle 8i can export and import an entire tablespace and this is much
faster then regular export/import.
The procedure was published in XEPHON http://www.xephon.com.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: [EMAIL PROTECTED] [S
Hi, Beatriz,
If you want to create an identical copy of your production (that's my
understanding), it is a lot easier to export it (FULL=Y) and then import the
dump file into your new database. Let me know if you need more info.
Regards,
Sergey Babich, Oracle DBA
-Original Message-
Sent:
Have a look at None:73974.1 on Metalink. It give the step for cloning a
database from backups.
HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 09, 2002 4:50 AM
Hello list,
I new to clone a database for changing bet
Hi,
Just to be absolutely sure as to what you have got in terms of a backup,
please explain how exactly you obtained your backup from Enterprize Mgr.
Martin
-Original Message-
Martínez Jiménez
Sent: 09 January 2002 09:50
To: Multiple recipients of list ORACLE-L
Hello list,
I new to cl
16 matches
Mail list logo