oracle10g 归档日志文件夹设置

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做成定时执行