/bin/chmod 600 /dev/raw/raw1
/bin/chmod 600 /dev/raw/raw2
/bin/chmod 600 /dev/raw/raw3
/bin/chmod 600 /dev/raw/raw4
/bin/chmod 600 /dev/raw/raw5
/bin/chmod 600 /dev/raw/raw6
/bin/chmod 600 /dev/raw/raw7
/bin/chmod 600 /dev/raw/raw8
/bin/chmod 600 /dev/raw/raw9
/bin/chmod 600 /dev/raw/raw10
/bin/chmod 600 /dev/raw/raw11
/bin/chmod 600 /dev/raw/raw12
/bin/chmod 600 /dev/raw/raw13
/bin/chmod 600 /dev/raw/raw14
/bin/chmod 600 /dev/raw/raw15
/bin/chmod 600 /dev/raw/raw16
/bin/chmod 600 /dev/raw/raw17
/bin/chmod 600 /dev/raw/raw18
/bin/chmod 600 /dev/raw/raw19
/bin/chmod 600 /dev/raw/raw20
/bin/chmod 600 /dev/raw/raw21
/bin/chmod 600 /dev/raw/raw22
/bin/chmod 600 /dev/raw/raw23
/bin/chmod 600 /dev/raw/raw24
/bin/chmod 600 /dev/raw/raw25
/bin/chmod 600 /dev/raw/raw26
/bin/chmod 600 /dev/raw/raw27
/bin/chmod 600 /dev/raw/raw28
/bin/chmod 600 /dev/raw/raw29
/bin/chmod 600 /dev/raw/raw30
/bin/chmod 600 /dev/raw/raw31
/bin/chmod 600 /dev/raw/raw32
/bin/chmod 600 /dev/raw/raw33
/bin/chmod 600 /dev/raw/raw34
/bin/chmod 600 /dev/raw/raw35
/bin/chmod 600 /dev/raw/raw36
/bin/chmod 600 /dev/raw/raw37
/bin/chmod 600 /dev/raw/raw38
/bin/chmod 600 /dev/raw/raw39
/bin/chmod 600 /dev/raw/raw40
/bin/chmod 600 /dev/raw/raw41
/bin/chmod 600 /dev/raw/raw42
/bin/chmod 600 /dev/raw/raw43
/bin/chmod 600 /dev/raw/raw44
/bin/chmod 600 /dev/raw/raw45
/bin/chmod 600 /dev/raw/raw46
/bin/chmod 600 /dev/raw/raw47
/bin/chmod 600 /dev/raw/raw48
/bin/chmod 600 /dev/raw/raw49
/bin/chmod 600 /dev/raw/raw50
/bin/chmod 600 /dev/raw/raw51
/bin/chmod 600 /dev/raw/raw52
/bin/chmod 600 /dev/raw/raw53
/bin/chmod 600 /dev/raw/raw54
/bin/chmod 600 /dev/raw/raw55
/bin/chmod 600 /dev/raw/raw56
/bin/chmod 600 /dev/raw/raw57
/bin/chmod 600 /dev/raw/raw58
/bin/chmod 600 /dev/raw/raw59
/bin/chmod 600 /dev/raw/raw60
/bin/chmod 600 /dev/raw/raw61
/bin/chmod 600 /dev/raw/raw62
/bin/chmod 600 /dev/raw/raw63
/bin/chmod 600 /dev/raw/raw64
/bin/chmod 600 /dev/raw/raw65
/bin/chmod 600 /dev/raw/raw66
/bin/chmod 600 /dev/raw/raw67
/bin/chmod 600 /dev/raw/raw68
/bin/chmod 600 /dev/raw/raw69
/bin/chown oracle.dba /dev/raw/raw1
/bin/chown oracle.dba /dev/raw/raw2
/bin/chown oracle.dba /dev/raw/raw3
/bin/chown oracle.dba /dev/raw/raw4
/bin/chown oracle.dba /dev/raw/raw5
/bin/chown oracle.dba /dev/raw/raw6
/bin/chown oracle.dba /dev/raw/raw7
/bin/chown oracle.dba /dev/raw/raw8
/bin/chown oracle.dba /dev/raw/raw9
/bin/chown oracle.dba /dev/raw/raw10
/bin/chown oracle.dba /dev/raw/raw11
/bin/chown oracle.dba /dev/raw/raw12
/bin/chown oracle.dba /dev/raw/raw13
/bin/chown oracle.dba /dev/raw/raw14
/bin/chown oracle.dba /dev/raw/raw15
/bin/chown oracle.dba /dev/raw/raw16
/bin/chown oracle.dba /dev/raw/raw17
/bin/chown oracle.dba /dev/raw/raw18
/bin/chown oracle.dba /dev/raw/raw19
/bin/chown oracle.dba /dev/raw/raw20
/bin/chown oracle.dba /dev/raw/raw21
/bin/chown oracle.dba /dev/raw/raw22
/bin/chown oracle.dba /dev/raw/raw23
/bin/chown oracle.dba /dev/raw/raw24
/bin/chown oracle.dba /dev/raw/raw25
/bin/chown oracle.dba /dev/raw/raw26
/bin/chown oracle.dba /dev/raw/raw27
/bin/chown oracle.dba /dev/raw/raw28
/bin/chown oracle.dba /dev/raw/raw29
/bin/chown oracle.dba /dev/raw/raw30
/bin/chown oracle.dba /dev/raw/raw31
/bin/chown oracle.dba /dev/raw/raw32
/bin/chown oracle.dba /dev/raw/raw33
/bin/chown oracle.dba /dev/raw/raw34
/bin/chown oracle.dba /dev/raw/raw35
/bin/chown oracle.dba /dev/raw/raw36
/bin/chown oracle.dba /dev/raw/raw37
/bin/chown oracle.dba /dev/raw/raw38
/bin/chown oracle.dba /dev/raw/raw39
/bin/chown oracle.dba /dev/raw/raw40
/bin/chown oracle.dba /dev/raw/raw41
/bin/chown oracle.dba /dev/raw/raw42
/bin/chown oracle.dba /dev/raw/raw43
/bin/chown oracle.dba /dev/raw/raw44
/bin/chown oracle.dba /dev/raw/raw45
/bin/chown oracle.dba /dev/raw/raw46
/bin/chown oracle.dba /dev/raw/raw47
/bin/chown oracle.dba /dev/raw/raw48
/bin/chown oracle.dba /dev/raw/raw49
/bin/chown oracle.dba /dev/raw/raw50
/bin/chown oracle.dba /dev/raw/raw51
/bin/chown oracle.dba /dev/raw/raw52
/bin/chown oracle.dba /dev/raw/raw53
/bin/chown oracle.dba /dev/raw/raw54
/bin/chown oracle.dba /dev/raw/raw55
/bin/chown oracle.dba /dev/raw/raw56
/bin/chown oracle.dba /dev/raw/raw57
/bin/chown oracle.dba /dev/raw/raw58
/bin/chown oracle.dba /dev/raw/raw59
/bin/chown oracle.dba /dev/raw/raw60
/bin/chown oracle.dba /dev/raw/raw61
/bin/chown oracle.dba /dev/raw/raw62
/bin/chown oracle.dba /dev/raw/raw63
/bin/chown oracle.dba /dev/raw/raw64
/bin/chown oracle.dba /dev/raw/raw65
/bin/chown oracle.dba /dev/raw/raw66
/bin/chown oracle.dba /dev/raw/raw67
/bin/chown oracle.dba /dev/raw/raw68
/bin/chown oracle.dba /dev/raw/raw69
ln -s /dev/raw/raw1 /opt/oracle/oradata/smt/CMQuorumFile
ln -s /dev/raw/raw2 /opt/oracle/oradata/smt/SharedSrvctlConfigFile
ln -s /dev/raw/raw3 /opt/oracle/oradata/smt/spfilesmt.ora
ln -s /dev/raw/raw4 /opt/oracle/oradata/smt/control01.ctl
ln -s /dev/raw/raw5 /opt/oracle/oradata/smt/control02.ctl
ln -s /dev/raw/raw6 /opt/oracle/oradata/smt/control03.ctl
ln -s /dev/raw/raw7 /opt/oracle/oradata/smt/indx01.dbf
ln -s /dev/raw/raw8 /opt/oracle/oradata/smt/system01.dbf
ln -s /dev/raw/raw9 /opt/oracle/oradata/smt/temp01.dbf
ln -s /dev/raw/raw10 /opt/oracle/oradata/smt/tools01.dbf
ln -s /dev/raw/raw11 /opt/oracle/oradata/smt/undotbs01.dbf
ln -s /dev/raw/raw12 /opt/oracle/oradata/smt/undotbs02.dbf
ln -s /dev/raw/raw13 /opt/oracle/oradata/smt/undotbs03.dbf
ln -s /dev/raw/raw14 /opt/oracle/oradata/smt/users01.dbf
ln -s /dev/raw/raw15 /opt/oracle/oradata/smt/xdb01.dbf
ln -s /dev/raw/raw16 /opt/oracle/oradata/smt/perfstat01.dbf
ln -s /dev/raw/raw17 /opt/oracle/oradata/smt/cwmlite01.dbf
ln -s /dev/raw/raw18 /opt/oracle/oradata/smt/example01.dbf
ln -s /dev/raw/raw19 /opt/oracle/oradata/smt/drsys01.dbf
ln -s /dev/raw/raw20 /opt/oracle/oradata/smt/odm01.dbf
ln -s /dev/raw/raw21 /opt/oracle/oradata/smt/redo01.log
ln -s /dev/raw/raw22 /opt/oracle/oradata/smt/redo02.log
ln -s /dev/raw/raw23 /opt/oracle/oradata/smt/redo03.log
ln -s /dev/raw/raw24 /opt/oracle/oradata/smt/smt_redo2_2.log
ln -s /dev/raw/raw25 /opt/oracle/oradata/smt/I_SWDL_DATA_01.dbf
ln -s /dev/raw/raw27 /opt/oracle/oradata/smt/D_SWDL_DATA_01.dbf
ln -s /dev/raw/raw28 /opt/oracle/oradata/smt/D_SFIS1_DATA_01a.dbf
ln -s /dev/raw/raw29 /opt/oracle/oradata/smt/D_SFISM4_DATA_01a.dbf
ln -s /dev/raw/raw30 /opt/oracle/oradata/smt/D_SFISM4_DATA_02a.dbf
ln -s /dev/raw/raw31 /opt/oracle/oradata/smt/D_SFISM4_DATA_01b.dbf
ln -s /dev/raw/raw32 /opt/oracle/oradata/smt/D_SMT_SCANDATA_DATA.dbf
ln -s /dev/raw/raw33 /opt/oracle/oradata/smt/D_SNDETAIL_DATA_01a.dbf
ln -s /dev/raw/raw34 /opt/oracle/oradata/smt/D_SNDETAIL_DATA_02a.dbf
ln -s /dev/raw/raw35 /opt/oracle/oradata/smt/D_SNDETAIL_DATA_02b.dbf
ln -s /dev/raw/raw36 /opt/oracle/oradata/smt/D_SNDETAIL_DATA_03a.dbf
ln -s /dev/raw/raw37 /opt/oracle/oradata/smt/D_SNDETAIL_DATA_04a.dbf
ln -s /dev/raw/raw38 /opt/oracle/oradata/smt/D_SNDETAIL_DATA_05a.dbf
ln -s /dev/raw/raw39 /opt/oracle/oradata/smt/D_SNDETAIL_DATA_06a.dbf
ln -s /dev/raw/raw40 /opt/oracle/oradata/smt/D_SNDETAIL_DATA_07a.dbf
ln -s /dev/raw/raw41 /opt/oracle/oradata/smt/D_TEST_DATA_01a.dbf
ln -s /dev/raw/raw42 /opt/oracle/oradata/smt/D_WIPTRACKING_DATA_01a.dbf
ln -s /dev/raw/raw43 /opt/oracle/oradata/smt/I_SFIS1_DATA_01a.dbf
ln -s /dev/raw/raw44 /opt/oracle/oradata/smt/I_SFISM4_DATA_01a.dbf
ln -s /dev/raw/raw45 /opt/oracle/oradata/smt/I_SMT_SCANDATA.dbf
ln -s /dev/raw/raw46 /opt/oracle/oradata/smt/I_SNDETAIL_DATA_01a.dbf
ln -s /dev/raw/raw47 /opt/oracle/oradata/smt/I_SNDETAIL_DATA_01b.dbf
ln -s /dev/raw/raw49 /opt/oracle/oradata/smt/I_WIPTRACKING_DATA_01a.dbf
ln -s /dev/raw/raw56 /opt/oracle/oradata/smt/AGAENT_DATA.dbf
ln -s /dev/raw/raw57 /opt/oracle/oradata/smt/AGAENT_INDEX.dbf
ln -s /dev/raw/raw58 /opt/oracle/oradata/smt/smt_redo1_3.log
ln -s /dev/raw/raw59 /opt/oracle/oradata/smt/smt_redo2_3.log
chown -R oracle.dba /opt/oracle/oradata
. ~oracle/.bash_profile
rm -rf $ORACLE_HOME/oracm/log/*.ts
$ORACLE_HOME/oracm/bin/ocmstart.sh
su - oracle -c "gsdctl start"
#set oracle environment
ORACLE_HOME=/opt/oracle/product/9.2.0;export ORACLE_HOME
ORACLE_SID=smt2;export ORACLE_SID
su oracle -c "/opt/oracle/product/9.2.0/bin/sqlplus /nolog <
startup;
exit
EOF"
su oracle -c "/opt/oracle/product/9.2.0/bin/lsnrctl <
exit
EOF"
imbsmt1<*smt1*/opt/oracle/product/9.2.0/dbs>$cat initsmt1.ora
*.archive_lag_target=1800
*.background_dump_dest='/opt/oracle/admin/smt/bdump'
*.cluster_database_instances=2
*.cluster_database=TRUE
*.compatible='9.2.0.0.0'
*.control_files='/opt/oracle/oradata/smt/control01.ctl','/opt/oracle/oradata/smt/control02.ctl','/opt/oracle/oradata/smt/control03.ctl'
*.core_dump_dest='/opt/oracle/admin/smt/cdump'
*.db_block_size=8192
*.db_cache_size=2147483648
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='smt'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=smtXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
smt2.instance_name='smt2'
smt1.instance_name='smt1'
smt2.instance_number=2
smt1.instance_number=1
*.java_pool_size=115343360
*.job_queue_processes=10
*.large_pool_size=33554432
smt2.local_listener='LISTENER_SMT2'
smt1.local_listener='LISTENER_SMT1'
*.log_archive_dest='/opt/oracle/arch1'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=TRUE
*.open_cursors=15000
*.pga_aggregate_target=178257920
*.processes=800
*.query_rewrite_enabled='FALSE'
*.remote_listener='LISTENERS_SMT'
*.remote_login_passwordfile='exclusive'
*.sga_max_size=3221225472
*.shared_pool_size=314572800
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
smt1.thread=1
smt2.thread=2
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
smt2.undo_tablespace='UNDOTBS2'
smt1.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle/admin/smt/udump'
*.audit_sys_operations=TRUE
imbsmt2<*smt2*/opt/oracle/product/9.2.0/dbs>$cat initsmt2.ora
*.archive_lag_target=1800
*.background_dump_dest='/opt/oracle/admin/smt/bdump'
*.cluster_database_instances=2
*.cluster_database=TRUE
*.compatible='9.2.0.0.0'
*.control_files='/opt/oracle/oradata/smt/control01.ctl','/opt/oracle/oradata/smt/control02.ctl','/opt/oracle/oradata/smt/control03.ctl'
*.core_dump_dest='/opt/oracle/admin/smt/cdump'
*.db_block_size=8192
*.db_cache_size=2147483648
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='smt'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=smtXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
smt2.instance_name='smt2'
smt1.instance_name='smt1'
smt2.instance_number=2
smt1.instance_number=1
*.java_pool_size=115343360
*.job_queue_processes=10
*.large_pool_size=33554432
smt2.local_listener='LISTENER_SMT2'
smt1.local_listener='LISTENER_SMT1'
*.log_archive_dest='/opt/oracle/arch1'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=TRUE
*.open_cursors=15000
*.pga_aggregate_target=178257920
*.processes=800
*.query_rewrite_enabled='FALSE'
*.remote_listener='LISTENERS_SMT'
*.remote_login_passwordfile='exclusive'
*.sga_max_size=3221225472
*.shared_pool_size=314572800
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
smt1.thread=1
smt2.thread=2
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
smt2.undo_tablespace='UNDOTBS2'
smt1.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle/admin/smt/udump'
*.audit_sys_operations=TRUE
imbsmtsty<*smt1*/home/oracle>$cat pfile.ora
*.aq_tm_processes=1
*.archive_lag_target=0
*.audit_sys_operations=FALSE
*.background_dump_dest='/u01/product/admin/smt/bdump'
*.cluster_database_instances=2
*.cluster_database=FALSE
*.compatible='9.2.0.0.0'
*.control_files='/u01/product/oradata/smt/control01.ctl','/u01/product/oradata/smt/control02.ctl','/data/smt/control03.ctl'
*.core_dump_dest='/u01/product/admin/smt/cdump'
*.db_block_size=8192
*.db_cache_size=6442450944
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='/opt/oracle/oradata/smt/','/data/smt/'
*.db_name='smt'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=smt1XDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='smt1'
smt1.instance_name='smt1'
smt1.instance_number=1
*.java_pool_size=469762048
*.job_queue_processes=10
*.large_pool_size=67108864
*.log_archive_dest='/data/smt/arch'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=TRUE
*.log_file_name_convert='/opt/oracle/oradata/smt/','/data/smt/'
*.open_cursors=15000
*.pga_aggregate_target=713031680
*.processes=800
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=469762048
*.sort_area_size=2097152
*.standby_archive_dest='/data/smt/arch/'
*.standby_file_management='AUTO'
*.star_transformation_enabled='FALSE'
smt1.thread=1
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
smt1.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/product/admin/smt/udump'
imbsmtsty<*smt1*/home/oracle>$cat /data/run/autorsync
#!/bin/bash
pid=`/sbin/pidof rsync |wc | awk '{print $1}' `
#echo $pid
if [ "$pid" -gt "1" ]
then
echo "Rsync is already running...."
else
echo "Starting rsync `date`"
rsync -e ssh -av oracle@10.160.16.83:/opt/oracle/arch1/ /data/smt/arch/
rsync -e ssh -av oracle@10.160.16.84:/opt/oracle/arch1/ /data/smt/arch/
echo "Completed rsync `date`"
fi
exit 0
imbsmtsty<*smt1*/home/oracle>$cat /data/run/autoreco
#!/bin/sh
ORACLE_HOME=/u01/product/oracle;export ORACLE_HOME
ORACLE_SID=smt1;export ORACLE_SID
/u01/product/oracle/bin/sqlplus /nolog <
set autorecovery on;
recover standby database;
exit;
EOF
imbsmtsty<*smt1*/home/oracle>$cat /data/run/autodel
#!/bin/bash
find /u01/product/admin/smt/bdump/*.trc -mmin +1440 -exec rm -f {} \;
find /u01/product/admin/smt/udump/*.trc -mmin +1440 -exec rm -f {} \;
find /data/smt/arch/*.dbf -mmin +10080 -exec rm -f {} \;
imbsmtsty<*smt1*/home/oracle>$crontab -l
*/10 * * * * sh /data/run/autorsync 1>>/data/run/log/autorsync.log 2>>/data/run/log/autorsync.bad
*/25 * * * * sh /data/run/autoreco 1>>/data/run/log/autoreco.log 2>>/data/run/log/autoreco.bad
10 0 * * * sh /data/run/autodel 1>>/data/run/log/autodel.log 2>>/data/run/log/autodel.bad
imbsmt2<*smt2*/opt/oracle/arch1>$crontab -l
15 0 * * * sh /data/run/autodel 1>>/data/run/log/autodel.log 2>>/data/run/log/autodel.bad
20 0 * * * sh /data/run/autoexp 1>/data/run/log/autoexp.log 2>/data/run/log/autoexp.bad
30 0 * * 6 sh /data/run/rmanfull.sh 1>/data/run/log/rmanfull.log 2>/data/run/log/rmanfull.bad
30 7 * * 6 sh /data/run/autostats 1>/data/run/log/autostats.log 2>/data/run/log/autostats.bad
imbsmt2<*smt2*/opt/oracle/arch1>$cat /data/run/rmanfull.sh
#!/bin/sh
ORACLE_HOME=/opt/oracle/product/9.2.0;export ORACLE_HOME
ORACLE_SID=smt2;export ORACLE_SID
rm -f /data/rmandata/*
echo 'Recovery Manager Start at '`date`'.' >/data/run/log/rman.log
$ORACLE_HOME/bin/rman target / @'/data/run/rmanfull.sql' log /data/run/log/rman.log
echo 'Recovery Manager End at '`date`'.' >>/data/run/log/rman.log
imbsmt2<*smt2*/opt/oracle/arch1>$cat /data/run/rmanfull.sql
run{
allocate channel dev1 type disk;
allocate channel dev2 type disk;
allocate channel dev3 type disk;
allocate channel dev4 type disk;
backup full tag 'dbfull'
format '/data/rmandata/full_%d_%T_%U' database;
sql 'alter system archive log current';
release channel dev1;
release channel dev2;
release channel dev3;
release channel dev4;
allocate channel dev1 type disk;
backup
format '/data/rmandata/ctl_%d_%T_%U' current controlfile;
release channel dev1;
}
imbsmt2<*smt2*/opt/oracle/arch1>$cat /data/run/autostats
#!/bin/sh
source /home/oracle/.bash_profile
echo 'start datetime --> ' `date`
################################################
sqlplus -S '/as sysdba' <
dbms_stats.gather_schema_stats(ownname=> 'EB_WEB' , estimate_percent=> 15 , cascade=> TRUE );
dbms_stats.gather_schema_stats(ownname=> 'SFIS1' , estimate_percent=> 15 , cascade=> TRUE );
dbms_stats.gather_schema_stats(ownname=> 'SFISM4' , estimate_percent=> 15 , cascade=> TRUE );
end;
/
exit
EOFarch1
#################################################
echo 'finish datetime --> ' `date`
imbsmt2<*smt2*/opt/oracle/arch1>$cat /data/run/autoexp
#!/bin/sh
find /data/expdata/imbsmt* -mmin -1440 -exec rm -f {} \;
ORACLE_HOME=/opt/oracle/product/9.2.0;export ORACLE_HOME
ORACLE_SID=smt2;export ORACLE_SID
localdate=`date +%Y%m%d%H`
echo '----------> begin exp at ' ` date ` '<--------------'
$ORACLE_HOME/bin/exp 'system/"imbl6"' file=/data/expdata/imbsmt_$localdate.dmp log=/data/expdata/imbsmt_$localdate.log full=y rows=y buffer=204800 statistics=none
echo '----------> end exp at ' ` date ` '<--------------'
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/25198367/viewspace-706400/ ,如需转载,请注明出处,否则将追究法律责任。