SET VERIFY OFFconnect "SYS"/"&&sysPassword" as SYSDBAset echo onspool /u01/app/oracle/admin/qpdb/scripts/postDBCreation.log append@/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/catbundleapply.sql;select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual;execute utl_recomp.recomp_serial();select 'utl_recomp_end: ' || to_char(sysdate, 'HH:MI:SS') from dual;execute dbms_swrf_internal.cleanup_database(cleanup_local => FALSE);commit;shutdown immediate;connect "SYS"/"&&sysPassword" as SYSDBAstartup mount pfile="/u01/app/oracle/admin/qpdb/scripts/init.ora";alter database archivelog;alter database open;select group# from v$log where group# =5;select group# from v$log where group# =6;ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 5 SIZE 51200K, GROUP 6 SIZE 51200K;ALTER DATABASE ENABLE PUBLIC THREAD 3;select group# from v$log where group# =3;select group# from v$log where group# =4;ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 3 SIZE 51200K, GROUP 4 SIZE 51200K;ALTER DATABASE ENABLE PUBLIC THREAD 2;host echo cluster_database=true >>/u01/app/oracle/admin/qpdb/scripts/init.ora;host echo remote_listener=qpdb-cluster-scan:1521>>/u01/app/oracle/admin/qpdb/scripts/init.ora;connect "SYS"/"&&sysPassword" as SYSDBAset echo oncreate spfile='+DATA/qpdb/spfileqpdb.ora' FROM pfile='/u01/app/oracle/admin/qpdb/scripts/init.ora';shutdown immediate;host /u01/app/oracle/product/11.2.0/db_1/bin/srvctl enable database -d qpdb;host /u01/app/oracle/product/11.2.0/db_1/bin/srvctl start database -d qpdb;connect "SYS"/"&&sysPassword" as SYSDBAspool off
转载于:https://www.cnblogs.com/iyoume2008/p/9809597.html
相关资源：JAVA上百实例源码以及开源项目