Installing the RMAN Catalog

The catalog should be owned by a user with the resource role grant. I suggest a user in a small database dedicated to system administration functions such as the RMAN catalog and Enterprise Manager catalog. Create a tablespace for use by the RMAN user and assign that as the user’s default tablespace with unlimited quota. For example, if we wanted our user to be named rman_dba, the steps would be as follows:

The steps mentioned are available in Mike Ault’s Oracle DBA Made Simple by Rampant TechPress.

Once the catalog is built, the recovery manager can be utilized. The command is either rman, rman80, or RMAN80 depending on your operating system. There are literally dozens of commands for use with the RMAN facility. I suggest reviewing the Oracle8i Server Backup and Recovery Guide, Release 8.1.5 (or most current release) (Oracle Corporation, 1999) before using RMAN.

The following are some example scenarios showing how the commands can be made into scripts.

Connection to rman in UNIX on early versions can be tricky. On some UNICES the double quote (“) character has to be escaped, and you need to use the double quotes to log into rman (at least on early versions). Assuming the database to be backed up is ORTEST1 with a TNS alias of ORTEST1, the user is as specified earlier, and the catalog database is ORRMAN, the connection to RMAN for the user SYSTEM password MANAGER would look like this:

 $ rman ORTEST1\ system/manager@ORTEST1 rcvcat "rman_dbo/rman_dbo@ORRMAN\"

 Intuitive, isn’t it? A sample session from Recovery Manager (RMAN) is shown next.

The target database service name in the “tnsnames.ora” file is “ORTEST1.” The recovery catalog database service name in the “tnsnames.ora” file is “ORRMAN.”

The steps mentioned are available in Mike Ault’s Oracle DBA Made Simple by Rampant TechPress.

The above text is an excerpt from Mike Ault’s Oracle DBA Made Simple by Rampant TechPress.

OCP Instructors Guide for Oracle DBA Certification

If you need expert advice on teaching Oracle OCP exam certification concepts or if you just want an easy to understand guide to Oracle database administration, the OCP Instructors Guide for Oracle DBA Certification is for you.

Get your copy of today and receive immediate access to the Online Code Depot and OCP study summary! It’s only $19.95 (I don’t think it is right to charge a fortune for books!) and you can buy it right now and get immediate access to the online code depot:

http://www.rampant-books.com/book_2003_2_OCP_print.htm