Catalog Guide 1@@@@create a new database using dbca ORACLE_SID=catalog ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 ....... 2@@@@detial SQL> conn /as sysdba; SQL> create tablespace tbscatalog datafile '/u01/app/oracle/oradata/catalog/tbscatalog.dbf' size 200M; Tablespace created. SQL> create user ucata identified by oracle default tablespace tbscatalog; User created. SQL> grant connect,recovery_catalog_owner to ucata; Grant succeeded. SQL> alter user ucata quota unlimited on tbscatalog; User altered. SQL> conn ucata/oracle Connected. SQL> select count(*) from tab; COUNT(*) ---------- 0 [oracle@station78 ~]$ cd $TNS_ADMIN [oracle@station78 admin]$ cat tnsnames.ora | head -n 12 CATALOG = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = station78.example.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = catalog) ) ) [oracle@station78 admin]$ lsnrctl start [oracle@station78 admin]$ tnsping catalog ................... Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = station78.example.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = catalog))) OK (0 msec) @@@Note: @@@as the client of catalog, my shell assigned the tns is "rmandb" @@@you must make sure has rmandb point to the catalog db. as the below: RMANDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = station78.example.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = catalog) ) ) 3@@@@ example $rman target / catalog ucata/oracle@rmandb rman> cretae catalog tablespace tbscatalog; @@@create catalog ; drop catalog rman> register database @@@unregister database; rman> resync catalog $rman target / catalog ucata/oracle@rmandb rman> set dbid 19293242 @@@if you have many db register the database
Oracle10g Catalog
原创emperor_majesty 博主文章分类:B_Recovery ©著作权
©著作权归作者所有:来自51CTO博客作者emperor_majesty的原创作品,谢绝转载,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Oracle11g之Duplicate配置ADG
Oracle11g之ADG配置
oracle SQL hive -
oracle10G集群
有时间研究下,oracle的集群配置
Oracle oracle 集群配置