The Oracle Learning Rman (14) Catalog

Catalog is a stand-alone database used to store Rman metadata obtained from control files in the target database. RMAN propagates information about the database structure, archive redo logs, backup sets, and copies of the data files from the control files of the target database to the recovery directory. You should use a directory when you want to manage multiple target databases.

First look at the steps to create a catalog

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/70/AE/wKioL1W7fari4YaFAAGXYrXusp8614.jpg "title=" create Catalog. PNG "alt=" Wkiol1w7fari4yafaagxyrxusp8614.jpg "/>

1. Create a table space

sql> Create tablespace rman_ts; Tablespace created. Sql>

2. Create Catalog Owner

Sql> CREATE USER Rman identified by Rman DEFAULT tablespace rman_ts QUOTA UNLIMITED on Rman_ts; User created.

3. Assigning Permissions

Sql> GRANT Recovery_catalog_owner to Rman; Grant succeeded. sql> GRANT Connect, resource to Rman; Grant succeeded.

4. Create Catalog

The target database now configures a CATDB connection string that points to the Catlog database.

11gdg-> Rman Catalog Rman/[email protected]recovery manager:release 11.2.0.3.0-production on Thu Jul 9 11:36:49 2015  Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.connected to recovery catalog databaserman> Create catalog tablespace rman_ts;recovery Catalog Crea Ted

5. Connect to the target database and use catalog.

11gdg-> rman target / catalog rman/[email protected]recovery manager:  Release 11.2.0.3.0 - Production on Thu Jul 9 11:52:30  2015copyright  (c)  1982, 2011, oracle and/or its affiliates.  all  rights reserved.connected to target database: DEVDB  (dbid=789087786,  Not open) Connected to recovery catalog databaserman> 11gdg-> rman  target /                         recovery manager: release 11.2.0.3.0  - Production on Thu Jul 9 11:52:53 2015Copyright  (c)  1982,  2011, Oracle and/or its affiliates.  All rights  Reserved.connected to target database: devdb  (Dbid=789087786, not open) rman> connect catalog rman/[ Email protected]connected to recovery catalog databaserman>

6. Registering the target database

Rman> register database;database registered in recovery catalogstarting full resync of recovery Catalogfull Resync Comp Lete

This article is from the "Ding Dong" blog, please be sure to keep this source http://lqding.blog.51cto.com/9123978/1680721

The Oracle Learning Rman (14) Catalog