I have a test vserver and a production server both running linux. Currently a database has been created on the test server and is used for testing applications.
Now the databse is ready to be transferred to the production database. And it should function in the exact same way. the test server will keep running for test puurposes as and when changes need to be made, they will be made on the test database and only when fully tested willl the changes be implemented on the production box.
Whats the best way to transfer the database to the production env? WIll RMAn be good for the job or should i just use exp/imp utility and create the database instance at the destination and then import.
Could someone please help me with this situation. i am new to Oracle /Linux DBA stuff. And the vast amount to tools 7 utilitues RMAN/ exp-imp etc have got me confused. Please tlee me what the best option is./