oracle 创建备份目录,Oracle rman创建和自动化备份

数据库版本：Oracle 10.2.0.5  x86_64

操作系统版本：Oracle Linux 5.7  x86_64

注：#表示为root用户下输入该命令, $表示为oracle用户下输入该命令。

1.创建rman catalog

#su - oracle

$sqlplus / as sysdba

SQL>

create tablespace CATALOG

datafile '/u02/oradata/data/CATALOG_01.dbf'

size 20M

autoextend on

next 5M maxsize 2G

extent management local;

SQL>

create user rman identified by rman

default tablespace CATALOG

temporary tablespace TEMP_SPC

quota unlimited on CATALOG;

SQL> grant connect,recovery_catalog_owner to rman;

SQL> exit

$rman target system/system123 catalog rman/rman

RMAN> create catalog;

RMAN> register database;

2.创建目录

$mkdir -p /u01/oracle/backup/orcl存放备份文件

$mkdir -p /u01/oracle/backup/orcl/log存放备份日志

$mkdir -p /home/