oracle 11g rman catalog,RMAN 创建catalog 数据库创建笔记

==========================

--RMAN 创建catalog 数据库

==========================

[[email protected] bin]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on 星期三 3月 9 15:32:00 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

--创建表空间

SQL> create tablespace rman_catalog;

Tablespace created.

--创建用户并授权

SQL> create user rman identified by rman default tablespace rman_catalog temporary tablespace temp;

grant connect,resource,create session,recovery_catalog_owner to rman;

User created.

SQL>

Grant succeeded.

SQL>

SQL>

SQL>

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

--注册数据库

[[email protected] bin]$ rman

Recovery Manager: Release 10.2.0.4.0 - Production on 星期三 3月 9 15:35:18 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

RMAN> connect catalog;

connected to recovery catalog database

RMAN> register database;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of register command at 03/09/2011 15:35:48

RMAN-06428: recovery catalog is not installed

RMAN> create catalog tablespace rman_catalog;

recovery catalog created

RMAN> register database;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of register command at 03/09/2011 15:36:44

RMAN-06171: not connected to target database

RMAN> connect catalog;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-06167: already connected

RMAN> connect target;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

ORA-01017: invalid username/password; logon denied

RMAN> connect target;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

RMAN> exit