- Start the Database Configuration Assistant (DBCA).
- On the "Welcome" screen click the "Next" button.
- On the "Operations" screen select the "Manage Templates" option and click the "Next" button.
- On the "Template Management" screen select the "Create a database template" option and select the "From and existing database (structure as well as data. you can also chose structure only )" sub-option then click the "Next" button.
- On the "Source database" screen select the relevant database instance and click the "Next" button.
- On the "Template properties" screen enter a suitable name and description for the template, confirm the location for the template files and click the "Next" button.
- On the "Location of database related files" screen choose either to maintain the file locations or to convert to OFA structure (recommended) and click the "Finish" button.
- On the "Confirmation" screen click the "OK" button.
- Wait while the Database Configuration Assistant progress screen gathers information about the source database, backs up the database and creates the template.
By default the template files are located in the ORACLE_HOME/assistants/dbca/templates" directory.
Now move the template into your destination machine and start DBCA. install database using that template
2 comments:
Thanks for sharing your info. I really appreciate your efforts and I will be waiting for your further write ups thanks once again.
similar post : Rman cloning using DUPLICATE command here
http://chandu208.blogspot.com/2011/12/11g-rman-cloning-using-duplicate.html
Post a Comment