似曾相识燕归来的博客

1.控制文件重建在sqlplus中：1)       alter database backup controlfile to trace;进行控制文件的语句级备份；2)       show parameterbackground_dump_dest;查询警告日志文件的位置；3)       $start c:\d124451\diag\diag\rdbms\d124451\

1.查看日志视图select * from v$log;select * from v$logfile;2.强制执行日志切换alter system switch logfile;3.强制执行检查点操作ALTER SYSTEM CHECKPOINT;4..添加联机重做日志文件组ALTER DATABASE ADD LOGFILE GROUP 1

1.查看归档模式archive log list2.更改归档模式在sqlplus中：shutdown immediatestartup mountalter database archivelog;alter database open;在cmd窗口中：rman target system/124451@d124451backup database;

1. 移动数据文件（表空间可以脱机）ALTER TABLESPACE USER72E OFFLINE;$move E:\APP\TEACHER\ORADATA\D124451\USERS01.DBF E:\orc11g\disk1\USERS01.DBFALTER TABLESPACE USER72E RENAMEDATAFILE 'E:\APP\TEACHER

创建普通表RJCSTU_BEB1create table RJCSTU_BEB1(s_no char(11),s_fullname nvarchar2(12),stusex varchar2(6) default '女',s_enroll date default sysdate,stu_score number(5,0) default 510,stumonitor char(1

1.创建表空间TBS_512CREATE TABLESPACE TBS_512DATAFILE'd:\ora11g\D124451\disk6\D0AEF.DDD' SIZE 120M AUTOEXTEND ONNEXT 5M MAXSIZE 650MONLINEPERMANENTEXTENTMANAGEMENT LOCAL UNIFORM SIZE 58K

1)       修改db_create_file_dest为'd:\ora11g\D124451\disk6'ALTER SYSTEM SETdb_create_file_dest = 'd:\ora11g\D124451\disk6';2)       使用OMF机制创建表空间TIBS_FGFCREATE TABLESPACE TIBS_FGFDATAFILE SIZE 8

1)       修改配置文件DEFAULTALTER PROFILE DEFAULT LIMITPASSWORD_LIFE_TIME UNLIMITEDPASSWORD_GRACE_TIME UNLIMITEDPASSWORD_REUSE_TIME UNLIMITEDPASSWORD_REUSE_MAX UNLIMITEDFAILED_LOGIN_ATTEMPTS UNL

1)       创建用户USR_124451CREATE USER USR_124451IDENTIFIED BY "ad3lmasdfdfc23,bt"DEFAULT TABLESPACE T4_GAETEMPORARY TABLESPACE TBST_BBDQUOTA 9M on T4_GAEPROFILE PRO_271;2)       给用户USR_1244