ITPub博客

首页 > IT基础架构 > 网络安全 > catalog与nocatalog方式下report_schema中RB segs结果对比

catalog与nocatalog方式下report_schema中RB segs结果对比

原创 网络安全 作者:warehouse 时间:2013-07-21 18:20:56 0 删除 编辑
RB segs的结果nocatalog方式下一直显示的是***,在catalog方式下可以显示出YES和NO,讲课时发现的随手记录一下。[@more@]

C:>rman target / nocatalog

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jul 21 15:34:05 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: TEST (DBID=2118208806)
using target database control file instead of recovery catalog

RMAN> report schema;

Report of database schema for database with db_unique_name TEST

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 700 SYSTEM *** E:ORADATATESTSYSTEM01.DBF
2 600 SYSAUX *** E:ORADATATESTSYSAUX01.DBF
3 10 TEST *** E:ORADATATESTTEST.DBF
4 10 USERS *** E:ORADATATESTUSERS01.DBF
5 10 TEST1 *** E:ORADATATESTTEST1.DBF
7 10 UNDOTBS2 *** E:ORADATATESTUNDOTBS02.DBF

RMAN> exit


Recovery Manager complete.

C:>rman target sys/system@abc catalog rman/rman@catalog

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jul 21 15:34:17 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: TEST (DBID=2118208806)
connected to recovery catalog database

RMAN> report schema;

Report of database schema for database with db_unique_name TEST

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 700 SYSTEM YES E:ORADATATESTSYSTEM01.DBF
2 600 SYSAUX NO E:ORADATATESTSYSAUX01.DBF
3 10 TEST NO E:ORADATATESTTEST.DBF
4 10 USERS NO E:ORADATATESTUSERS01.DBF
5 10 TEST1 NO E:ORADATATESTTEST1.DBF
7 10 UNDOTBS2 YES E:ORADATATESTUNDOTBS02.DBF

RMAN>

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/19602/viewspace-1060759/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-07

  • 博文量
    717
  • 访问量
    5366318