Use the CREATE CONTROLFILE command to create a new file. To do this you
must know all of the files for the database. Backing up a control file to trace on an occasional basis will help facilitate this process.here is an example,may be useful to you
CREATE CONTROLFILE REUSE
DATABASE orders_2
LOGFILE GROUP 1 ('diskb:log1.log', 'diskc:log1.log') SIZE 50K,
GROUP 2 ('diskb:log2.log', 'diskc:log2.log') SIZE 50K
NORESETLOGS
DATAFILE 'diska:dbone.dat' SIZE 2M
MAXLOGFILES 5
MAXLOGHISTORY 100
MAXDATAFILES 10
MAXINSTANCES 2
ARCHIVELOG
must know all of the files for the database. Backing up a control file to trace on an occasional basis will help facilitate this process.here is an example,may be useful to you
CREATE CONTROLFILE REUSE
DATABASE orders_2
LOGFILE GROUP 1 ('diskb:log1.log', 'diskc:log1.log') SIZE 50K,
GROUP 2 ('diskb:log2.log', 'diskc:log2.log') SIZE 50K
NORESETLOGS
DATAFILE 'diska:dbone.dat' SIZE 2M
MAXLOGFILES 5
MAXLOGHISTORY 100
MAXDATAFILES 10
MAXINSTANCES 2
ARCHIVELOG
解决方案 »
- 请教一个 存储过程的游标使用方法。。。。。。
- 菜鸟急求oracle问题
- SQL 语句
- oracle的sql里有没有这样的语法,use 数据库名 使用一个新的数据库 加急!! 送分
- 为什么Oracle数据库时间和操作系统时间不一致?
- 看看这条SQL语句怎么写??????
- 两个数据库之间拷贝表结构和数据
- 急需解决:WIN2000下安装完ora817后与java.exe发生冲突问题
- 求存储过程,如何在ORACLE里用游标?
- vb与oracle 8i的日期问题?????????????????????????
- 怎样把oracle9i的数据库备份并导入到oracle8.1.6里,在线等待!
- 请帮忙找 oracle8i的LINUX安装包glibc-2.1.3-stubs.tar.gz,谢谢。。。。
CREATE CONTROLFILE set DATABASE "data" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 500
MAXINSTANCES 1
MAXLOGHISTORY 1134
LOGFILE
GROUP 1 (
'/user1/tstdb/log01a.dbf',
'/user1/tstdb/log01b.dbf'
) SIZE 10M,
GROUP 2 (
'/user1/tstdb/log02a.dbf',
'/user1/tstdb/log02b.dbf'
) SIZE 10M
DATAFILE
'/user1/tstdb/system01.dbf'
CHARACTER SET ZHS16CGB231280
;
ALTER DATABASE OPEN RESETLOGS;
ALTER TABLESPACE TEMP ADD TEMPFILE '/user1/tst11idb/temp01.dbf' REUSE;
用internal登录后,执行ctl.sql