如果在create controlfile是漏掉datafile会怎样呢?
来源:互联网 发布:怎么下载64位java 编辑:程序博客网 时间:2024/04/29 03:04
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination D:oraclearchive
Oldest online log sequence 10
Next log sequence to archive 12
Current log sequence 12
SQL> alter database backup controlfile to trace;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 135340020 bytes
Fixed Size 454644 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
--delete control,在create controlfile时故意漏掉一个文件'D:ORACLEORADATATESTTOOLS01.DBF'
SQL> CREATE CONTROLFILE REUSE DATABASE "TEST" NORESETLOGS ARCHIVELOG
2 -- SET STANDBY TO MAXIMIZE PERFORMANCE
3 MAXLOGFILES 5
4 MAXLOGMEMBERS 3
5 MAXDATAFILES 100
6 MAXINSTANCES 1
7 MAXLOGHISTORY 226
8 LOGFILE
9 GROUP 1 'D:ORACLEORADATATESTREDO01.LOG' SIZE 30M,
10 GROUP 2 'D:ORACLEORADATATESTREDO02.LOG' SIZE 30M,
11 GROUP 3 'D:ORACLEORADATATESTREDO03.LOG' SIZE 30M
12 -- STANDBY LOGFILE
13 DATAFILE
14 'D:ORACLEORADATATESTSYSTEM01.DBF',
15 'D:ORACLEORADATATESTUNDOTBS01.DBF',
16 'D:ORACLEORADATATESTEXAMPLE01.DBF',
17 'D:ORACLEORADATATESTINDX01.DBF'
18 CHARACTER SET ZHS16GBK
19 /
Control file created.
SQL> alter database open;
Database altered.
SQL> alter system switch logfile;
System altered.
--会在数据字典中发现漏掉的datafile
Select file_name , file_id, tablespace_name,status From dba_data_files
D:ORACLEORADATATESTSYSTEM01.DBF 1 SYSTEM AVAILABLE
D:ORACLEORADATATESTUNDOTBS01.DBF 2 UNDOTBS1 AVAILABLE
D:ORACLEORADATATESTEXAMPLE01.DBF 3 EXAMPLE AVAILABLE
D:ORACLEORADATATESTINDX01.DBF 4 INDX AVAILABLE
D:ORACLEORA92DATABASEMISSING00005 5 TOOLS AVAILABLE
SQL> alter tablespace tools rename datafile 'D:ORACLEORA92DATABASEMISSING000
05' to 'D:ORACLEORADATATESTTOOLS01.DBF';
Tablespace altered.
SQL> alter tablespace tools online;
alter tablespace tools online
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: 'D:ORACLEORADATATESTTOOLS01.DBF'
SQL> recover datafile 5;
Media recovery complete.
SQL> alter tablespace tools online;
Tablespace altered.
Select file_name , file_id, tablespace_name,status From dba_data_files
D:ORACLEORADATAZHANGYESYSTEM01.DBF 1 SYSTEM AVAILABLE
D:ORACLEORADATAZHANGYEUNDOTBS01.DBF 2 UNDOTBS1 AVAILABLE
D:ORACLEORADATAZHANGYEEXAMPLE01.DBF 3 EXAMPLE AVAILABLE
D:ORACLEORADATAZHANGYEINDX01.DBF 4 INDX AVAILABLE
D:ORACLEORADATAZHANGYETOOLS01.DBF 5 TOOLS AVAILABLE
检查表空间TOOLS上的object都没问题。
- 如果在create controlfile是漏掉datafile会怎样呢?
- 如果眼睛长在手上,大脑放在云端会怎样呢?
- mysql的AUTO_INCREMENT如果达到最大值会怎样呢?
- create controlfile
- 今日事件,如果是你,你会怎样???????
- 如果你是本杰明·富兰克林,会怎样学习编程?
- 如果快递机器人出现在中国,会怎样?
- 一年后 会怎样呢?
- 揭密:神秘的微软总部会是怎样的呢?(组图)
- 揭密:神秘的微软总部会是怎样的呢?(组图)(续)
- 揭密:神秘的微软总部会是怎样的呢?(组图)
- 没有'\0'标记的字符串输出会是怎样的呢?
- 对于自动编号的字段,如果插入时仍给出了该字段的值,结果会怎样呢?
- alter database create datafile ......
- 如果数据库处于归档模式但自动归档功能没有开启会产生什么后果呢,产生这种情况后又怎样解决呢?
- 如果每个人都随大流,结果会怎样?
- ORA-01503: CREATE CONTROLFILE failed
- ORA-01503: CREATE CONTROLFILE failed
- 夜叉-自由
- 窦唯-黑梦
- 黑豹I
- compress index试验
- SUSE 10.2 ATI X1300显卡Beryl 配置
- 如果在create controlfile是漏掉datafile会怎样呢?
- 生命的阳光
- 运用transport tablespace进行快速oracle版本升级(9i-10g)
- 刚到CSDN很期待啊!
- 从辞职说起
- DMA使用说明
- 浅谈vector、deque与list
- 数据库一致关闭后REDO LOG全部丢失的解决办法
- 转移统计信息