Rman备份配置

环境:
生产库:
OS:Solaris 10
DB:Oracle 10g
备份库:
OS:Windows
DB:Oracle 10g
RMAN备份配置过程:
建议将数据库启动到归档模式下:
SQL>shutdown immediate
SQL>startup mount
SQL>alter database archivelog;
SQL>alter database open;
SQL>archive log list;
恢复目录的配置
创建恢复目录表空间:
SQL> create tablespace ts_rman
  2  datafile 'C:\oracle\product\10.2.0\oradata\rman\rman01.dbf' size 2000m
  3  extent management local;
Tablespace created.
创建恢复目录User:
SQL> create user rman
  2  profile default
  3  identified by rman
  4  default tablespace ts_rman
  5  temporary tablespace temp
  6  account unlock;
User created.
用户授权:
SQL> grant connect,resource,recovery_catalog_owner to rman;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
为恢复目录创建对象:
D:\>rman catalog rman/rman
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jan 31 11:17:34 2007
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to recovery catalog database
RMAN> create catalog tablespace ts_rman;
recovery catalog created
RMAN>exit
注册目标数据库:
D:\>rman catalog rman/rman target system/system@oradb
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jan 31 11:31:05 2007
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: ORADB (DBID=2366502499)
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN>exit

说明:
    被备份的库的用户需要是具有sysdba权限(select * from v$pwfile_users;),可以通过给用户授权来达到目的地(grant sysdba to dname;).