某AIX+Oracle11g+ASM数据库系统,因业务需要需要存储扩容。
1.任务及环境
1)任务
存储DS5300的RAID10组新划出2个300G的LUN给RAC的两台小机,并将其添加到DATA磁盘组供RAC数据库使用。
2)环境
主机:2台P750小型机;
操作系统:AIX 6.1;
存储:1台DS5300;
数据库:Oracle11.2.0.3.0 RAC+ASM;
2.实施步骤
1)RMAN备份
# mkdir -p /backup/20201210
# chown -R oracle:dba /backup/
# su - oracle
$ cd /backup/20201210
$ touch rmanbackup.sh
$ chmod 744 rmanbackup.sh
$ vi rmanbackup.sh
run{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
backup as compressed backupset full database format '/backup/20201210/db_%U_%d' tag="full" spfile include current controlfile;
sql 'alter system archive log current';
change archivelog all crosscheck;
backup as compressed backupset archivelog all format '/backup/20201210/arch_%t_%s' tag="archivelog";
release channel ch1;
release channel ch2;