RE: complicated

From: Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com>
Date: Wed, 19 Jul 2000 08:21:42 +0300
Message-Id: <10562.112374@fatcity.com>

Hi Ivan,

In fact, it is very easy to replicate the database.

Well...here it goes....

1. Shutdown the database, and copy all files viz. Control file, Database file, Redo log file, Initialization File, Password file from the production server.
2. Make the same directory structure on development server.
3. Copy the respective files on development server
4. Start the server, and it is ready for you.

This is the procedure if you had cold backup.

You can do it this still if you have hot backup. Just a matter of copy archived log files and recovering the database on development server.

Hope this clears your doubt.

Bye,

Regards,

Sandeep.

	-----Original Message-----
	From:	Ivan [SMTP:ivan_at_millenniumit.com]
	Sent:	Tuesday, July 18, 2000 12:09 PM
	To:	Sandeep Kurliye
	Subject:	Re: complicated

	hi Sandeep,
	can u send a detail mail on the steps...!!
	since this is my first time & i have 2 perform this in a client

site.........!!

	let me keep the existing database name........!!
	currently the 2 databases r having different db_names.....!!
	    eye1

	thankx

	Sandeep Kurliye wrote:



	> Yes... you can copy all database related files on development

server from


	> production one... and it will work.

	>

	> If you want to change db name then there is little bit difference

procedure


	> to do this....

	>

	> HTH,

	>

	> Sandeep.

	> Riyadh, Saudi Arabia.

	>

	>         -----Original Message-----

	>         From:   Ivan [SMTP:ivan_at_millenniumit.com]

	>         Sent:   Tuesday, July 18, 2000 11:47 AM

	>         To:     oracle_dba

	>         Subject:        complicated

	>

	>         hi,

	>         it may sound crazy.....??, but i thnik that there are

experts who


	> can do it.!!

	>

	>         1. we have 2 databases. pro-production & dev-development.

The


	> databases are entirely different...!!

	>         2. v have the cold backup of pro (datafiles,logs, control

	> files.....etc..etc).

	>         3. using the cold backup of pro can i restore it in dev

(or recreate


	> it in dev)..

	>

	>         looking forward for u're reply....!!

	>         thankx

	>             eye1

	>

	> --------

	> If you're bored, then visit the list's website:

http://www.lazydba.com (updated daily)


	> to unsubscribe, send a blank email to

oracledba-unsubscribe_at_quickdoc.co.uk Received on Wed Jul 19 2000 - 00:21:42 CDT