配置RMAN恢復目錄
2024-07-21 02:40:11
供稿：網友
1、創建rman用戶及相應的tablespace
SQL> conn sys/admin@redhat_db as sysdba
已連接。
SQL> set wrap off
SQL> set linesize 1000
SQL> set timing on
SQL> select * from v$version; BANNER
-------------------------------------------------------------------------------
Oracle9i EnterPRise Edition Release 9.2.0.4.0 - ProdUCtion
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production1、創建rman用戶及相應的tablespace
SQL> conn sys/admin@redhat_db as sysdba
已連接。
SQL> set wrap off
SQL> set linesize 1000
SQL> set timing on
SQL> select * from v$version;BANNER
-------------------------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production已用時間: 00: 00: 00.01
SQL> create tablespace ts_backup
2 datafile '/u01/oracle/oradata/test/ts_backup01.dbf' size 50m;表空間已創建。已用時間: 00: 00: 11.07
SQL> create user rman
2 identified by rman
3 default tablespace ts_backup
4 temporary tablespace temp;用戶已創建已用時間: 00: 00: 00.02
SQL> grant connect,resource,recovery_catalog_owner to rman;授權成功。已用時間: 00: 00: 00.02
SQL> 2、telnet到catalog服務器
Red Hat Linux release 9 (Shrike)
Kernel 2.4.20-8 on an i686
login: oracle
PassWord:
Last login: Thu Jun 23 15:49:04 on :0
-bash: ss#: command not found
[oracle@Harrison oracle]$ rmanRecovery Manager: Release 9.2.0.4.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.RMAN> connect catalog rman/rmanconnected to recovery catalog database
recovery catalog is not installed
RMAN> create catalog tablespace ts_backup/*創建恢復目錄模式對象*/recovery catalog createdRMAN> exit
Recovery Manager complete.
[oracle@Harrison oracle]$ rman target sys/admin@harrison catalog rman/rman@redhat_dbRecovery Manager: Release 9.2.0.4.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.connected to target database: GLEDESON (DBID=2735459423)
connected to recovery catalog databaseRMAN> register database;/*使用恢復目錄注冊數據庫*/database registered in recovery catalog
starting full resync of recovery catalog
full resync completeRMAN>
