I wanted to export 11.2 database schema and import it into a 19c database; creating the database in archive mode to create a backup of all transactions and allow recovery to any point in time.
Since the 19c database did not exist, I needed to create it. I did so by running DBCA in silent mode.
I used the following demo and syntax to create the database:
---------------------------------------- --- DB patch level: ---------------------------------------- [[email protected] ~]$ $ORACLE_HOME/OPatch/opatch lspatches 31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087) 31281355;Database Release Update : 19.8.0.0.200714 (31281355) OPatch succeeded. ---------------------------------------- --- Create database in archivelog mode: ---------------------------------------- [[email protected] ~]$ dbca -silent \ > -createDatabase \ > -responseFile NO_VALUE \ > -templateName General_Purpose.dbc \ > -sid testdb \ > -gdbname TESTDB \ > -characterSet AL32UTF8 \ > -sysPassword Oracle_4U \ > -systemPassword Oracle_4U \ > -createAsContainerDatabase FALSE \ > -databaseType MULTIPURPOSE \ > -automaticMemoryManagement FALSE \ > -totalMemory 2048 \ > -datafileDestination +DATA \ > -recoveryAreaDestination +RECO \ > -redoLogFileSize 50 \ > -emConfiguration NONE \ > -sampleSchema FALSE \ > -enableArchive TRUE \ > -ignorePreReqs Prepare for db operation 10% complete Registering database with Oracle Restart 14% complete Copying database files 43% complete Creating and starting Oracle instance 45% complete 49% complete 53% complete 56% complete 62% complete Completing Database Creation 68% complete 70% complete 71% complete Executing Post Configuration Actions 100% complete Database creation complete. For details check the logfiles at: /u01/app/oracle/cfgtoollogs/dbca/TESTDB. Database Information: Global Database Name:TESTDB System Identifier(SID):testdb Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/TESTDB/TESTDB0.log" for further details. ---------------------------------------- --- Logs for dbca: ---------------------------------------- [[email protected] ~]$ ls -l /u01/app/oracle/cfgtoollogs/dbca/TESTDB/ total 21508 -rw-r-----. 1 oracle oinstall 12131 Nov 20 13:20 cloneDBCreation.log -rw-r-----. 1 oracle oinstall 784 Nov 20 13:07 CloneRmanRestore.log -rw-r-----. 1 oracle oinstall 1820 Nov 20 13:21 lockAccount.log -rw-r-----. 1 oracle oinstall 3578 Nov 20 13:24 postDBCreation.log -rw-r-----. 1 oracle oinstall 1436 Nov 20 13:21 postScripts.log -rw-r-----. 1 oracle oinstall 0 Nov 20 13:06 rmanUtil -rw-r-----. 1 oracle oinstall 18726912 Nov 20 13:07 tempControl.ctl -rw-r-----. 1 oracle oinstall 843 Nov 20 13:24 TESTDB0.log -rw-r-----. 1 oracle oinstall 843 Nov 6 05:14 TESTDB.log -rw-r-----. 1 oracle oinstall 1635418 Nov 6 05:14 trace.log_2020-11-06_04-58-10AM -rw-r-----. 1 oracle oinstall 1619098 Nov 20 13:24 trace.log_2020-11-20_01-05-35PM ---------------------------------------- --- /etc/oratab is automatically updated: ---------------------------------------- [[email protected] ~]$ tail /etc/oratab #Backup file is /u01/app/oracle/product/19.0.0/dbhome_1/srvm/admin/oratab.bak.ol7-19-lax1.oracle line added by Agent +ASM1:/u01/app/19.0.0/grid:N hawk1:/u01/app/oracle/product/19.0.0/dbhome_1:N testdb:/u01/app/oracle/product/19.0.0/dbhome_1:N ---------------------------------------- --- Confirm Archive Mode: ---------------------------------------- [[email protected] ~]$ . oraenv <<< testdb ORACLE_SID = [hawk1] ? The Oracle base remains unchanged with value /u01/app/oracle [[email protected] ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Fri Nov 20 13:25:09 2020 Version 19.8.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.8.0.0.0 OL7-19-LAX1:([email protected]:PRIMARY> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 31 Next log sequence to archive 33 Current log sequence 33 OL7-19-LAX1:([email protected]:PRIMARY> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.8.0.0.0 ---------------------------------------- --- Database automatically registered with cluster : ---------------------------------------- [[email protected] ~]$ srvctl config database -d testdb Database unique name: TESTDB Database name: TESTDB Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1 Oracle user: oracle Spfile: +DATA/TESTDB/PARAMETERFILE/spfile.315.1056983141 Password file: Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: Disk Groups: DATA,RECO Mount point paths: Services: Type: SINGLE OSDBA group: dba OSOPER group: oper Database instance: testdb Configured nodes: ol7-19-lax1 CSS critical: no CPU count: 0 Memory target: 0 Maximum memory: 0 Default network number for database services: Database is administrator managed [[email protected] ~]$ ------------------------------ --- Delete database: ------------------------------ [[email protected] ~]$ dbca -silent -deleteDatabase -sourceDB testdb Enter SYS user password: [WARNING] [DBT-19202] The Database Configuration Assistant will delete the Oracle instances and datafiles for your database. All information in the database will be destroyed. Prepare for db operation 32% complete Connecting to database 35% complete 39% complete 42% complete 45% complete 48% complete 52% complete 65% complete Updating network configuration files 68% complete Deleting instance and datafiles 84% complete 100% complete Database deletion completed. Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/TESTDB/TESTDB1.log" for further details. [[email protected] ~]$
As you can see, using DBCA to create your database is useful and convenient. If you have any questions about how this might apply to your specific situation, please feel free to leave a comment.
No comments