回复 3# 静以致远 connect target ora_bak/ora_bak_0808;
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS="BLKSIZE=1048576";
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS="BLKSIZE=1048576";
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE' PARMS="BLKSIZE=104...
显示全部回复 3# 静以致远 connect target ora_bak/ora_bak_0808;
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS="BLKSIZE=1048576";
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS="BLKSIZE=1048576";
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE' PARMS="BLKSIZE=1048576";
ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE' PARMS="BLKSIZE=1048576";
send 'NSR_ENV=(NSR_SERVER=xxxx,NSR_CLIENT=xxx,NSR_DATA_VOLUME_POOL=xxx,NSR_NO_MULTIPLEX=TRUE,NSR_MMDB_RETRY_TIME=10)';
BACKUP
incremental level 0
FILESPERSET 1
DATABASE;
sql 'alter system archive log current';
backup spfile;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS="BLKSIZE=1048576";
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS="BLKSIZE=1048576";
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE' PARMS="BLKSIZE=1048576";
ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE' PARMS="BLKSIZE=1048576";
send 'NSR_ENV=(NSR_SERVER=xxxx,NSR_CLIENT=xxx,NSR_DATA_VOLUME_POOL=xxx,NSR_NO_MULTIPLEX=TRUE,NSR_MMDB_RETRY_TIME=10)';
BACKUP
not backed up 1 times
filesperset 4
FORMAT 'al_%s_%p_%t'
archivelog all delete input;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
ALLOCATE CHANNEL D1 TYPE DISK;
copy current controlfile to '/nsr/script/xxxx.bak';
RELEASE CHANNEL D1;
host 'save -s xxx -g xxxx -c xxxx /nsr/script/xxxx.bak ';
}
通道的参数,是备份存储的调优参数,可以忽略。
数据库本来是非归档模式,后来要在线备份才切过来的,所以归档不大,4 GB左右。
收起