$ vi bk_db_arch.sh
oracle_base=/u01/app/oracle
oracle_home=$oracle_base/product/11.2.0/db_1
oracle_sid=orcl
nls_lang=american_america.zhs16gbk
path=$path:/oracle_home/bin
ora_nls33=$oracle_home/ocommon/nls/admin/data
path=$path:$oracle_home/bin:$oracle_home/apache/apache/bin:$oracle_home/opatch
classpath=$oracle_home/jre:$oracle_home/jlib:$oracle_home/rdbms/jlib
classpath=$classpath:$oracle_home/network/jlib
export ora_nls33
export oracle_base oracle_home oracle_sid
export db_name nls_lang path ld_library_path classpath db_name
rman target=/ cmdfile=/u03/rman/rman_script/bk_db_arch.rman log=/u03/rman/rman_log/bk_db_arch_`date +%y%m%d%h%m%s`.log
$vi bk_db_arch.rman
run
{
allocate channel ch1 device type disk maxpiecesize=8000m ;
sql 'alter system checkpoint';
sql 'alter system archive log current';
sql 'alter system archive log current';
backup as compressed backupset archivelog all delete input
format '/mnt/backup/arch_%d_%u_%t.bkp';
release channel ch1;
}
run
{
allocate channel ch1 device type disk maxpiecesize=8000m;
backup current controlfile format '/mnt/backup/ctl_%d_%u_%t.bkp';
release channel ch1;
}
crosscheck backup;
crosscheck archivelog all;
list backup;
exit;
如对本文有疑问, 点击进行留言回复!!
Oracle 基本概念 Dadabase,schema,user,table...
dbeaver连接Oracle中文乱码的解决方案--druid
Oracle常用语句(时间格式、去重、去特殊符号、查询表空间等)
Navicate 如何导出数据库中的存储过程、事件、视图等?
网友评论