Subject:RE: How to duplicate production database
onto development box
This will be ridiculous to hardcode this kind of
information. So if my
system crashed and I had to import a full
export into a new
machine, it's
not going to work
: How to duplicate production database
onto development box
Is there any need to create a standby database in this case?
My procedure
for copying production to development is:
1. alter database backup controlfile to trace; (in
production
]]
Sent: Wednesday, March 27, 2002 4:16 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: How to duplicate production database
onto development box
Is there any need to create a standby database in this case?
My
to duplicate production database
onto development box
This will be ridiculous to hardcode this kind of
information. So if my
system crashed and I had to import a full export into a new
machine, it's
not going to work?!!
I do
Title: How to duplicate production database onto development box
Hi!
We want to put an exact copy of our production database (approx. 200 GB) onto a development box. What would be the best way to achieve this? Export/import would take kinda long... ;)
Would transportable
production database onto development box
Hi!
We want to put an exact copy of our production database (approx. 200 GB)
onto a development box. What would be the best way to achieve this?
Export/import would take kinda long... ;)
Would transportable tablespaces be the way to go?
This is 8.1.7 on Sun
Title: How to duplicate production database onto development box
Hi
There are several ways to move a database :
1 : Shutdown the db and copy all the data files, redologfiles, control file
and the parameter file to the dev box then open the db.
2 : Take a online backup of the database
why not just copy over your complete hot backup? If you need it to be
as up to date as possible, you could do it as a standby database and
apply logs until you are ready and then open the standby database and
you will have an exact copy.
Transportable tablespaces have some caveats -- and the
On Tue, Mar 26, 2002 at 05:48:23AM -0800, Daiminger, Helmut wrote:
Hi!
We want to put an exact copy of our production database (approx. 200 GB)
onto a development box.
I use a warmbackup to do this on a regular basis. This takes
a long time, also, but it is pretty scriptable, so you don't
Title: How to duplicate production database onto development box
Just
copy the files over and recreate the control file.
Abraham
-Original Message-From: Daiminger, Helmut
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 26, 2002
7:48 AMTo: Multiple recipients of list ORACLE-LSubject
Title: How to duplicate production database onto development box
if you not affordable to a down time , may be hot
backups will help you out.
1. Copy the Hot backups to a different machine where
you want to have a duplicate database.
2. Edit the Init.Ora and control file
.
3. run the control
Title: How to duplicate production database onto development box
I use
a hot backup to create a standby database then apply logs to the
point
I want
to get a copy of production of a specific time.
Then
you can rename the database if you want to.
-Original Message-From: Guerra
Is there any need to create a standby database in this case? My procedure
for copying production to development is:
1. alter database backup controlfile to trace; (in production)
2. Restore a production backup (either hot or cold) to the development
server
3. Update database name and filenames
13 matches
Mail list logo
