-
编辑 删除
rman基本命令
RMAN1. cataloggrant recover_catalog_owner to rman;rman catalog rman/rmanRMAN>create catalog tablespace ora_bak;$rman target / catalog rman/rman@rmanbakRMAN>register datab...
-
编辑 删除
自动删除archielog的脚本
删除archivelog的脚本和cron设置g2cs6010:10g:dmbecif > pwd/paic/bank/becif/data/otbecif/.cronjobg2cs6010:10g:dmbecif > lsalog_clean.sh crontab_becifg2cs6010:10g:dmbecif > cat alog_clean.sh ...
-
编辑 删除
查看日志sequence，追log
select max(sequence#)+1,min(sequence#)-1,thread# from v$log_history where first_time <to_date('2012-09-27 23:50','yyyy-mm-dd hh24:mi') &nb...
-
编辑 删除
restore.ksh
恢复步骤：0，在sit环境修改原库的db_name为dm环境db_name,数据文件路径。 把备份文件放到'/stg/oracle/ot11g/ot11g/yhw 1, 启到nomount状态，恢复控制文件： catalog start with '/stg/orac...
-
编辑 删除
full_backup_dmbfxms.ksh
#!/bin/ksh#full_backup_dmbfxms.kshexport log_file=/paic/bank/tmpsun/rman1/backup/DM8/dmbfxms/full_backup_${ORACLE_SID}_`date '+%Y%m%d_%H%M%S'`.logrman target / << EOF > ${log_file} 2>&1sql 'alter syst...
