Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]


My Cloud Certifications:
Oracle Cloud Infrastructure 2018 Certified Architect Associate.
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.
Oracle Database Cloud Administrator Certified Professional.
Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Wednesday, July 21, 2010

Create RMAN recovery catalog

labrman01(RCAT) /ora_backup/datafile
>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jul 21 10:31:55 2010

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 user RCAT10G identified by rcat10g default tablespace RCAT;

User created.


SQL> grant connect,resource,recovery_catalog_owner to rcat10g;

Grant succeeded.

SQL>exit

labrman01(RCAT) /ora_backup/datafile
>rman

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Jul 21 10:36:20 2010

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


RMAN> connect catalog rcat10g/rcat10g@RCAT

connected to recovery catalog database

RMAN> create catalog

recovery catalog created

RMAN> exit


Recovery Manager complete.
labrman01(RCAT) /ora_backup/datafile
>rman

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Jul 21 10:38:33 2010

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

RMAN> connect target sys/syspwd@HYPP

connected to target database: HYPP (DBID=2563884143)

RMAN> connect catalog rcat10g/rcat10g@RCAT

connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN>exit

No comments: