oracle 逻辑备份脚本,某Oracle真实RMAN备份脚本和策略分享：

某Oracle真实RMAN备份脚本和策略分享：

(2012-05-16 20:15:50)

标签：

杂谈

【自动作业 crontab 内容】

#* * * * * /oradata3/oracle/rman/rman1

#10 10 03 * * /oradata3/oracle/rman/rman0

#20 10 * * 6 /oradata3/oracle/rman/rman1

20 10 * * 6 /oradata3/oracle/rman/rman0bak

#00 01 * * 0,1,2,3,4,5 /oradata3/oracle/rman/rman2

【各脚本】

more /oradata3/oracle/rman/rman1

rman target / log=/oradata4/oracle/rman/${DATE}backup1.log

<

delete noprompt obsolete;

run

{

allocate channel d1 device type disk;

backup incremental level 1

format '/oradata4/oracle/rman/%d_%s_%p.bak_1'

(database include current controlfile filesperset=2 );

sql 'alter system archive log current';

backup archivelog all format '/oradata4/oracle/rman/arc_%s_%p.bk_1'

delete all input;

}

EOF

more /oradata3/oracle/rman/rman0

rman target / log=/oradata3/oracle/rman/${DATE}backup0.log

><

run

{

backup incremental level 0

format '/oradata3/oracle/rman/%d_%s_%p.bak_0'

(database include current controlfile filesperset=2 );

sql 'alter system archive log current';

backup archivelog all format '/oradata3/oracle/rman/arc_%s_%p.bk_0'

delete all input;

}

delete noprompt obsolete;

EOF

exit

more /oradata3/oracle/rman/rman1

rman target / log=/oradata4/oracle/rman/${DATE}backup1.log

<

delete noprompt obsolete;

run

{

allocate channel d1 device type disk;

backup incremental level 1

format '/oradata4/oracle/rman/%d_%s_%p.bak_1'

(database include current controlfile filesperset=2 );

sql 'alter system archive log current';

backup archivelog all format '/oradata4/oracle/rman/arc_%s_%p.bk_1'

delete all input;

}

EOF

exit

more /oradata3/oracle/rman/rman0bak

rman target / log=/oradata3/oracle/rman/${DATE}backup0.log

><

run

{

backup incremental level 0 database filesperset=3;

sql 'alter system switch logfile';

backup archivelog all delete all input;

delete noprompt obsolete;

}

EOF

exit

more /oradata3/oracle/rman/rman2

rman target / log=/oradata3/oracle/rman/backup2.log

<

delete noprompt obsolete;

run

{

allocate channel d1 device type disk;

backup incremental level 2 tag 'db_2'

format '/oradata3/oracle/rman/%d_%s_%p.bak_2'

(database include current controlfile filesperset=2 );

sql 'alter system archive log current';

backup archivelog all format '/oradata3/oracle/rman/arc_%s_%p.bk_2'

delete all input;

}

EOF

exit

RMAN> show all;

using target database control file instead of recovery

catalog

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO

'/oradata3/orabak/rman/%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO COMPRESSED

BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; #

default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; #

default

CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT

'/oradata3/orabak2/rman/%d_%T%t%p';

CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT

'/oradata3/orabak1/rman/%d_%T%t%p';

CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT

'/oradata5/oracle/rman1/%d_%T%t%p';

CONFIGURE CHANNEL 4 DEVICE TYPE DISK FORMAT

'/oradata5/oracle/rman2/%d_%T%t%p';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO

'/opt/oracle/oracle/product/10.2.0/db_1/dbs/snapcf_bix.f'; #

default

分享：

喜欢

0

赠金笔

加载中，请稍候......

评论加载中，请稍候...

发评论

登录名： 密码： 找回密码 注册记住登录状态

昵   称：

评论并转载此博文

发评论

以上网友发言只代表其个人观点，不代表新浪网的观点或立场。