hello,
i use ' dbca -silent -createTemplateFromDB -sourceDB host:port:sid -templateName sidbak -sysDBAUserName xxxxxx -sysDBAPassword xxxxxx' to generate template file,
such as,
[oracle@orcl13 ~]$ dbca -silent -createTemplateFromDB -sourceDB orcl13:1521:orcl13 -templateName orcl13bak -sysDBAUserName sys -sysDBAPassword sys
Creating a template from the database
10% complete
20% complete
30% complete
40% complete
50% complete
60% complete
70% complete
80% complete
90% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/silent.log_2017-08-10_04-44-42-PM" for further details.
later,i found that there is a template file 'orcl13bak.dbt' in '/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates', and why has no 'orcl13bak.ctl' or 'orcl13bak.dfb' about two seed template files ?
[oracle@orcl13 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/
[oracle@orcl13 templates]$ ls -lrht
total 295M
-rw-r--r-- 1 oracle oinstall 12K Apr 28 10:38 New_Database.dbt
-rwxr-xr-x 1 oracle oinstall 9.3M Apr 28 10:38 Seed_Database.ctl
-rwxr-xr-x 1 oracle oinstall 263M Apr 28 10:38 Seed_Database.dfb
-rw-r--r-- 1 oracle oinstall 5.0K Apr 28 10:38 Data_Warehouse.dbc
-rw-r--r-- 1 oracle oinstall 4.9K Apr 28 10:38 General_Purpose.dbc
-rwxr-xr-x 1 oracle oinstall 21M Apr 28 10:38 example01.dfb
-rwxr-xr-x 1 oracle oinstall 1.5M Apr 28 10:38 example.dmp
-rw-r----- 1 oracle oinstall 32K Aug 10 16:51 orcl13bak.dbt
because after installing oracle database software,there are some default template file 'General_Purpose.dbc','Seed_Database.ctl' and 'Seed_Database.dfb' and etc.
and in dbca of GUI (Graphical User Interface),it has option about 'from an existing database (structure as well as data)',if do this,could generate three template files of seed database.
my screenshot as follows,
please give me some advices about 'dbca -silent' mode,thanks!
Best Regards
Quanwen Zhao