alter database操作

1 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;2 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;3 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;4 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";5 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;6 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 2alter 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 3alter database drop logfile member "/opt/oracle/logfiles/redo02b.rdo";7 alter database：安装和打开数据库alter database mount;alter database open;8 alter database：移动或重命名数据库文件或联机重做日志注意：数据库必须已经安装才能重命名或移动联机重做日志。数据库必须已经安装或数据文件处于脱机状态时，才能移动数据库中的数据文件。alter database rename file "/ora/datafile/oldfile.dbf" to "/ora/datafile/newfile.dbf";9 alter database：以只读方式打开数据库alter database open read only;10 alter database：使用resetlogs打开数据alter database open resetlogs;11 alter database：恢复数据库对数据库的恢复，建议使用recover命令代替。Oracle数据库的状态查询Oracle几种常见启动方式比较相关资讯 Oracle数据库 Oracle入门教程 oracle数据库教程

Oracle数据库全球化（03月01日）
Oracle数据库日期过滤方法性能比较（02/02/2015 13:20:26）
Oracle数据库安装中端口被占用问题（10/29/2014 07:42:24）

在CentOS 6.6上搭建C++运行环境并（10/10/2015 19:44:40）
Oracle数据库无法使用localhost和（11/14/2014 16:39:10）
使用SQLT来构建Oracle测试用例（08/28/2014 06:17:41）

本文评论查看全部评论（0）