|
配置RMAN恢复目录
1、创建rman用户及相应的tablespaceSQL> conn sys/admin@redhat_db as sysdba已连接。SQL> set wrap offSQL> set linesize 1000SQL> set timing onSQL> select * from v$version;
BANNER-------------------------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.4.0 - ProductionPL/SQL Release 9.2.0.4.0 - ProductionCORE 9.2.0.3.0 ProductionTNS for Linux: Version 9.2.0.4.0 - ProductionNLSRTL Version 9.2.0.4.0 - Production
1、创建rman用户及相应的tablespaceSQL> conn sys/admin@redhat_db as sysdba已连接。SQL> set wrap offSQL> set linesize 1000SQL> set timing onSQL> select * from v$version;
BANNER-------------------------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.4.0 - ProductionPL/SQL Release 9.2.0.4.0 - ProductionCORE 9.2.0.3.0 ProductionTNS for Linux: Version 9.2.0.4.0 - ProductionNLSRTL Version 9.2.0.4.0 - Production
已用时间: 00: 00: 00.01SQL> create tablespace ts_backup 2 datafile '/u01/oracle/oradata/test/ts_backup01.dbf' size 50m;
表空间已创建。
已用时间: 00: 00: 11.07SQL> create user rman 2 identified by rman 3 default tablespace ts_backup 4 temporary tablespace temp;
用户已创建
已用时间: 00: 00: 00.02SQL> grant connect,resource,recovery_catalog_owner to rman;
授权成功。
已用时间: 00: 00: 00.02SQL>
2、telnet到catalog服务器Red Hat Linux release 9 (Shrike)Kernel 2.4.20-8 on an i686login: oraclePassword:Last login: Thu Jun 23 15:49:04 on :0-bash: ss#: command not found[oracle@Harrison oracle]$ rman
Recovery Manager: Release 9.2.0.4.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect catalog rman/rman
connected to recovery catalog databaserecovery catalog is not installed
RMAN> create catalog tablespace ts_backup/*创建恢复目录模式对象*/
recovery catalog created
RMAN> exit
Recovery Manager complete.[oracle@Harrison oracle]$ rman target sys/admin@harrison catalog rman/rman@redhat_db
Recovery Manager: Release 9.2.0.4.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: GLEDESON (DBID=2735459423)connected to recovery catalog database
RMAN> register database;/*使用恢复目录注册数据库*/
database registered in recovery catalogstarting full resync of recovery catalogfull resync complete
RMAN>
查看上一页
返回分类首页 返回96PC首页
查看下一页 |
