Database Administration (MOSC)

MOSC Banner

Question on Platform Migration Using Transportable Database.

edited Aug 27, 2014 5:01AM in Database Administration (MOSC) 11 commentsAnswered
Hi ,
I have a question on Platform Migration Using Transportable Database.      We have decided to do a target system migration.

We are using following command on Source.

% rman
RMAN> connect target /
RMAN> convert database on target platform
convert script ‘/tmp/convert_mydb.rman’
transport script '/tmp/transport_mydb.sql'
new database 'mydb'
format '/tmp/mydb%U'
db_file_name_convert '/u01/oradata/PROD/datafile','/tmp';

Once I am finished with this command.    I will copy all datafiles and other required files to target system.   

My question is , Once the copy of datafiles is done,     Can I start the source database?    Can I continue to work on source database ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center