Oracle: RMAN IMPLEMENTATION — Create Catalog Repository

PC & Tech Category

Oracle DBA - RMAN IMPLEMENTATION --create catalog repositoryRMAN IMPLEMENTATION

Target Database Name: Test

Catalog Database Name: Catdb

Problems

Creating RMAN repository in catalog database (catdb) & register the target database (test) in repository.

Login into catdb.

Step 1

Create Repository Tablespace and Schema

SQL> CREATE TABLESPACE RMAN
DATAFILE ‘C:ORACLEORADATACATALOGDBRMAN01.DBF’ SIZE 200m REUSE
AUTOEXTEND ON EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

Tablespace created.

Step 2

Create Repository Schema

SQL> CREATE USER RMAN IDENTIFIED BY RMAN
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE RMAN
QUOTA UNLIMITED ON RMAN;

User created.

Step 3

Privileges Assigned to RMAN user

SQL> GRANT RECOVERY_CATALOG_OWNER TO RMAN;

Grant succeeded.

SQL> GRANT CONNECT, RESOURCE TO RMAN;

Grant succeeded.

Step 4

Creating the Recovery Catalog

C:Documents and Settingsraja.baskar>RMAN CATALOG RMAN@CATDB

Recovery Manager: Release 9.2.0.7.0 – Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
Recovery catalog database Password:
Connected to recovery catalog database
Recovery catalog is not installed

RMAN> CREATE CATALOG;

Recovery catalog created

RMAN> Exit

Recovery Manager complete

Step 5

Let the Catalog Database keep information in its control file for 40 days. (Optional)

SQL> ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=40;

System altered.

SQL> SHOW PARAMETER CONTROL_FILE_RECORD_KEEP_TIME
NAME TYPE VALUE

Control_file_record_keep_time integer 40

Step 6

Setup Target Database (Register Database)

EACH DATABASE TO BE BACKED UP BY RMAN MUST BE REGISTERED.

C:Documents and Settingsraja.baskar>RMAN CATALOG=RMAN/xxxx@CATDB TARGET=SYS/xxxx@test

Recovery Manager: Release 9.2.0.7.0 – Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
Connected to target database: TEST (DBID=1933922270)
Connected to recovery catalog database

RMAN> REGISTER DATABASE;

Database registered in recovery catalog
Starting full resync of recovery catalog
Full resync complete

RMAN> LIST INCARNATION; shows what are the database registers in catalog database?

I Hope this article helped you to understand RMAN implementation.Suggestions are welcome.

Tags:

Edward Ramamoorthy Avatar

Help Us Grow

If you like this post, please share it with your friends.

You are free to copy and redistribute this article in any medium or format, as long as you keep the links in the article or provide a link back to this page.

Subscribe to Newsletter




Privacy Settings

Privacy & Cookie Overview

Our website uses cookies to provide you with the best user experience possible. These cookies are stored in your browser and perform essential functions such as recognizing you when you return to our website, as well as helping us to understand which sections of the website you find most useful and engaging.

To learn more, you can read our Privacy & Cookie Policy or reach out through our Contact form.

Strictly Necessary Cookies

Strictly Necessary Cookies must always be enabled to ensure the proper functioning of this website and to allow us to provide you with excellent service. These cookies are also essential for saving your cookie preferences.

Google Adsense

We use Google AdSense to keep this site free by displaying relevant ads. AdSense requires essential cookies that cannot be disabled, but you can manage other cookies. We respect your privacy and provide options to control non-essential cookies.

For more details on how Google handles your data, visit Google's Data Usage Policy. Please review our Privacy Policy for more information on how we protect your data.

AddToAny

We use AddToAny for social sharing. It doesnโ€™t store cookies, ensuring a privacy-friendly experience. AddToAny complies with GDPR and CCPA by default.

For more, see their Privacy Policy.

OneSignal

We use OneSignal to send notifications to users who opt in. OneSignal complies with GDPR and is certified under the EU-US and Swiss-US Privacy Shield frameworks.

For more, see their Privacy Policy.

3rd Party Cookies

This website utilizes third-party cookies, which can enhance your experience and support our ongoing efforts to improve our services.

Google Analytics

We use Google Analytics to collect anonymous data, such as visitor numbers and popular pages, to improve user experience and site performance. Keeping this cookie enabled helps us refine the site based on visitor activity.

For more information, see Googleโ€™s Privacy Policy.

Discover more from Prime Inspiration

Subscribe now to keep reading and get access to the full archive.

Continue reading