ORACLE之rman备份加密(二)
e Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@orcl#desc dba_tablespaces;
名称 是否为空 类型
----------------------------------------- -------- ----------------------------
TABLESPACE_NAME NOT NULL VARCHAR2(30)
BLOCK_SIZE NOT NULL NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NOT NULL NUMBER
MAX_EXTENTS NUMBER
MAX_SIZE NUMBER
PCT_INCREASE NUMBER
MIN_EXTLEN NUMBER
STATUS VARCHAR2(9)
CONTENTS VARCHAR2(9)
LOGGING VARCHAR2(9)
FORCE_LOGGING VARCHAR2(3)
EXTENT_MANAGEMENT VARCHAR2(10)
ALLOCATION_TYPE VARCHAR2(9)
PLUGGED_IN VARCHAR2(3)
SEGMENT_SPACE_MANAGEMENT VARCHAR2(6)
DEF_TAB_COMPRESSION VARCHAR2(8)
RETENTION VARCHAR2(11)
BIGFILE VARCHAR2(3)
PREDICATE_eva lUATION VARCHAR2(7)
ENCRYPTED VARCHAR2(3)
COMPRESS_FOR VARCHAR2(18)
SYS@orcl#select file_name,tablespace_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------------------------------------
/opt/oracle/oradata/ORCL/datafile/o1_mf_users_8no75m69_.dbf
USERS
/opt/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_8no736w0_.dbf
UNDOTBS1
/opt/oracle/oradata/ORCL/datafile/o1_mf_sysaux_8no736vh_.dbf
SYSAUX
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------------------------------------
/opt/oracle/oradata/ORCL/datafile/o1_mf_system_8no75lqw_.dbf
SYSTEM
/opt/oracle/oradata/ORCL/datafile/huadan
VPN_HUADAN
/opt/oracle/oradata/sysaux_add.dbf
SYSAUX
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
/opt/oracle/oradata/system_add.dbf
SYSTEM
已选择7行。
SYS@orcl#alter tablespace sysaux offline;
alter tablespace sysaux offline
*
第 1 行出现错误:
ORA-01116: 打开数据库文件 6 时出错
ORA-01110: 数据文件 6: '/opt/oracle/oradata/sysaux_add.dbf'
ORA-27041: 无法打开文件
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SYS@orcl#shutdown immediate
ORA-01116: 打开数据库文件 6 时出错
ORA-01110: 数据文件 6: '/opt/oracle/oradata/sysaux_add.dbf'
ORA-27041: 无法打开文件
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SYS@orcl#select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SYS@orcl#shutdown abort;
ORACLE 例程已经关闭。
SYS@orcl#
SYS@orcl#
SYS@orcl#exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
oracle@oracle:~/oradata> rman target /
恢复管理器: Release 11.1.0.6.0 - Production on 星期四 3月 28 20:40:01 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
已连接到目标数据库 (未启动)
RMAN> startup mount;
Oracle 实例已启动
数据库已装载
系统全局区域总计 805875712 字节
Fixed Size 2148720 字节
Variable Size 553649808 字节
Database Buffers 243269632 字节
Redo Buffers 6807552 字节
RMAN> list backup of datafile 6;
使用目标数据库控制文件替代恢复目录
备份集列表
===================