似曾相识燕归来的博客

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 list 2.更改归档模式 在sqlplus中： shutdown immediate startup mount alter database archivelog; alter database open; 在cmd窗口中： rman target system/124451@d124451 backup database;

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

创建普通表RJCSTU_BEB1 create 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_512 CREATE TABLESPACE TBS_512 DATAFILE'd:\ora11g\D124451\disk6\D0AEF.DDD' SIZE 120M AUTOEXTEND ONNEXT 5M MAXSIZE 650M ONLINE PERMANENT EXTENTMANAGEMENT LOCAL UNIFORM SIZE 58K

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

1)       修改配置文件DEFAULT ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED PASSWORD_REUSE_TIME UNLIMITED PASSWORD_REUSE_MAX UNLIMITED FAILED_LOGIN_ATTEMPTS UNL

1)       创建用户USR_124451 CREATE USER USR_124451 IDENTIFIED BY "ad3lmasdfdfc23,bt" DEFAULT TABLESPACE T4_GAE TEMPORARY TABLESPACE TBST_BBD QUOTA 9M on T4_GAE PROFILE PRO_271; 2)       给用户USR_1244