Rman-catalog Backup and Recovery database

Source: Internet
Author: User

1. Set up a Recovery Catalog and Target Database
Setting up a Recovery catalog is a very simple process. This can is done through the Enterprise Manager GUI or through some simple commands in Sql*plus and the RMAN command-line Interface. In Sql*plus, any need to the create a tablespace to store the catalog data in, create an RMAN user, and then gran T the Recovery_catalog_owner role to the RMAN user. In Rman, run the Create Catalogstatement: (Connect to the Rman instance in sys, create a data table space, create a rcat user and authorize)

Sql>Conn SYS/Rman@rman  asSysdba--Need to create a newinstance Rman, and use the SYS user to connect to the Rmanis connected. SQL> CreateTablespace Rcatts datafile'D:\rman\rman_data\rcatts.dbf'size 1024M; table space created. SQL> Create UserRcat identified byRcatTemporaryTablespaceTemp  2     defaultTablespace Rcatts Quota Unlimited onRcatts; The user has created. SQL> GrantConnect, resource, Recovery_catalog_owner toRcat; authorized success. SQL> Exitfrom OracleDatabase11g Enterprise Edition Release11.2.0.1.0 -64bitProduction withThe partitioning, OLAP, Data Mining and RealApplication Testing Options Disconnect C:\Users\Administrator>

2, in the RMAN command-line interface, log in and create the catalog:

(Use the Rcat user you created in the previous step to log in and create the recovery directory)

C:\Users\Administrator>Rman Catalog=Rcat/Rcat@rman; Recovery manager: Release11.2.0.1.0 -Production onTuesday October7  at: the: to  theCopyright (c)1982, the, Oracleand/orits affiliates. Allrights reserved. Connecting to the Recovery catalog database Rman> CreateThe Recovery Catalog has created Rman>

3. Register the target database in the Recovery directory catalog

Now, need to register, the target database in the catalog. To does this, connect to the target and the catalog database and then register the target database in the catalog. This can is done from the either location. The target connection must has a user ID with sysdba privileges, so an Oracle password file must be created using the Ora PWD utility. As described in Chapter 3, your also need to create the Oracle networking configuration using TNSNames or a equivalent for Both the target and recovery catalog instances:

RMAN>Connect Catalog Rcat/Rcat@rman;--Connect to the recovery catalog database Rman-00571:===========================================================RMAN-00569:===============ERROR MESSAGE STACK follows===============RMAN-00571:===========================================================RMAN-06167: Rman is already connected>Connect Target Rusky/Rusky@orcl---Connect the target database ORCL, the user is Rusky, the password is Rusky to the target database: ORCL (DBID=1385990360) RMAN>RegisterDatabaseThe database registered in the recovery directory is starting the Resync of all recovery directories complete Resyncrman>

4. It's now time-to-back up your entire database

....

Rman-catalog Backup and Recovery database

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.