Oracle：10g（10.2.0.5）：纯控制台console版本的dbca：不要java！

不解释！

一切都在批处理代码中！ 关键，挺简单的。

 

 

@echo off

%~d0
cd "%~dp0"
title "%~n0"

set ORACLE_HOME=%cd%
set PATH=.;%ORACLE_HOME%\bin;%PATH%

title ORACLE_HOME=%ORACLE_HOME%

rem ---------------------------------------------------

set cn=7
set sid= 16 set ORACLE_SID= 17 set chrset= 18 set tt=c:\ade\aime_t7\oracle\oradata\seeddata

goto next1
rem ---------------------------------------------------


:next1
cls
set msg="设置 sid :"
title 1 of %cn% : %msg%
set /p sid=%msg% 
echo %sid%
set ORACLE_SID=%sid%
echo "确认请按 Y, 否请按 N"
choice  /C YN
set ch=%ERRORLEVEL%
if %ch%==0 exit
if %ch%==1 goto next2
if %ch%==2 goto next1

:next2
cls
set msg="设置数据库字符集 characterset :"
title 2 of %cn% : %msg%
echo "中文ZHS16GBK 请按Z, Unicode字符AL32UTF8 请按U"
choice  /C ZU
set ch=%ERRORLEVEL%
rem if %ch%==1 set chrset=US7ASCII
if %ch%==1 set chrset=ZHS16GBK
if %ch%==2 set chrset=AL32UTF8
echo %chrset%
echo "确认请按 Y, 否请按 N"
choice  /C YN
set ch=%ERRORLEVEL%
if %ch%==0 exit
if %ch%==1 goto next22
if %ch%==2 goto next2

:next22
cls
rem ---------------------------------------




:next3
set pfile=database\init%sid%.ora
set msg="创建初始化参数文件 %pfile% ..."
title 3 of %cn% : %msg%

rem *******************************
echo shutdown abort; | sqlplus "/ as sysdba" >nul
ping -n 3 127.0.0.1>nul

rem *******************************
mkdir c:\oradata
set dd=c:\oradata\%sid%
rmdir /s /q %dd%
mkdir %dd%

set pfile=database\init%sid%.ora
rem ****************** pfile *************
echo db_name='%sid%'>%pfile%
echo db_name='SEEDDATA'>>%pfile%
echo compatible='10.2.0.2'>>%pfile%
echo control_files='%dd%\control_%sid%.ctl'>>%pfile%
echo sga_target=333M>>%pfile%
echo pga_aggregate_target=200M>>%pfile%
echo undo_tablespace='UNDOTBS1'>>%pfile%

echo db_create_file_dest='%dd%'>>%pfile%
rem echo diagnostic_dest='/tmp11'
rem echo audit_file_dest='/tmp11'
rem echo audit_trail='NONE'

echo --------initialize parameters-----------
type %pfile%
echo ----------------------------------------
ping -n 2 127.0.0.1 >nul

:next4
set msg="准备环境，并启动实例 %sid% ..."
title 4 of %cn% : %msg%


rem *******************************
start "oracle instance : %sid%" /min oracle.exe %sid%
ping -n 3 127.0.0.1>nul

rem *******************************
start "rman for %sid%" /min  rman target=/
ping -n 1 127.0.0.1>nul

start "sqlplus for %sid%"  /min sqlplus "/ as sysdba"
ping -n 1 127.0.0.1>nul


:next5
set msg="恢复模板数据库SEEDDATA ..."
title 5 of %cn% : %msg%

set tt=c:\ade\aime_t7\oracle\oradata\seeddata
set rman=rman.rman
rem *****************************************
echo startup nomount;>%rman%
echo restore controlfile from '?\assistants\dbca\templates\Seed_Database.ctl';>>%rman%

echo startup mount;>>%rman%
echo catalog start with '?\assistants\dbca\templates\Seed';>>%rman%

echo run {>>%rman%
echo set newname for datafile 1 to '%dd%\system01.dbf';>>%rman%
echo set newname for datafile 2 to '%dd%\undotbs01.dbf';>>%rman%
echo set newname for datafile 3 to '%dd%\sysaux01.dbf';>>%rman%
echo set newname for datafile 4 to '%dd%\users01.dbf';>>%rman%
echo set newname for tempfile 1 to '%dd%\temp01.dbf';>>%rman%
echo restore database;>>%rman%
echo switch datafile all;>>%rman%
echo switch tempfile all;>>%rman%
echo }>>%rman%
echo;>>%rman%

rman target=/ @%rman%


set sql=sql.sql
rem *****************************************
echo;>%sql%
echo set echo on>>%sql%
echo set sqlbl on>>%sql%
echo set pagesize 2000>>%sql%
echo set linesize 120>>%sql%
echo col now  format A23>>%sql%
echo col name format A50>>%sql%
echo col type format A10>>%sql%
echo col file# format 999>>%sql%

echo -- startup nomount;>>%sql%
echo alter database rename file '%tt%\redo01.log' to '%dd%\redo01.log';>>%sql%
echo alter database rename file '%tt%\redo02.log' to '%dd%\redo02.log';>>%sql%
echo alter database rename file '%tt%\redo03.log' to '%dd%\redo03.log';>>%sql%
echo alter database open resetlogs;>>%sql%
echo select to_char(sysdate,'yyyy-mm-dd_hh24:mi:ss') as now, open_mode from v$database;>>%sql%

echo select 'datafile' as type,file#,name from v$datafile>>%sql%
echo union all>>%sql%
echo select 'tempfile',file#,name from v$tempfile>>%sql%
echo union all>>%sql%
echo select 'redolog',group#,member from v$logfile;>>%sql%

echo shutdown immediate;>>%sql%
echo startup mount;>>%sql%
echo exit;>>%sql%

sqlplus "/ as sysdba" @%sql%


:next6
set msg="重命名模板数据库SEEDDATA 为 %sid% ..."
title 6 of %cn% : %msg%

echo y | nid target=/ dbname=%sid%
rem 注意：执行完nid后，oracle实例十关闭的

set pfile=database\init%sid%.ora
rem ****************** pfile *************
echo;>>%pfile%
echo db_name='%sid%'>>%pfile%
start "pfile for %sid%" /min type %pfile%

set sql=sql.sql
rem *****************************************
echo;>%sql%
echo set echo on>>%sql%
echo set sqlbl on>>%sql%
echo startup mount;>>%sql%
echo alter database open resetlogs;>>%sql%
echo select open_mode from v$database;>>%sql%
echo exit;>>%sql%

sqlplus "/ as sysdba" @%sql%



:next7
set msg="修改数据库字符集为 %chrset% ..."
title 7 of %cn% : %msg%

set sql=sql.sql
rem *****************************************
echo;>%sql%
echo set echo on>>%sql%
echo set sqlbl on>>%sql%
echo set pagesize 999>>%sql%
echo set linesize 120>>%sql%
echo col parameter format A26>>%sql%
echo col value format A35>>%sql%
echo startup restrict force;>>%sql%
echo alter database character set internal_convert %chrset%;>>%sql%
echo shutdown immediate;>>%sql%
echo startup;>>%sql%
echo select * from nls_database_parameters;>>%sql%
echo exit;>>%sql%

sqlplus "/ as sysdba" @%sql%


:pau
pause
goto pau