Assuming you have two DB servers called Server1 and Server2 and you want to copy a database template called FahadDB from Server1 to Server2
Login to Server 1 as oracle
cd $ORACLE_HOME/assistants/dbca/templates
check the available templates.
Server1:(WhiteDG)$ ls -tlrh
total 112M
-rw-r--r-- 1 oracle oinstall 6.8M Jan 6 17:10 Seed_Database.ctl
-rw-r--r-- 1 oracle oinstall 5.6K Jan 6 17:10 Data_Warehouse.dbc
-rw-r--r-- 1 oracle oinstall 5.6K Jan 6 17:10 Transaction_Processing.dbc
-rw-r--r-- 1 oracle oinstall 92M Jan 6 17:10 Seed_Database.dfb
-rw-r----- 1 oracle oinstall 6.3K Jan 6 17:10 RecoCAT.dbc
-rw-r----- 1 oracle oinstall 6.2K Jan 6 17:10 White.dbc
-rw-r--r-- 1 oracle oinstall 12K Jan 6 17:10 New_Database.dbt
-rw-r----- 1 oracle oinstall 6.3K Jan 6 17:10 FahadDB.dbc
Now copy FahadDB.dbc template from Server1 to Server2.
Ex:
scp $ORACLE_HOME/assistants/dbca/templates/FahadDB.dbc Server2:$ORACLE_HOME/assistants/dbca/templates/.
Login to Server2 as oracle and verify $ORACLE_HOME/assistants/dbca/templates/FahadDB.dbc availability. Start DBCA and you will have your template.
No comments:
Post a Comment