当前位置：首页 » 编程博文

开发技术指南» 文章正文

    引言： ######### 创建数据库----look $ORACLE_

 

 

某人的oracle9i学习笔记，与大家分享

######### 创建数据库----look $oracle_home/rdbms/admin/buildall.sql #############

【程序编程相关:C++ Builder中实现MAPX的F】

【推荐阅读:Php操作xml文件 - 读取、显示】

create database db01 【扩展信息:xml-通过 XML 发布新闻】

maxlogfiles 10

maxdatafiles 1024

maxinstances 2

logfile

group 1 (´/u01/oradata/db01/log_01_db01.rdo´) size 15m,

group 2 (´/u01/oradata/db01/log_02_db01.rdo´) size 15m,

group 3 (´/u01/oradata/db01/log_03_db01.rdo´) size 15m,

datafile ´u01/oradata/db01/system_01_db01.dbf´) size 100m,

undo tablespace undo

datafile ´/u01/oradata/db01/undo_01_db01.dbf´ size 40m

default temporary tablespace temp

tempfile ´/u01/oradata/db01/temp_01_db01.dbf´ size 20m

extent management local uniform size 128k

character set al32ute8

national character set al16utf16

set time_zone=´america/new_york´;

############### 数据字典 ##########

set wrap off

select * from v$dba_users;

grant select on table_name to user/rule;

select * from user_tables;

select * from all_tables;

select * from dba_tables;

revoke dba from user_name;

shutdown immediate

startup nomount

select * from v$instance;

select * from v$sga;

select * from v$tablespace;

alter session set nls_language=american;

alter database mount;

select * from v$database;

alter database open;

desc dictionary

select * from dict;

desc v$fixed_table;

select * from v$fixed_table;

set oracle_sid=foxconn

select * from dba_objects;

set serveroutput on

execute dbms_output.put_line(´sfasd´);

############# 控制文件 ###########

select * from v$database;

select * from v$tablespace;

select * from v$logfile;

select * from v$log;

select * from v$backup;

/*备份用户表空间*/

alter tablespace users begin backup;

select * from v$archived_log;

select * from v$controlfile;

alter system set control_files=´$oracle_home/oradata/u01/ctrl01.ctl´,

´$oracle_home/oradata/u01/ctrl02.ctl´ scope=spfile;

cp $oracle_home/oradata/u01/ctrl01.ctl $oracle_home/oradata/u01/ctrl02.ctl

startup pfile=´../initsid.ora´

select * from v$parameter where name like ´control%´ ;

show parameter control;

select * from v$controlfile_record_section;

select * from v$tempfile;

/*备份控制文件*/

alter database backup controlfile to ´../filepath/control.bak´;

/*备份控制文件,并将二进制控制文件变为了asc 的文本文件*/

alter database backup controlfile to trace;

############### redo log ##############

archive log list;

alter system archive log start;--启动自动存档

alter system switch logfile;--强行进行一次日志switch

alter system checkpoint;--强制进行一次checkpoint

alter tablspace users begin backup;

alter tablespace offline;

/*checkpoint 同步频率参数fast_start_mttr_target,同步频率越高,系统恢复所需时间越短*/

show parameter fast;

show parameter log_checkpoint;

/*加入一个日志组*/

alter database add logfile group 3 (´/$oracle_home/oracle/ora_log_file6.rdo´ size 10m);

/*加入日志组的一个成员*/

alter database add logfile member ´/$oracle_home/oracle/ora_log_file6.rdo´ to group 3;

/*删除日志组:当前日志组不能删;活动的日志组不能删;非归档的日志组不能删*/

alter database drop logfile group 3;

/*删除日志组中的某个成员,但每个组的最后一个成员不能被删除*/

alter databse drop logfile member ´$oracle_home/oracle/ora_log_file6.rdo´;

/*清除在线日志*/

alter database clear logfile ´$oracle_home/oracle/ora_log_file6.rdo´;

alter database clear logfile group 3;

/*清除非归档日志*/

...   下一页

» 本期热门文章：

· 热门栏目：

» 相关精选文章

» 其它相关：