[20151022]Create Recovery Catalog.txt

[20151022]Create Recovery Catalog.txt

--要测试rman catalog的一些我问题，做一个建立的记录(实际上以前做过)：

1.CONNECT sys/password AS SYSDBA

CREATE TABLESPACE rman DATAFILE

  '/u01/app/oracle11g/oradata/test/rman01.dbf' SIZE 64M AUTOEXTEND ON NEXT 16M MAXSIZE UNLIMITED

LOGGING

PERMANENT

EXTENT MANAGEMENT LOCAL AUTOALLOCATE

BLOCKSIZE 8K

SEGMENT SPACE MANAGEMENT MANUAL

FLASHBACK ON;

-- Create rman schema owner

CREATE USER rman IDENTIFIED BY rman

TEMPORARY TABLESPACE temp

DEFAULT TABLESPACE rman

QUOTA UNLIMITED ON rman;

GRANT connect, resource, recovery_catalog_owner TO rman;

2.Create the recovery catalog.

===以前建立过1次，版本太低，我升级到11.2.0.3.

$ rlwrap rman  catalog=rman/rman

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Oct 22 08:35:04 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.01 in RCVCAT database is not current

PL/SQL package RMAN.DBMS_RCVMAN version 11.02.00.01 in RCVCAT database is not current

RMAN> drop catalog ;

recovery catalog owner is RMAN

enter DROP CATALOG command again to confirm catalog removal

--需要再执行一次。

RMAN> drop catalog

recovery catalog dropped

===========

$ rman catalog=rman/rman

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Nov 30 11:56:59 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN> create catalog tablespace "RMAN";

recovery catalog created

RMAN>

3.Register Database

Each database to be backed up by RMAN must be registered with the catalog.

$ rman catalog=rman/rman@rman target=sys/btbtms

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Nov 30 12:02:41 2011

connected to target database: TEST (DBID=2060755746)

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

4.unregister database:

RMAN> unregister database;

database name is "TEST" and DBID is 2060755746

Do you really want to unregister the database (enter YES or NO)? YES

database unregistered from the recovery catalog