对一个测试人员使用的测试数据库做简单的RMAN定时备份,过程如下,比较粗糙,见谅:--1.查看数据库基本信息,是否归档,归档存放地址,快速恢复区大小等[oracle@sean ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 1 18:00:05 2017Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> archive log list
Database log mode No Archive Mode --未归档
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST --归档地址为快速恢复区
Oldest online log sequence 198
Current log sequence 200
SQL> show parameter recoveryNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/fast_recovery_area --快速恢复区地址
db_recovery_file_dest_size big integer 4182M --快速恢复区大小
recovery_parallelism integer 0--2.开启归档模式SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.Total System Global Area 496922624 bytes
Fixed Size 2254504 bytes
Variable Size 159385944 bytes
Database Buffers 331350016 bytes
Redo Buffers 3932160 bytes
Database mounted.
SQL> alter database archivelog;Database altered.SQL> alter database open;Database opened.--3.修改归档地址和快速恢复区大小(可选),本例子不修改地址,修改大小alter system set db_recovery_file_dest_size = 10g;--4.修改rman默认参数[oracle@sean ~]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Thu Jun 1 18:05:13 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database: SEAN (DBID=1642013397, not open)RMAN> show all;using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name SEAN are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_sean.f'; # defaultRMAN> CONFIGURE BACKUP OPTIMIZATION ON; --开启优化备份RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; --开启控制文件自动备份RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2; --设置备份冗余数为2--5.编写rman备份脚本
[oracle@localhost ~]$ cat backup_full_db.sh
#!/bin/bash#set environment variablesORACLE_SID=orcl
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID ORACLE_BASE ORACLE_HOME PATHrman target / <<EOFrun{
allocate channel c1 type disk;
backup full tag 'dbfull_orcl' database;
sql 'alter system archive log current';
backup archivelog all delete input;
release channel c1;crosscheck backup;
crosscheck archivelog all;
delete expired backup;
delete expired archivelog all;delete noprompt obsolete;
}
EOF--5.1修改备份脚本文件执行权限
chmod 755 backup_full_db.sh
--6.设置crontab定时调度[oracle@localhost ~]$ cat /etc/crontab
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
HOME=/# For details see man 4 crontabs# Example of job definition:
# .---------------- minute (0 - 59)
# | .------------- hour (0 - 23)
# | | .---------- day of month (1 - 31)
# | | | .------- month (1 - 12) OR jan,feb,mar,apr ...
# | | | | .---- day of week (0 - 6) (Sunday=0 or 7) OR sun,mon,tue,wed,thu,fri,sat
# | | | | |
# * * * * * user-name command to be executed
0 23 * * * oracle /home/oracle/backup_full_db.sh
详细解决方案
Oracle rman定时备份数据库
热度:28 发布时间:2024-01-16 02:25:05.0
相关解决方案
- oracle 分页排序,ssi,该怎么处理
- oracle 最近的时间(而不是前一天的时间) 跪求sql语句 。解决方法
- oracle,该怎么解决
- oracle 安装时出现 java tm 异常
- android访问其他数据库(如:oracle、MySql等),希望大家给点建议!解决方案
- oracle 安插 LONG VARCHAR 类型数据
- oracle loadjava如何用
- oracle,该如何处理
- C# + SQL server +oracle QQ交流群142703980解决方法
- VS10连接Oracle的有关问题:"Oracle.DataAccess.Client.OracleConnection"的类型初始值设定项引发错误
- Oracle-参数查询有关问题
- oracle,insert 语句插入一条记录后要求,返回主键id値。解决思路
- Oracle 10g下的SQL语句,有点难度.请~[同时向朋友们道歉~]
- 月统计(oracle)解决办法
- 在线紧急等一sql语句(oracle),该怎么处理
- oracle 连接数据库该如何写语句的
- oracle 客户端链接服务端的方式?该如何解决
- Oracle select后表的最左首的数字
- Oracle 服务器字符集和pl/sql字符集有关问题,
- Oracle DBA解决方案
- oracle 中表名的连接解决方法
- oracle 老鸟进,新人求指点解决方法
- oracle 恢复删除的表,该怎么解决
- oracle 数据自动增长,该怎么解决
- 求推荐数据库脚本编纂的书籍(oracle)
- oracle 数据库,该如何解决
- oracle 用室外部验证
- 高分寻 oracle 锁机制 并行安插表数据数量的控制方法
- oracle 中表名的联接
- oracle 11G 企业版跟标准版有什么区别