Configure catalog in Oracle

Oracle configuration catalog 1: Create a tablespace in the catalog Database: export Oracle_SID = ORCLcreate tablespace rmants datafile '/home/oracle/rman/rmants. ora 'size 20 M; Note: The tablespace name must not be rman. If it is rman, an error will be reported next, because rman is a keyword; www.2cto.com 2. create a user on the catalog Database: SQL> Create user rman identified by rman default tablespace rmants 2 temporary tablespace temp quota unlimited on rmants; SQL> grant recovery_catalog_owner to rman; in this example, two databases are on the same server. Next, go to target database 1 and [oracle @ aoracle admin] $ vi tnsnames. oracatalog = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.190.140) (PORT = 1521) (CONNECT_DATA = (SID = ORCL ))) 2. [oracle @ aoracle ~] $ Tnsping catalog to check whether it can be connected. 3. On the primary database: export ORACLE_SID = niutest [oracle @ aoracle ~] $ Rman target/catalog rman/rman @ catalog *** if a TNS error occurs, the listener is used. add a connection string www.2cto.com SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME =/home/lc_orauser/app) (PROGRAM = extproc) to ora )) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME =/home/lc_orauser/app) (SID_NAME = ORCL) 4. If 3 is successful, then: www.2cto.com RMAN> create catalog tablespace rmants; recovery catalog created5; register the catalog database RMAN> register database in the target database; database registered in recovery catalostarting full resync of recovery catalogfull resync complete