| |
A user in Linux under 11.2.0.4 to create RMAN virtual private directory error:
[Oracle @ jb ~] $ rman
Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:23:25 2015
Copyright (c) 1982, 2011, Oracle and / or its affiliates. All rights reserved.
RMAN> connect catalog vpc1 / vpc1 @ cs
Connected to recovery catalog database
RMAN> create virtual catalog
Found eligible base catalog owned by RMAN
RMAN-00571: ============================================== =============
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ============================================== =============
RMAN-06004: ORACLE error from recovery catalog database: ORA-00942: table or view does not exist
From the above information you can see the list of qualified base catalog owned by RMAN, that has found a qualified basic recovery directory users, because the use of the basic recovery directory user rman has registered the database, then create a basic recovery directory user cat1, virtual private directory User virtcat
1. Create a basic recovery directory user cat1, a virtual private directory user virtcat
SQL> create user cat1 identified by cat1
2 default tablespace sysaux
3 quota unlimited on sysaux;
User created.
SQL> grant recovery_catalog_owner to cat1;
Grant succeeded.
SQL> create user virtcat identified by virtcat
2 default tablespace sysaux
3 quota unlimited on sysaux;
User created.
SQL> grant recovery_catalog_owner to virtcat;
Grant succeeded.
2. Create a basic recovery catalog
[Oracle @ jb ~] $ rman catalog cat1 / cat1 @ cs
Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:24:50 2015
Copyright (c) 1982, 2011, Oracle and / or its affiliates. All rights reserved.
Connected to recovery catalog database
RMAN> create catalog;
Recovery catalog created
RMAN> grant register database to virtcat;
Grant succeeded.
3. Create a virtual private recovery directory
[Oracle @ jb cs] $ rman catalog virtcat / virtcat @ cs
Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:25:40 2015
Copyright (c) 1982, 2011, Oracle and / or its affiliates. All rights reserved.
Connected to recovery catalog database
RMAN> create virtual catalog
Found ineligible base catalog owned by RMAN
Found eligible base catalog owned by CAT1
Created virtual catalog against base catalog owned by CAT1
4. Register the target database in the virtual private directory
[Oracle @ jb cs] $ rman target sys / system @ db catalog virtcat / virtcat @ cs
Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:46:51 2015
Copyright (c) 1982, 2011, Oracle and / or its affiliates. All rights reserved.
Connected to target database: DB (DBID = 1640573015)
Connected to recovery catalog database
RMAN> register database;
Database registered in recovery catalog
Starting full resync of recovery catalog
Full resync complete
Summary: When creating and using a virtual private recovery directory, the target database can not be registered in the basic recovery catalog, or the RMAN-06004, ORA-00942 error messages occur.
|
|
|
|