1. 在linux终端中输入su – oracle转移到ORACLE用户下
2. 键入：sqlplus system/oracle as sysdba (以DBA身份连接数据库) 3. 键入：archive log list；（查看是否归档）
4. SQL>archive log list Database log mode Archive Mode（如果是Archive Mode，则已经归档，可以跳过设置归档，如果不是Archive Mode，则继续执行下一步：设置归档） Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 10484
Next log sequence to archive 10486
Current log sequence 10486
设置归档
5. 键入：shutdown immediate; (立即关闭数据库)
6. 键入：startup mount (启动实例并加载数据库，但不打开)
7. 键入：alter database archivelog; (更改数据库为归档模式)
8. 键入：alter database open; (打开数据库)
1． 为了完善备份以及磁盘空间，则应该设置备份策略
2． 键入：quit；（设置归档后退出SQLPLUS）
3． 键入：RMAN（进入恢复管理器）
4． rman>connect target / (连接进入目标数据库)
5． Rman>show all;（查看所有配置参数）
6． Rman> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;保留7天的备份
7． Rman>quit;(退出)
在执行备份之前，我们应该设置一个存放备份的路径
设置之前应该转换到ROOT用户下：键入：su – root （更改用户）
1． 键入：mkdir /home/oraclebackup （新建备份目录）
2． 键入：chmod 775 oraclebackup（授予读写以及执行权限）
键入：chown –R oracle：oinstall /home/oraclebackup（授予目录组权限）
LINUX下自动备份星期一全备，星期二至星期天增量备份
1.首先建立备份脚本
2.在linux终端下执行[oracle@localhost ~]$ cd /home/oracleatbackup/
3.接着键入：touch rmanlevel0.sh rmanlevel1.sh （建立全备和增量备份的脚本）
4.编辑全备脚本：vi rmanlevel0.sh
键入如下：
#!/bin/sh
source ~/.bash_profile
#set porfile_env
export ORACLE_SID=orcl # rman level0 backup
rman <<EOF
connect target /;
run
{
allocate channel dev1 device type disk maxpiecesize 2G;
#allocate channel dev1 device type disk maxpiecesize 2G;
sql 'alter system archive log current';
backup incremental level 0 database
include current controlfile
format '/home/oracleatbackup/backup_%T_%s_%p.lv0'
plus
archivelog delete all input
format '/home/oracleatbackup/backup_%T_%s_%p.arc';
backup spfile format '/home/oracleatbackup/sp_%T_%U ';
release channel dev1;
#release channel dev1;
}
EOF
手工测试全备脚本：sh /home/oracleatbackup/rmanlevel0.sh，结果如下：
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 8 10:41:25 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN>
connected to target database: ORCL (DBID=1247015921)
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16>
using target database control file instead of recovery catalog
allocated channel: dev1
channel dev1: sid=144 devtype=DISK
sql statement: alter system archive log current
Starting backup at 08-JUN-13
current log archived
channel dev1: starting archive log backupset
channel dev1: specifying archive log(s) in backup set
input archive log thread=1 sequence=19 recid=13 stamp=817555288
input archive log thread=1 sequence=20 recid=14 stamp=817555288
channel dev1: starting piece 1 at 08-JUN-13
channel dev1: finished piece 1 at 08-JUN-13
piece handle=/home/oracleatbackup/backup_20130608_23_1.arc tag=TAG20130608T104129 comment=NONE
channel dev1: backup set complete, elapsed time: 00:00:02
channel dev1: deleting archive log(s)
archive log filename=/opt/oracle/11.2.0/db_1/flash_recovery_area/ORCL/archivelog/2013_06_08/o1_mf_1_19_8v6v685n_.arc recid=13 stamp=817555288
archive log filename=/opt/oracle/11.2.0/db_1/flash_recovery_area/ORCL/archivelog/2013_06_08/o1_mf_1_20_8v6v68wj_.arc recid=14 stamp=817555288
Finished backup at 08-JUN-13
Starting backup at 08-JUN-13
channel dev1: starting incremental level 0 datafile backupset
channel dev1: specifying datafile(s) in backupset
input datafile fno=00001 name=/opt/oracle/11.2.0/db_1/oradata/orcl/system01.dbf
input datafile fno=00003 name=/opt/oracle/11.2.0/db_1/oradata/orcl/sysaux01.dbf
input datafile fno=00005 name=/opt/oracle/11.2.0/db_1/oradata/orcl/example01.dbf
input datafile fno=00002 name=/opt/oracle/11.2.0/db_1/oradata/orcl/undotbs01.dbf
input datafile fno=00004 name=/opt/oracle/11.2.0/db_1/oradata/orcl/users01.dbf
channel dev1: starting piece 1 at 08-JUN-13
channel dev1: finished piece 1 at 08-JUN-13
piece handle=/home/oracleatbackup/backup_20130608_24_1.lv0 tag=TAG20130608T104131 comment=NONE
channel dev1: backup set complete, elapsed time: 00:14:20
channel dev1: starting incremental level 0 datafile backupset
channel dev1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel dev1: starting piece 1 at 08-JUN-13
channel dev1: finished piece 1 at 08-JUN-13
豫公网安备41160202000603
站长QQ:729038198
关于我们
投诉建议