关于oracle数据备份
最近负责一个项目维护，这个项目的生产环境的数据库的那台服务器居然之前很久就被黑了，windows2003的系统，远程桌面连不上，感觉很怕哦，那天这个服务器出了问题，那不是数据都丢了？？ 之前的人没有备份，， 大家有经验的 教教我，正规的备份流程和操作。说的详细点哦。。谢谢！！！...显示全部
查看其它 5 个回答zyclove2008的回答
--备份归档、删除1天前的归档、备份控制文件（每天定时备份，在数据文件备份之后执行）
run {
allocate channel c1 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/xxx;
allocate channel c2 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/xxx;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup archivelog all;
DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
backup current controlfile format '/home/oracle/orabak/databack/controlfile_%T_%U.bak';
release channel c1;
release channel c2;
}
--备份归档
run {
allocate channel c1 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/xxx;
allocate channel c2 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/xxx;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup archivelog all;
DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
backup current controlfile format '/home/oracle/orabak/databack/controlfile_%T_%U.bak';
release channel c1;
release channel c2;
}
run {
allocate channel c1 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/xxx;
allocate channel c2 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/xxx;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup archivelog all;
DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
backup current controlfile format '/home/oracle/orabak/databack/controlfile_%T_%U.bak';
release channel c1;
release channel c2;
}
--备份归档
run {
allocate channel c1 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/xxx;
allocate channel c2 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/xxx;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup archivelog all;
DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
backup current controlfile format '/home/oracle/orabak/databack/controlfile_%T_%U.bak';
release channel c1;
release channel c2;
}
浏览1359