Oracle DBA命令参考——alter database
来源:互联网 发布:詹姆斯上赛季数据 编辑:程序博客网 时间:2024/05/16 06:11
alter database:修改数据文件
alter database datafile 4 offline;
alter database datafile '/opt/oracle/datafile/users01.dbf' offline;
alter database datafile '/opt/oracle/datafile/users01.dbf' resize 100M;
alter database datafile '/opt/oracle/datafile/users01.dbf' autoextend on next 100M maxsize 1000M;
alter database datafile 4 end backup;
alter database:修改临时文件(tempfile)
alter database tempfile 4 resize 100M;
alter database tempfile 4 autoextend on next 100M maxsize 1000M;
alter database tempfile 4 drop including datafiles;
alter database tempfile 4 offline;
alter database:归档日志(archivelog)模式命令
alter database archivelog;
alter database noarchivelog;
alter database force logging;
alter database clear logfile '/opt/oracle/logfiles/redo01.rdo';
alter database clear unarchived logfile '/opt/oracle/logfiles/redo01.rdo';
alter database add supplemental log data;
alter database add supplemental log data (primary key,unique);
alter database drop supplemental log data;
alter database:控制文件操作
alter database backup controlfile to trace;
alter database backup controlfile to trace as '/opt/oracle/logfile_backup/backup_logfile.trc' reuse resetlogs;
alter database backup controlfile to '/opt/oracle/logfile_backup/backup_logfile.ctl';
alter database:创建数据文件
alter database create datafile '/opt/oracle/datafile/users01.dbf' as '/opt/oracle/datafile/users01.dbf';
alter database create datafile 4 as '/opt/oracle/datafile/users01.dbf';
alter database create datafile '/opt/oracle/datafile/users01.dbf' as new;
alter database:数据文件脱机/联机
参见“alter database:修改数据库文件”
alter database:日志文件命令
alter database add logfile group 2 ('/opt/oracle/logfiles/redo02a.rdo','/opt/oracle/logfile/redo02b.rdo') size 300M reuse;
alter database add logfile member '/opt/oracle/logfiles/redo02c.rdo' to gourp 2
alter database add logfile thread 3 group 2 ('/opt/oracle/logfiles/redo02a.rdo','/opt/oracle/logfiles/redo02b.rdo') size 300M reuse;
alter database drop logfile group 3
alter database drop logfile member '/opt/oracle/logfiles/redo02b.rdo';
alter database:安装和打开数据库
alter database mount;
alter database open;
alter database:移动或重命名数据库文件或联机重做日志
注意:数据库必须已经安装才能重命名或移动联机重做日志。数据库必须已经安装或数据文件处于脱机状态时,才能移动数据库中的数据文件。
alter database rename file '/ora/datafile/oldfile.dbf' to '/ora/datafile/newfile.dbf';
alter database:以只读方式打开数据库
alter database open read only;
alter database:使用resetlogs打开数据
alter database open resetlogs;
alter database:恢复数据库
对数据库的恢复,建议使用recover命令代替。
- Oracle DBA命令参考——alter database
- Oracle DBA命令参考——alter database
- 第二章 SQL命令参考-ALTER DATABASE
- Oracle命令--alter 操作
- Oracle alter session命令
- oracle alter命令大全
- ORACLE DBA命令
- oracle常用DBA命令
- oracle常用DBA命令
- 第二章 SQL命令参考-ALTER AGGREGATE
- 第二章 SQL命令参考-ALTER CONVERSION
- 第二章 SQL命令参考-ALTER FILESPACE
- 第二章 SQL命令参考-ALTER FUNCTION
- alter database
- ALTER DATABASE
- ALTER DATABASE ...
- ALTER DATABASE
- Oracle Database 11g DBA Handbook
- zoj 2770 Burn the Linked Camp
- 删除数据文件后在dba_data_files中仍旧遗留数据
- VS2005无法启动,停在启动界面,不显示IDE窗口。(VMvare的原因)
- ORA-01116: error in opening database file 89
- ORACLE 存储过程及TABLE里的数据用PL/SQL备份及用PLUS SQL还原
- Oracle DBA命令参考——alter database
- SPFile文件常用内容详解
- poj 3169 Layout
- USACO 1.4 clocks 分析
- datagrid内嵌combox
- 项目使用中Linq使用总结
- A sentence for a day
- 没有合适的构造函数可用??
- 让非商业版的Qt编译的程序在任何电脑上运行