primary db:
autocheck.bat
set ORACLE_SID=dt2esd
sqlplus "sys/'sys' as sysdba" @d:\auto\tbs.sql
exit
tbs.sql
set linesize 131
col object format a40
col type format a10
col tsname format a10
select a.owner||'.'||a.segment_name object,
a.segment_type type ,
a.bytes/1024/1024 NG ,
a.next_extent/1024/1024 Next ,
a.tablespace_name ts_name
from sys.dba_segments a
where a. next_extent * &num > (
select max(b.bytes)
from dba_free_space b
where a.tablespace_name = b.tablespace_name)
order by 3 desc
/
autoshutdown.bak
conn / as sysdba
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
shutdown immediate;
exit;
autoshutdown.bat
set ORACLE_SID=dt2esd
lsnrctl stop
sqlplus /nolog @d:\auto\autoshutdown.bak
exit
exit
autostartup.bak
conn / as sysdba
startup;
exit;
autostartup.bat
set ORACLE_SID=dt2esd
lsnrctl start
sqlplus /nolog @d:\auto\autostartup.bak
exit
exit
standby db:
autoftpdt2esd.bat
if exist z: then net use U: /delete /y
net use U: \\110.153.32.95\e$ "Sys!B5dt2zjdb" /user:administrator
U:
cd dt2esd
cd arch
move *.arc e:\dt2esd\arch >>d:\auto\autocopy_dt2esd.log
e:
net use U: /delete /y
set ORACLE_SID=dt2esd
sqlplus /nolog @d:\auto\autoreco.bak >>d:\auto\autoreco_dt2esd.log
exit
exit
exit
autoreco.bak
connect / as sysdba
set autorecovery on
recover standby database;
exit;
autorun.bat
set ORACLE_SID=dt2esd
sqlplus /nolog @d:\auto\autostart_sty.bak
exit
exit
autoshutdown.bak
conn / as sysdba
shutdown immediate;
exit;
autoshutdown.bat
set ORACLE_SID=dt2esd
sqlplus /nolog @d:\auto\autoshutdown.bak
exit
exit
autostart_sty.bak
conn / as sysdba
shutdown immediate;
startup nomount;
alter database mount standby database;
set autorecovery on
recover standby database;
exit;
autostartup.bak
conn / as sysdba
startup nomount;
alter database mount standby database;
exit;
autostartup.bat
set ORACLE_SID=dt2esd
sqlplus /nolog @d:\auto\autostartup.bak
exit
exit
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25198367/viewspace-688939/,如需转载,请注明出处,否则将追究法律责任。