Re: Copying database from one location to another

Hmmm if your source database is absolutely 24x7 then you must have it mirrored right? Probably even triple mirrored through something like EMC storage cabinets. Ok, since that's the case, then just break a mirror and copy all of your files to your target location and then re-silver your mirrors.

And since this is 24x7 you must also be doing regular hot backups. Couldn't you just take your hot backups and restore them to your target? You may have to set up some symbolic links in order to do the restore but then you could rename your datafiles if you wanted to get rid of the links - either using the sql command to rename or use the backup control file command to create a file that would allow you to rename your files and create new control files.

On the off hand chance that this is not a possibility, your best bet is to shut the DB down just long enough to copy all files to the target along with the result of a "backup control file to trace". You can use the backup control file to rename all files as needed. The technique to do this is available, I believe, at the ORACLE Tech Net site.

If you absolutely cannot take the DB down long enough to copy the files and you don't have it mirrored, and you're not doing hot backups, you might try the following ( while polishing up your resume for when the s--t hits the fan )

You could create the empty target database to size and then do a live "consistent" export and then import it into the target. I'm not sure why you need to do a recover to point in time but you should be able to use your archive logs being generated from your source to do this ( at least to a point in time past the point in time of the export - if you need it to a time prior to that ??? ) - although I've never tried it.

You might also be able to set up a "standby" recovery database this way and keep the target updated automatically.

You might also be able to set up a duplicate DB using advanced replication. Again, I've not done this and don't really know if the source would have to come down at some time during the set up of your target.

All of these techniques are too involved to include step by step instructions here but all of the information to do them is available in documentation from the ORACLE Tech Net site. I would suggest you try any of these on non-production, test databases prior to going for the real thing

HTH

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR, Dayton, OH

Opinions are my own and do not reflect those
of my employer or clients
"kush" <kdhakal_at_eline.com> wrote in message
news:tOUk6.96$kC2.3569_at_sea-read.news.verio.net...


> hi! Could anyone tell me what are the steps to create a database in new

> location by reusing

> the controlfiles, datafiles, redologfiles and arch. files(if needed) from

> another database in another location.

> This is more like copying database from one machine to another except the

> fact that

> a. I can't shutdown the original database and take a cold backup(it has to

> be up all the time) and its running in archivelogmode.

> b. when I create(recover) database at new location, I need to do point in

> time recovery.

>

> both machine has oracle 8.1.5 standard edition.

> Thanks in advance.

>

>

>