dbca duplicate standby database

admin

1. dbca -silent -createDuplicateDB \
   
2. -gdbName chicago \
   
3. -sid boston \
   
4. -sysPassword welcome1 \
   
5. -primaryDBConnectionString exa503:1521/chicago \
   
6. -createAsStandby \
   
7. -dbUniqueName boston \
   
8. –initParams \
   
9. db_create_file_dest=+DATAC1,\
   
10. db_recovery_file_dest=+RECOC1,\
    
11. local_listener=”boston_local_listener”

复制代码

1. [oracle@vm2 dbs]$ dbca -silent -createDuplicateDB -gdbName ora19 -sid ora19 -sysPassword oracle -primaryDBConnectionString vm1:1519/ora19 -createAsStandby -dbUniqueName ora19b
   
2. Prepare for db operation
   
3. 22% complete
   
4. Listener config step
   
5. 44% complete
   
6. Auxiliary instance creation
   
7. 67% complete
   
8. RMAN duplicate
   
9. 89% complete
   
10. Post duplicate database operations
    
11. 100% complete
    
12. 
    
13. Look at the log file "/app/oracle/db/cfgtoollogs/dbca/ora19b/ora19b.log" for further details.
    

复制代码

1. $ dbca -silent -help
   
2. Usage: dbca [<flag>] [<command> <option>]
   
3. Following are the possible flags:
   
4. -help
   
5. -contextId <RAC | SI>
   
6. -ignorePreReqs - Ignore prerequisite checks for current operation.
   
7. -ignorePrereqFailure - Ignore all prerequisites failures.
   
8. -silent - This flag allows you to carry on configuration in silent mode.
   
9. -<command>
   
10. 
    
11. Following are the possible commands:
    
12. -addInstance - Command to Add an instance to an admin managed cluster database.
    
13. -configureDatabase - Command to Configure a database.
    
14. -configurePluggableDatabase - Command to Configure a pluggable database.
    
15. -createCloneTemplate - Command to Create a clone template from an existing database.
    
16. -createDatabase - Command to Create a database.
    
17. -createDuplicateDB - Command to Duplicate a database.
    
18. -createPluggableDatabase - Command to Create a pluggable database.
    
19. -createTemplateFromDB - Command to Create a template from an existing database.
    
20. -createTemplateFromTemplate - Command to Create a template from an existing template.
    
21. -deleteDatabase - Command to Delete a database.
    
22. -deleteInstance - Command to Delete an instance from an admin managed cluster database.
    
23. -deletePluggableDatabase - Command to Delete a pluggable database.
    
24. -deleteTemplate - Command to delete a template.
    
25. -executePrereqs - Command to execute prerequisite checks.
    
26. -generateScripts - Command to Generate scripts which can be used to create database.
    
27. -relocatePDB - Command to Relocate a pluggable database.
    
28. -unplugDatabase - Command to Unplug a pluggable database.
    
29. 
    
30. $ dbca -help -silent
    
31. Usage: dbca [<flag>] [<command> <option>]
    
32. Following are the possible flags:
    
33. -help
    
34. -contextId <RAC | SI>
    
35. -ignorePreReqs - Ignore prerequisite checks for current operation.
    
36. -ignorePrereqFailure - Ignore all prerequisites failures.
    
37. -silent - This flag allows you to carry on configuration in silent mode.
    
38. -<command>
    
39. 
    
40. Following are the possible commands:
    
41. -addInstance - Command to Add an instance to an admin managed cluster database.
    
42. -configureDatabase - Command to Configure a database.
    
43. -configurePluggableDatabase - Command to Configure a pluggable database.
    
44. -createCloneTemplate - Command to Create a clone template from an existing database.
    
45. -createDatabase - Command to Create a database.
    
46. -createDuplicateDB - Command to Duplicate a database.
    
47. -createPluggableDatabase - Command to Create a pluggable database.
    
48. -createTemplateFromDB - Command to Create a template from an existing database.
    
49. -createTemplateFromTemplate - Command to Create a template from an existing template.
    
50. -deleteDatabase - Command to Delete a database.
    
51. -deleteInstance - Command to Delete an instance from an admin managed cluster database.
    
52. -deletePluggableDatabase - Command to Delete a pluggable database.
    
53. -deleteTemplate - Command to delete a template.
    
54. -executePrereqs - Command to execute prerequisite checks.
    
55. -generateScripts - Command to Generate scripts which can be used to create database.
    
56. -relocatePDB - Command to Relocate a pluggable database.
    
57. -unplugDatabase - Command to Unplug a pluggable database.
    
58. 
    
59. $ dbca -help -addInstance
    
60. -addInstance - Command to Add an instance to an admin managed cluster database.
    
61. -gdbName <Global database name>
    
62. -nodeName <Node name of the new instance that has to be added or existing instance that has to be removed>
    
63. [-updateDirService <true | false>]
    
64. -dirServicePassword <Password for directory service>
    
65. -dirServiceUserName <User name for directory service>
    
66. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
    
67. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
    
68. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
    
69. [-instanceName <Name of an Instance to add or delete>]
    
70. [-sysDBAUserName <User name with SYSDBA privileges>]
    
71. [-sysDBAPassword <Password for sysDBAUserName user name>]
    
72. 
    
73. $ dbca -help -configureDatabase
    
74. -configureDatabase - Command to Configure a database.
    
75. -sourceDB <Database unique name for RAC database or SID for Single Instance database>
    
76. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
    
77. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
    
78. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
    
79. [-olsConfiguration <true | false> Specify true to configure and enable Oracle Label Security.]
    
80. [-configureWithOID This flag configures Oracle Label Security with OID.]
    
81. [-moveDatabaseFiles <Move database files from one storage location to other. For example ASM to FS, FS to ASM>]
    
82. -datafileDestination <Destination directory for all database files>
    
83. -sourceDB <Database unique name for RAC database or SID for Single Instance database>
    
84. [-initParams <Comma separated list of name=value pairs>]
    
85. [-initParamsEscapeChar <Specify escape character for comma when a specific initParam has multiple values.If the escape character is not specified backslash is the default escape character>]
    
86. [-recoveryAreaDestination <Destination directory for all recovery files. Specify "NONE" for disabling Fast Recovery Area>]
    
87. [-recoveryAreaSize <Fast Recovery Area Size in MB>]
    
88. [-useOMF <true | false> Specify true to use Oracle-Managed Files.]
    
89. [-recoveryAreaSize <Fast Recovery Area Size in MB>]
    
90. [-configureOracleR <Configure Oracle R in the database.>]
    
91. [-oracleRConfigTablespace <Specify the tablespace to be used for Oracle R configuration. For example SYSAUX>]
    
92. [-dvConfiguration <true | false> Specify true to configure and enable database vault.]
    
93. -dvUserName <Specify database vault owner user name>
    
94. -dvUserPassword <Specify database vault owner password>
    
95. [-dvAccountManagerPassword <Specify database vault account manager password>]
    
96. [-dvAccountManagerName <Specify separate database vault account manager>]
    
97. [-registerWithDirService | -unregisterWithDirService | -regenerateDBPassword]
    
98. [-registerWithDirService <true | false>]
    
99. -dirServiceUserName <User name for directory service>
    
100. [-databaseCN <Database common name>]
     
101. [-dirServiceCertificatePath <Path to the certificate file to use when configuring SSL between database and directory service>]
     
102. [-dirServicePassword <Password for directory service>]
     
103. [-dirServiceUser <SamAccountName in case of configuring Active Directory>]
     
104. [-ldapDirectoryAccessType <PASSWORD | SSL>]
     
105. [-useSYSAuthForLDAPAccess <true | false>]
     
106. [-walletPassword <Password for database wallet>]
     
107. [-unregisterWithDirService <true | false>]
     
108. -dirServiceUserName <User name for directory service>
     
109. [-dirServicePassword <Password for directory service>]
     
110. [-walletPassword <Password for database wallet>]
     
111. [-regenerateDBPassword <true | false>]
     
112. [-addDBOption <Specify any of the following DB Options as a comma separated list: JSERVER | ORACLE_TEXT | IMEDIA | CWMLITE | SPATIAL | OMS | APEX | DV>]
     
113. [-sysDBAUserName <User name with SYSDBA privileges>]
     
114. [-sysDBAPassword <Password for sysDBAUserName user name>]
     
115. 
     
116. $ dbca -help -configurePluggableDatabase
     
117. -configurePluggableDatabase - Command to Configure a pluggable database.
     
118. -pdbName <Pluggable database name>
     
119. -sourceDB <Database unique name for RAC database or SID for Single Instance database>
     
120. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
     
121. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
     
122. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
     
123. [-olsConfiguration <true | false> Specify true to configure and enable Oracle Label Security.]
     
124. [-configureWithOID This flag configures Oracle Label Security with OID.]
     
125. [-lbacsysPassword <LBACSYS user Password is required for configuring OLS with directory service>]
     
126. [-configureOracleR <Configure Oracle R in the database.>]
     
127. [-oracleRConfigTablespace <Specify the tablespace to be used for Oracle R configuration. For example SYSAUX>]
     
128. [-dvConfiguration <true | false> Specify true to configure and enable database vault.]
     
129. -dvUserName <Specify database vault owner user name>
     
130. -dvUserPassword <Specify database vault owner password>
     
131. [-dvAccountManagerPassword <Specify database vault account manager password>]
     
132. [-dvAccountManagerName <Specify separate database vault account manager>]
     
133. [-registerWithDirService | -unregisterWithDirService | -regenerateDBPassword]
     
134. [-registerWithDirService <true | false>]
     
135. -dirServiceUserName <User name for directory service>
     
136. [-dirServiceUser <SamAccountName in case of configuring Active Directory>]
     
137. [-dirServicePassword <Password for directory service>]
     
138. [-databaseCN <Database common name>]
     
139. [-dirServiceCertificatePath <Path to the certificate file to use when configuring SSL between database and directory service>]
     
140. [-walletPassword <Password for database wallet>]
     
141. [-unregisterWithDirService <true | false>]
     
142. -dirServiceUserName <User name for directory service>
     
143. [-dirServicePassword <Password for directory service>]
     
144. [-walletPassword <Password for database wallet>]
     
145. [-regenerateDBPassword <true | false>]
     
146. 
     
147. $ dbca -help -createCloneTemplate
     
148. -createCloneTemplate - Command to Create a clone template from an existing database.
     
149. -sourceSID | -sourceDB
     
150. -sourceSID <Database unique name for RAC database and SID for Single Instance database>
     
151. -sourceDB <Database unique name for RAC database or SID for Single Instance database>
     
152. -templateName <Specify an existing template in default location or the complete template path for DB Creation or provide a new template name for template creation>
     
153. [-promptForWalletPassword - Prompt for wallet password.]
     
154. [-rmanParallelism <Parallelism value>]
     
155. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
     
156. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
     
157. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
     
158. [-maxBackupSetSizeInMB <Maximum backup set size in MB>]
     
159. [-compressBackup <true | false> Specify true to compress the backup.]
     
160. [-dataFileBackup <true | false> When "false" is passed create clone template without data file backup. Default value is true.]
     
161. [-datafileJarLocation <For database creation, pass the absolute path of the datafile backup and for template creation, pass the directory to place the datafile backup>]
     
162. [-sysDBAUserName <User name with SYSDBA privileges>]
     
163. [-maintainFileLocations <true | false>]
     
164. [-sysDBAPassword <Password for sysDBAUserName user name>]
     
165. [-walletPassword <Password for database wallet>]
     
166. 
     
167. $ dbca -help -createDatabase
     
168. -createDatabase - Command to Create a database.
     
169. -responseFile | (-gdbName,-templateName)
     
170. -responseFile - <Fully qualified path for a response file>
     
171. -gdbName <Global database name>
     
172. -templateName <Specify an existing template in default location or the complete template path for DB Creation or provide a new template name for template creation>
     
173. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
     
174. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
     
175. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
     
176. [-characterSet <Character set for the database>]
     
177. [-dvConfiguration <true | false> Specify true to configure and enable database vault.]
     
178. -dvUserName <Specify database vault owner user name>
     
179. -dvUserPassword <Specify database vault owner password>
     
180. [-dvAccountManagerPassword <Specify database vault account manager password>]
     
181. [-dvAccountManagerName <Specify separate database vault account manager>]
     
182. [-datafileDestination <Destination directory for all database files>]
     
183. [-datafileJarLocation <For database creation, pass the absolute path of the datafile backup and for template creation, pass the directory to place the datafile backup>]
     
184. [-runCVUChecks <Specify "true" in order to run Cluster Verification Utility checks periodically for RAC databases.>]
     
185. [-sid <Database system identifier>]
     
186. [-redoLogFileSize <Size of each redo log file in MB>]
     
187. [-registerWithDirService <true | false>]
     
188. -dirServiceUserName <User name for directory service>
     
189. [-databaseCN <Database common name>]
     
190. [-dirServiceCertificatePath <Path to the certificate file to use when configuring SSL between database and directory service>]
     
191. [-dirServicePassword <Password for directory service>]
     
192. [-dirServiceUser <SamAccountName in case of configuring Active Directory>]
     
193. [-ldapDirectoryAccessType <PASSWORD | SSL>]
     
194. [-useSYSAuthForLDAPAccess <true | false>]
     
195. [-walletPassword <Password for database wallet>]
     
196. [-systemPassword <SYSTEM user password>]
     
197. [-nodelist <Node names separated by comma for the database>]
     
198. [-oracleHomeUserPassword <Specify Oracle Home User Password>]
     
199. [-sysPassword <SYS user password>]
     
200. [-enableArchive <true | false> Specify true to enable archive>]
     
201. [-archiveLogMode <AUTO|MANUAL , the default is Automatic archiving>]
     
202. [-archiveLogDest <Specify archive log destinations separated by comma. If archive log destination is not specified, fast recovery area location will be used for archive log files.>]
     
203. [-memoryMgmtType <AUTO|AUTO_SGA|CUSTOM_SGA>]
     
204. [-variables <Comma separated list of name=value pairs of location variables>]
     
205. [-listeners <A comma separated list of listeners that the database can be configured with>]
     
206. [-olsConfiguration <true | false> Specify true to configure and enable Oracle Label Security.]
     
207. [-configureWithOID This flag configures Oracle Label Security with OID.]
     
208. [-createAsContainerDatabase <true | false>]
     
209. [-pdbName <Pluggable database name>]
     
210. [-numberOfPDBs <Number of pluggable databases to be created, default is 0>]
     
211. [-pdbStorageMAXSizeInMB <value>]
     
212. [-pdbStorageMAXTempSizeInMB <value>]
     
213. [-useLocalUndoForPDBs <true | false> Specify false to disable local undo tablespace for PDBs.]
     
214. [-pdbAdminPassword <PDB Administrator user Password, required only while creating new PDB>]
     
215. [-pdbOptions <A comma separated list of name:value pairs with database options to enable/disable. For example JSERVER:true,DV:false>]
     
216. [-recoveryAreaDestination <Destination directory for all recovery files. Specify "NONE" for disabling Fast Recovery Area>]
     
217. [-recoveryAreaSize <Fast Recovery Area Size in MB>]
     
218. [-createListener <Create a new listener to register your database. Specify in format, LISTENER_NAME:PORT>]
     
219. [-useOMF <true | false> Specify true to use Oracle-Managed Files.]
     
220. [-memoryPercentage | -totalMemory]
     
221. [-memoryPercentage <Percentage of physical memory for oracle database>]
     
222. [-totalMemory <Memory allocated for Oracle in MB>]
     
223. [-dbOptions <A comma separated list of name:value pairs with database options to enable/disable. For example JSERVER:true,DV:false>]
     
224. [-sampleSchema <true | false>]
     
225. [-variablesFile <File name of the name=value pairs for location variables in the template>]
     
226. [-customScripts <A comma separated list of SQL scripts which needs to be run post db creation.The scripts are run in order they are listed>]
     
227. [-databaseType <MULTIPURPOSE | DATA_WAREHOUSING | OLTP>]
     
228. [-oracleHomeUserName <Specify Oracle Home User Name>]
     
229. [-initParams <Comma separated list of name=value pairs>]
     
230. [-initParamsEscapeChar <Specify escape character for comma when a specific initParam has multiple values.If the escape character is not specified backslash is the default escape character>]
     
231. [-policyManaged | -adminManaged]
     
232. [-policyManaged <Policy managed database, default option is Admin managed database>]
     
233. -serverPoolName <Specify the single server pool name in case of create server pool or comma separated list in case of existing server pools>
     
234. [-pqPoolName <value>]
     
235. [-createServerPool <Create a new server pool, which will be used by the database>]
     
236. [-pqPoolName <value>]
     
237. [-forceServerPoolCreation <To create server pool by force when adequate free servers are not available. This may affect the database which is already in running mode>]
     
238. [-pqCardinality <value>]
     
239. [-cardinality <Specify the cardinality of the new server pool that is to be created, default is the number of qualified nodes>]
     
240. [-adminManaged <Admin managed database, this is default option>]
     
241. [-nationalCharacterSet <National character set for the database>]
     
242. [-storageType < FS | ASM >]
     
243. -datafileDestination <Destination directory for all database files>
     
244. [-asmsnmpPassword <ASMSNMP password for ASM monitoring>]
     
245. [-databaseConfigType <SINGLE | RAC | RACONENODE>]
     
246. [-RACOneNodeServiceName <Service name for the service to be created for RAC One Node database. This option is mandatory when the databaseConfigType is RACONENODE>]
     
247. [-emConfiguration <DBEXPRESS | CENTRAL | BOTH | NONE>]
     
248. [-dbsnmpPassword <DBSNMP user password>]
     
249. [-emPassword <EM Admin user password>]
     
250. [-emUser <EM Admin username to add or modify targets>]
     
251. [-emExpressPort <EM database express port number. Generally used during createDatabase>]
     
252. [-omsHost <EM management server host name>]
     
253. [-omsPort <EM management server port number>]
     
254. [-emExpressPortAsGlobalPort <value>]
     
255. 
     
256. $ dbca -help -createDuplicateDB
     
257. -createDuplicateDB - Command to Duplicate a database.
     
258. -gdbName <Global database name>
     
259. -primaryDBConnectionString <EZCONNECT string to connect to primary database for example "host:port/servicename">
     
260. -sid <Database system identifier>
     
261. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
     
262. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
     
263. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
     
264. [-initParams <Comma separated list of name=value pairs>]
     
265. [-initParamsEscapeChar <Specify escape character for comma when a specific initParam has multiple values.If the escape character is not specified backslash is the default escape character>]
     
266. [-policyManaged | -adminManaged]
     
267. [-policyManaged <Policy managed database, default option is Admin managed database>]
     
268. -serverPoolName <Specify the single server pool name in case of create server pool or comma separated list in case of existing server pools>
     
269. [-pqPoolName <value>]
     
270. [-createServerPool <Create a new server pool, which will be used by the database>]
     
271. [-pqPoolName <value>]
     
272. [-forceServerPoolCreation <To create server pool by force when adequate free servers are not available. This may affect the database which is already in running mode>]
     
273. [-pqCardinality <value>]
     
274. [-cardinality <Specify the cardinality of the new server pool that is to be created, default is the number of qualified nodes>]
     
275. [-adminManaged <Admin managed database, this is default option>]
     
276. [-datafileDestination <Destination directory for all database files>]
     
277. [-nodelist <Node names separated by comma for the database>]
     
278. [-databaseConfigType <SINGLE | RAC | RACONENODE>]
     
279. [-RACOneNodeServiceName <Service name for the service to be created for RAC One Node database. This option is mandatory when the databaseConfigType is RACONENODE>]
     
280. [-createAsStandby <Option to create a standby database>]
     
281. [-dbUniqueName <db_unique_name for standby db>]
     
282. [-customScripts <A comma separated list of SQL scripts which needs to be run post db creation.The scripts are run in order they are listed>]
     
283. 
     
284. $ dbca -help -createPluggableDatabase
     
285. -createPluggableDatabase - Command to Create a pluggable database.
     
286. -pdbName <Pluggable database name>
     
287. -sourceDB <Database unique name for RAC database or SID for Single Instance database>
     
288. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
     
289. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
     
290. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
     
291. [-pdbStorageMAXSizeInMB <value>]
     
292. [-useMetaDataFileLocation <true | false> Specify true if datafile path defined in metadata file within PDB archive file is to be used while extracting datafiles.]
     
293. [-dvConfiguration <true | false> Specify true to configure and enable database vault.]
     
294. -dvUserName <Specify database vault owner user name>
     
295. -dvUserPassword <Specify database vault owner password>
     
296. [-dvAccountManagerPassword <Specify database vault account manager password>]
     
297. [-dvAccountManagerName <Specify separate database vault account manager>]
     
298. [-pdbStorageMAXTempSizeInMB <value>]
     
299. [-createAsClone <true | false> Create PDB as clone. When "true" is passed a new PDB GUID is generated for the plugged PDB]
     
300. [-createUserTableSpace <true | false> Specify true if a default user tablespace need to be created in new PDB.]
     
301. [-pdbUseMultipleBackup <value>]
     
302. [-customScripts <A comma separated list of SQL scripts which needs to be run post db creation.The scripts are run in order they are listed>]
     
303. [-createPDBFrom <DEFAULT | FILEARCHIVE | RMANBACKUP | USINGXML | PDB>]
     
304. [-createNewPDBAdminUser <Specify this argument if a new PDB Administrator user needs to be created after plugging in PDB from Archive or File Set>]
     
305. [-fileNameConvert <This clause specifies how to generate names of files>]
     
306. [-pdbAdminUserName <PDB Administrator user name, required only while creating new PDB>]
     
307. [-sourceFileNameConvert <This clause specifies how to locate files listed in PDB XML metadata file>]
     
308. [-pdbStorageMAXSizeInMB <value>]
     
309. [-pdbStorageMAXTempSizeInMB <value>]
     
310. [-workArea <Specify a location which can be used to unzip PDB archive files (required when createPDBFrom is FILEARCHIVE)>]
     
311. [-sourcePDB <value>]
     
312. [-copyPDBFiles <true | false> Specify true if PDB datafiles need to be copied]
     
313. [-pdbArchiveFile <Absolute file path and name for PDB Archive file. Optional field during CreatePluggableDatabase/UnplugDatabase>]
     
314. [-pdbBackUpfile <Absolute file path and name for PDB backup file, required when archive type is RMAN (specify comma separated paths if there are multiple backups when creating PDB).>]
     
315. [-pdbMetadataFile <Absolute file path and name for PDB metadata file, required when archive type is RMAN or NONE. Optional field during CreatePluggableDatabase/UnplugDatabase>]
     
316. [-pdbAdminPassword <PDB Administrator user Password, required only while creating new PDB>]
     
317. [-registerWithDirService <true | false>]
     
318. -dirServiceUserName <User name for directory service>
     
319. [-dirServiceUser <SamAccountName in case of configuring Active Directory>]
     
320. [-dirServicePassword <Password for directory service>]
     
321. [-databaseCN <Database common name>]
     
322. [-dirServiceCertificatePath <Path to the certificate file to use when configuring SSL between database and directory service>]
     
323. [-walletPassword <Password for database wallet>]
     
324. [-lbacsysPassword <LBACSYS user Password is required for configuring OLS with directory service>]
     
325. [-createFromRemotePDB <Create a pluggable database from Remote PDB clone operation.>]
     
326. -remotePDBName <Name of the pluggable database to clone/relocate>
     
327. -dbLinkUsername <Common user of a remote CDB, used by database link to connect to remote CDB.>
     
328. -remoteDBConnString <EZCONNECT string to connect to Source database for example "host:port/servicename">
     
329. [-remoteDBSYSDBAUserName <User name with SYSDBA privileges of remote database>]
     
330. [-dbLinkUserPassword <Common user password of a remote CDB, used by database link to connect to remote CDB.>]
     
331. [-remoteDBSYSDBAUserPassword <Password for remoteDBSYSDBAUserName user of remote database.>]
     
332. [-sysDBAUserName <User name with SYSDBA privileges>]
     
333. [-sysDBAPassword <Password for sysDBAUserName user name>]
     
334. [-pdbDatafileDestination <PDB datafile area>]
     
335. 
     
336. $ dbca -help -createTemplateFromDB
     
337. -createTemplateFromDB - Command to Create a template from an existing database.
     
338. -templateName <Specify an existing template in default location or the complete template path for DB Creation or provide a new template name for template creation>
     
339. -sourceDB <Database unique name for RAC database or SID for Single Instance database>
     
340. [-connectionString <EZCONNECT string to connect to remote database for example "host:port/servicename">]
     
341. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
     
342. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
     
343. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
     
344. [-sysDBAUserName <User name with SYSDBA privileges>]
     
345. [-maintainFileLocations <true | false>]
     
346. [-sysDBAPassword <Password for sysDBAUserName user name>]
     
347. 
     
348. $ dbca -help -createTemplateFromTemplate
     
349. -createTemplateFromTemplate - Command to Create a template from an existing template.
     
350. -sourceTemplateName <Name of an existing template in default location or the complete template path>
     
351. -templateName <Specify an existing template in default location or the complete template path for DB Creation or provide a new template name for template creation>
     
352. [-variables <Comma separated list of name=value pairs of location variables>]
     
353. [-characterSet <Character set for the database>]
     
354. [-recoveryAreaDestination <Destination directory for all recovery files. Specify "NONE" for disabling Fast Recovery Area>]
     
355. [-recoveryAreaSize <Fast Recovery Area Size in MB>]
     
356. [-datafileDestination <Destination directory for all database files>]
     
357. [-useOMF <true | false> Specify true to use Oracle-Managed Files.]
     
358. [-datafileJarLocation <For database creation, pass the absolute path of the datafile backup and for template creation, pass the directory to place the datafile backup>]
     
359. [-memoryPercentage | -totalMemory]
     
360. [-memoryPercentage <Percentage of physical memory for oracle database>]
     
361. [-totalMemory <Memory allocated for Oracle in MB>]
     
362. [-dbOptions <A comma separated list of name:value pairs with database options to enable/disable. For example JSERVER:true,DV:false>]
     
363. [-variablesFile <File name of the name=value pairs for location variables in the template>]
     
364. [-redoLogFileSize <Size of each redo log file in MB>]
     
365. [-initParams <Comma separated list of name=value pairs>]
     
366. [-initParamsEscapeChar <Specify escape character for comma when a specific initParam has multiple values.If the escape character is not specified backslash is the default escape character>]
     
367. [-nationalCharacterSet <National character set for the database>]
     
368. [-storageType < FS | ASM >]
     
369. -datafileDestination <Destination directory for all database files>
     
370. [-asmsnmpPassword <ASMSNMP password for ASM monitoring>]
     
371. [-enableArchive <true | false> Specify true to enable archive>]
     
372. [-archiveLogMode <AUTO|MANUAL , the default is Automatic archiving>]
     
373. [-archiveLogDest <Specify archive log destinations separated by comma. If archive log destination is not specified, fast recovery area location will be used for archive log files.>]
     
374. [-memoryMgmtType <AUTO|AUTO_SGA|CUSTOM_SGA>]
     
375. 
     
376. $ dbca -help -deleteDatabase
     
377. -deleteDatabase - Command to Delete a database.
     
378. -sourceDB <Database unique name for RAC database or SID for Single Instance database>
     
379. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
     
380. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
     
381. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
     
382. [-unregisterWithDirService <true | false>]
     
383. -dirServiceUserName <User name for directory service>
     
384. [-dirServicePassword <Password for directory service>]
     
385. [-walletPassword <Password for database wallet>]
     
386. [-deRegisterEMCloudControl ]
     
387. -emUser <EM Admin username to add or modify targets>
     
388. -omsHost <EM management server host name>
     
389. -omsPort <EM management server port number>
     
390. [-emPassword <EM Admin user password>]
     
391. [-sysDBAUserName <User name with SYSDBA privileges>]
     
392. [-forceArchiveLogDeletion <To delete archive logs of a database>]
     
393. [-sysDBAPassword <Password for sysDBAUserName user name>]
     
394. [-sid <Database system identifier>]
     
395. 
     
396. $ dbca -help -deleteInstance
     
397. -deleteInstance - Command to Delete an instance from an admin managed cluster database.
     
398. -gdbName <Global database name>
     
399. -instanceName <Name of an Instance to add or delete>
     
400. [-nodeName <Node name of the new instance that has to be added or existing instance that has to be removed>]
     
401. [-updateDirService <true | false>]
     
402. -dirServicePassword <Password for directory service>
     
403. -dirServiceUserName <User name for directory service>
     
404. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
     
405. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
     
406. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
     
407. [-sysDBAUserName <User name with SYSDBA privileges>]
     
408. [-sysDBAPassword <Password for sysDBAUserName user name>]
     
409. 
     
410. $ dbca -silent -deletePluggableDatabase
     
411. [INS-04008] Invalid combination of arguments passed from command line. One or more mandatory dependent arguments are not passed for the argument: -deletePluggableDatabase
     
412. -deletePluggableDatabase - Command to Delete a pluggable database.
     
413. -pdbName <Pluggable database name>
     
414. -sourceDB <Database unique name for RAC database or SID for Single Instance database>
     
415. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
     
416. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
     
417. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
     
418. [-sysDBAUserName <User name with SYSDBA privileges>]
     
419. [-sysDBAPassword <Password for sysDBAUserName user name>]
     
420. 
     
421. $ dbca -help -deletePluggableDatabase
     
422. -deletePluggableDatabase - Command to Delete a pluggable database.
     
423. -pdbName <Pluggable database name>
     
424. -sourceDB <Database unique name for RAC database or SID for Single Instance database>
     
425. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
     
426. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
     
427. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
     
428. [-sysDBAUserName <User name with SYSDBA privileges>]
     
429. [-sysDBAPassword <Password for sysDBAUserName user name>]
     
430. 
     
431. $ dbca -help -deleteTemplate
     
432. -deleteTemplate - Command to delete a template.
     
433. -templateName <Specify an existing template in default location or the complete template path for DB Creation or provide a new template name for template creation>
     
434. 
     
435. $ dbca -help -executePrereqs
     
436. -executePrereqs - Command to execute prerequisite checks.
     
437. -databaseConfigType <SINGLE | RAC | RACONENODE>
     
438. [-RACOneNodeServiceName <Service name for the service to be created for RAC One Node database. This option is mandatory when the databaseConfigType is RACONENODE>]
     
439. [-nodelist <Node names separated by comma for the database>]
     
440. 
     
441. $ dbca -help -generateScripts
     
442. -generateScripts - Command to Generate scripts which can be used to create database.
     
443. -gdbName <Global database name>
     
444. -templateName <Specify an existing template in default location or the complete template path for DB Creation or provide a new template name for template creation>
     
445. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
     
446. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
     
447. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
     
448. [-characterSet <Character set for the database>]
     
449. [-dvConfiguration <true | false> Specify true to configure and enable database vault.]
     
450. -dvUserName <Specify database vault owner user name>
     
451. -dvUserPassword <Specify database vault owner password>
     
452. [-dvAccountManagerPassword <Specify database vault account manager password>]
     
453. [-dvAccountManagerName <Specify separate database vault account manager>]
     
454. [-scriptDest <Destination for all the scriptfiles>]
     
455. [-datafileDestination <Destination directory for all database files>]
     
456. [-datafileJarLocation <For database creation, pass the absolute path of the datafile backup and for template creation, pass the directory to place the datafile backup>]
     
457. [-runCVUChecks <Specify "true" in order to run Cluster Verification Utility checks periodically for RAC databases.>]
     
458. [-sid <Database system identifier>]
     
459. [-redoLogFileSize <Size of each redo log file in MB>]
     
460. [-registerWithDirService <true | false>]
     
461. -dirServiceUserName <User name for directory service>
     
462. [-databaseCN <Database common name>]
     
463. [-dirServiceCertificatePath <Path to the certificate file to use when configuring SSL between database and directory service>]
     
464. [-dirServicePassword <Password for directory service>]
     
465. [-dirServiceUser <SamAccountName in case of configuring Active Directory>]
     
466. [-ldapDirectoryAccessType <PASSWORD | SSL>]
     
467. [-useSYSAuthForLDAPAccess <true | false>]
     
468. [-walletPassword <Password for database wallet>]
     
469. [-systemPassword <SYSTEM user password>]
     
470. [-nodelist <Node names separated by comma for the database>]
     
471. [-sysPassword <SYS user password>]
     
472. [-enableArchive <true | false> Specify true to enable archive>]
     
473. [-archiveLogMode <AUTO|MANUAL , the default is Automatic archiving>]
     
474. [-archiveLogDest <Specify archive log destinations separated by comma. If archive log destination is not specified, fast recovery area location will be used for archive log files.>]
     
475. [-memoryMgmtType <AUTO|AUTO_SGA|CUSTOM_SGA>]
     
476. [-responseFile - <Fully qualified path for a response file>]
     
477. [-variables <Comma separated list of name=value pairs of location variables>]
     
478. [-listeners <A comma separated list of listeners that the database can be configured with>]
     
479. [-olsConfiguration <true | false> Specify true to configure and enable Oracle Label Security.]
     
480. [-configureWithOID This flag configures Oracle Label Security with OID.]
     
481. [-createAsContainerDatabase <true | false>]
     
482. [-pdbName <Pluggable database name>]
     
483. [-numberOfPDBs <Number of pluggable databases to be created, default is 0>]
     
484. [-pdbStorageMAXSizeInMB <value>]
     
485. [-pdbStorageMAXTempSizeInMB <value>]
     
486. [-useLocalUndoForPDBs <true | false> Specify false to disable local undo tablespace for PDBs.]
     
487. [-pdbAdminPassword <PDB Administrator user Password, required only while creating new PDB>]
     
488. [-pdbOptions <A comma separated list of name:value pairs with database options to enable/disable. For example JSERVER:true,DV:false>]
     
489. [-recoveryAreaDestination <Destination directory for all recovery files. Specify "NONE" for disabling Fast Recovery Area>]
     
490. [-recoveryAreaSize <Fast Recovery Area Size in MB>]
     
491. [-createListener <Create a new listener to register your database. Specify in format, LISTENER_NAME:PORT>]
     
492. [-useOMF <true | false> Specify true to use Oracle-Managed Files.]
     
493. [-memoryPercentage | -totalMemory]
     
494. [-memoryPercentage <Percentage of physical memory for oracle database>]
     
495. [-totalMemory <Memory allocated for Oracle in MB>]
     
496. [-sampleSchema <true | false>]
     
497. [-variablesFile <File name of the name=value pairs for location variables in the template>]
     
498. [-customScripts <A comma separated list of SQL scripts which needs to be run post db creation.The scripts are run in order they are listed>]
     
499. [-databaseType <MULTIPURPOSE | DATA_WAREHOUSING | OLTP>]
     
500. [-initParams <Comma separated list of name=value pairs>]
     
501. [-initParamsEscapeChar <Specify escape character for comma when a specific initParam has multiple values.If the escape character is not specified backslash is the default escape character>]
     
502. [-policyManaged | -adminManaged]
     
503. [-policyManaged <Policy managed database, default option is Admin managed database>]
     
504. -serverPoolName <Specify the single server pool name in case of create server pool or comma separated list in case of existing server pools>
     
505. [-pqPoolName <value>]
     
506. [-createServerPool <Create a new server pool, which will be used by the database>]
     
507. [-pqPoolName <value>]
     
508. [-forceServerPoolCreation <To create server pool by force when adequate free servers are not available. This may affect the database which is already in running mode>]
     
509. [-pqCardinality <value>]
     
510. [-cardinality <Specify the cardinality of the new server pool that is to be created, default is the number of qualified nodes>]
     
511. [-adminManaged <Admin managed database, this is default option>]
     
512. [-nationalCharacterSet <National character set for the database>]
     
513. [-storageType < FS | ASM >]
     
514. -datafileDestination <Destination directory for all database files>
     
515. [-asmsnmpPassword <ASMSNMP password for ASM monitoring>]
     
516. [-databaseConfigType <SINGLE | RAC | RACONENODE>]
     
517. [-RACOneNodeServiceName <Service name for the service to be created for RAC One Node database. This option is mandatory when the databaseConfigType is RACONENODE>]
     
518. [-emConfiguration <DBEXPRESS | CENTRAL | BOTH | NONE>]
     
519. [-dbsnmpPassword <DBSNMP user password>]
     
520. [-emPassword <EM Admin user password>]
     
521. [-emUser <EM Admin username to add or modify targets>]
     
522. [-emExpressPort <EM database express port number. Generally used during createDatabase>]
     
523. [-omsHost <EM management server host name>]
     
524. [-omsPort <EM management server port number>]
     
525. [-emExpressPortAsGlobalPort <value>]
     
526. 
     
527. $ dbca -help -relocatePDB
     
528. -relocatePDB - Command to Relocate a pluggable database.
     
529. -remotePDBName <Name of the pluggable database to clone/relocate>
     
530. -pdbName <Pluggable database name>
     
531. -dbLinkUsername <Common user of a remote CDB, used by database link to connect to remote CDB.>
     
532. -remoteDBConnString <EZCONNECT string to connect to Source database for example "host:port/servicename">
     
533. -sourceDB <Database unique name for RAC database or SID for Single Instance database>
     
534. [-remoteDBSYSDBAUserName <User name with SYSDBA privileges of remote database>]
     
535. [-dbLinkUserPassword <Common user password of a remote CDB, used by database link to connect to remote CDB.>]
     
536. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
     
537. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
     
538. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
     
539. [-remoteDBSYSDBAUserPassword <Password for remoteDBSYSDBAUserName user of remote database.>]
     
540. [-sysDBAUserName <User name with SYSDBA privileges>]
     
541. [-sysDBAPassword <Password for sysDBAUserName user name>]
     
542. 
     
543. $ dbca -help -unplugDatabase
     
544. -unplugDatabase - Command to Unplug a pluggable database.
     
545. -archiveType <TAR | RMAN | NONE> Optional field during UnplugDatabase.
     
546. [-rmanParallelism <Parallelism value>]
     
547. [-maxBackupSetSizeInMB <Maximum backup set size in MB>]
     
548. [-pdbArchiveFile <Absolute file path and name for PDB Archive file. Optional field during CreatePluggableDatabase/UnplugDatabase>]
     
549. [-pdbBackUpfile <Absolute file path and name for PDB backup file, required when archive type is RMAN (specify comma separated paths if there are multiple backups when creating PDB).>]
     
550. [-pdbMetadataFile <Absolute file path and name for PDB metadata file, required when archive type is RMAN or NONE. Optional field during CreatePluggableDatabase/UnplugDatabase>]
     
551. -sourceDB <Database unique name for RAC database or SID for Single Instance database>
     
552. -pdbName <Pluggable database name>
     
553. [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
     
554. -dbCredentialsWalletLocation <Path of the directory containing the wallet files>
     
555. [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
     
556. [-unregisterWithDirService <true | false>]
     
557. -dirServiceUserName <User name for directory service>
     
558. [-dirServicePassword <Password for directory service>]
     
559. [-walletPassword <Password for database wallet>]

复制代码