1、双归档备份。两份一样的规定。

?alter system set log_archive_dest_1="LOCATION=/home/oracle/test/DISK5/offlinelog/ mandatory";?

注 mandatory?表示强制规定的完整性。规定没有写成功，重做日志文件不能被覆盖。
? alter system set log_archive_dest_2="LOCATION=/home/oracle/test/DISK7/offlinelog/";

2、查看

select destination,binding,target,status from v$archive_dest;

3、启动4个写归档日志进程。默认是2个。

? alter system set log_archive_max_processes=4

?

?

编辑备份脚本 冷备份backup.sql ,内容如下

onnect / as sysdba
shutdown immediate

host cp -Rb /u01/app/oracle/oradata/zhcTest /home/oracle/test/Backup/
host cp -Rb /u01/app/oracle/product/10.2.0/db_1/dbs /home/oracle/test/Backup/
startup

执行备份脚本

sql> @ /home/oracle/hotbackup.sql

?

?

?

?

?

?

?

?

?

?

?

热备

?

1、创建备份hotBackup.sql文件
connect / as sysdba
alter system archive log start;
alter tablespace company? begin backup;
host cp -R /u01/app/oracle/oradata/zhcTest/company /home/oracle/test/hotBackup/
host cp -R /u01/app/oracle/oradata/zhcTest/companyTemp /home/oracle/test/hotBackup/
alter tablespace company end backup;
alter system archive log current;

exit
注：? /home/oracle/test/hotBackup/ 下面没有同名文件
2、创建可执行脚本 oraback
sqlplus /nolog @ /u01/app/oracle/hotBackup.sql
3、把oraback做成定时执行

?