Re: Oracle database transfer

> How can we transfer it form the testbed to the prodution area? There is no
> connection between the two domains, so anything transferred would have to
> done via tape. We don't have enterprise manager installed in either
domain,
> so the way I understand it we can't use the Export/Import utility. Would
it
> be possible to backup the database files and restore them to the
production
> environment?. If so which files would need backing up and where would they
> need to be restored? Can this be done using either an on-line or off-line
> backup, if so how can this be done?.

I don't see any reason why you can't use the Export/Import utility.

You must be kidding when you said "there is no connection between the two domains..." You wanted to setup a Standby database, right? You need the the two hosts to be connected or communicating on a network if you want to set up a Standby database.

There is also another option aside from using Import/Export. Use Rman to duplicate a database. The RMAN reference would provide you the details on how to duplicate a database or how to set up a Standby database. Received on Sun Oct 28 2001 - 01:25:37 CST