Oracle-rman-3

http://blog.csdn.net/leshami/article/details/6032525 Rman Overview and architecture

Http://blog.itpub.net/23513800/viewspace-664869/rman help command

Restore the creation of a directory

RC Library Operation 192.168.3.222
Sqlplus/as SYSDBA
Create Tablespace Rmans;
Create user Rmans identified by 123456 default tablespace rmans QUOTA UNLIMITED on Rmans;
SELECT * from dba_roles where role like '%cata% ';
SELECT * from Dba_sys_privs WHERE GRANTEE like '%cata% ';
Grant Recovery_catalog_owner to Rmans;

This is a redo operation on the RC library (if there is a problem, do it again)
Drop user Rmans cascade;
Drop tablespace Rmans including contents;
Create Tablespace Rmans;
Create user Rmans identified by 123456
Default Tablespace Rmans
Quota Unlimited rmans;//This line must add, or will report the first mistake (no permission of the wrong)
Grant Recovery_catalog_owner to Rmans;
Alter user Rmans quota Unlimited on rmans;//if the user is created without adding, add up


Operation 192.168.3.202 on the target library
Rman Catalog [email protected]
Create catalog;
Connect target/This statement is either in the same session or the following statement (reconnection) can
Rman Target/catalog Rmans
Register database;



There are two errors that need to be dealt with.
Error One:
rman> Create catalog;

Error creating Config_update
ORACLE Error from Recovery catalog Database:ora-01950:no privileges on tablespace ' Rmans '

ORACLE Error from Recovery catalog database:ora-00942:table or view does not exist

You just need the following statement.
Alter user Rmans quota unlimited on Rmans;

Error Two:
rman> Create catalog;

Error creating DB
ORACLE Error from Recovery catalog database:ora-00955:name are already used by an existing object

ORACLE Error from Recovery catalog database:ora-00942:table or view does not exist

Discard the rebuild on the target library.
Drop catalog;
Drop catalog;
Exit
Rman Catalog [email protected]
Create Catlog;


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

rman> Drop Catalog;

Recovery Catalog owner is Rmans
Enter DROP Catalog command again to confirm catalog removal

rman> Drop Catalog;

Recovery Catalog dropped

Rman> exit


Recovery Manager complete.
[Email protected] ~]$ Rman Catalog [email protected]

Recovery manager:release 11.2.0.4.0-production on Mon 14 18:34:53 2017

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

Recovery Catalog Database Password:
Connected to Recovery Catalog database

rman> Create catalog;

Recovery Catalog Created

Rman> Connect Target/

Connected to target DATABASE:KYC (dbid=111003738)

rman> Register database;

Database registered in Recovery catalog
Starting full resync of recovery catalog
Full Resync Complete

Rman>

Oracle-rman-3