创建恢复管理器目录:
在创建恢复目录之前,首先介绍几个从操作系统的提示符下运行RMAN的命令行选项。
命令行参数 | 描述 |
TARGET | 为目标数据库定义的一个连接字符串,当连接到一个目标数据库时,该连续是SYSDBA连接。该用户拥有启动和关闭数据库的权利,必须属于OSDBA组,必须建立一个口令文件允许SYSDBA连接。 |
CATALOG | 连接到恢复目录。 |
NOCATALOG | 不运用恢复目录。与CATALOG参数互斥 |
CMDFILE | 定义了输出命令文件名称的字符串。当运行RMAN时,可以运行命令文件或者交互式运行 |
LOG & MSGLOG | 定义了包含RMAN输出信息的文件的字符串,LOG参数只能特别运用在命令行中。不能在RMAN中启动SPOOLING,当应用日志文件时,输出的信息并不在屏幕上显示 |
TRACE | 类似于log参数,将产生一个显示RMAN输入信息的文件。使用TRACE在屏幕上也显示。 |
APPEND | 特殊用法,如果消息日志文件存在则将消息追加到该文件中。经常与LOG联合使用 |
E:>rman Recovery Manager: Release 9.2.0.1.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. RMAN> connect catalog rman92/rman@huiyi2 connected to recovery catalog database RMAN> create catalog tablespace cattbs; recovery catalog created RMAN> exit RMAN> connect catalog rman92/rman@huiyi2 connected to recovery catalog database SYS@huiyi2>select segment_name,segment_type from dba_segments where tablespace_name='CATTBS' and rownum<10; SEGMENT_NAME SEGMENT_TYPE ------------------------------ ------------------------------------ RCVER TABLE DB TABLE CONF TABLE DBINC TABLE CKP TABLE TS TABLE TSATT TABLE DF TABLE DFATT TABLE 9 rows selected. E:>rman Recovery Manager: Release 9.2.0.1.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. RMAN> connect target / connected to target database: HUIYI (DBID=2592573446) RMAN> connect catalog rman92/rman@huiyi2 connected to recovery catalog database RMAN> register database; database registered in recovery catalog starting full resync of recovery catalog full resync complete RMAN> list incarnation; List of Database Incarnations DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 13 HUIYI 2592573446 NO 183768 06-Mar-07 10:49:42 1 2 HUIYI 2592573446 YES 486090821 08-Mar-07 17:30:19 RMAN> report schema; Report of database schema File K-bytes Tablespace RB segs Datafile Name ---- ---------- -------------------- ------- ------------------- 1 337920 SYSTEM YES G:A9IORADATAHUIYISYSTEM01.DBF 2 204800 UNDOTBS1 YES G:A9IORADATAHUIYIUNDOTBS01.DBF 3 20480 DRSYS NO G:A9IORADATAHUIYIDRSYS01.DBF 4 149120 EXAMPLE NO G:A9IORADATAHUIYIEXAMPLE01.DBF 5 25600 INDX NO G:A9IORADATAHUIYIINDX01.DBF 6 20480 ODM NO G:A9IORADATAHUIYIODM01.DBF 7 10240 TOOLS NO G:A9IORADATAHUIYITOOLS01.DBF 8 25600 USERS NO G:A9IORADATAHUIYIUSERS01.DBF 9 39040 XDB NO G:A9IORADATAHUIYIXDB01.DBF 10 20480 TBS01 NO G:A9IORADATAHUIYITBS01.DBF
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8799875/viewspace-904941/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8799875/viewspace-904941/