Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:/Documents and Settings/Administrator>sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on 星期二 4月 13 19:35:19 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
已连接。
SQL> shutdown immediate
ORA-01109: 数据库未打开
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup nomount
ORACLE 例程已经启动。
Total System Global Area 126950956 bytes
Fixed Size 454188 bytes
Variable Size 109051904 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "HBZSPT" RESETLOGS NOARCHIVELOG
2 MAXLOGFILES 64
3 MAXLOGMEMBERS 2
4 MAXDATAFILES 254
5 MAXINSTANCES 32
6 MAXLOGHISTORY 113
7 LOGFILE
8 GROUP 1 'E:/oracle/oradata/hbzspt/REDO01.LOG' SIZE 204800,
9 GROUP 2 'E:/oracle/oradata/hbzspt/REDO02.LOG' SIZE 204800,
10 GROUP 3 'E:/oracle/oradata/hbzspt/REDO03.LOG' SIZE 204800
11 DATAFILE
12 'E:/oracle/oradata/hbzspt/CWMLITE01.DBF',
13 'E:/oracle/oradata/hbzspt/DRSYS01.DBF',
14 'E:/oracle/oradata/hbzspt/EXAMPLE01.DBF',
15 'E:/oracle/oradata/hbzspt/GSYY_DATA.DBF',
16 'E:/oracle/oradata/hbzspt/GSYY_IDX.DBF',
17 'E:/oracle/oradata/hbzspt/INDX01.DBF',
18 'E:/oracle/oradata/hbzspt/JCPT_DATA.DBF',
19 'E:/oracle/oradata/hbzspt/JCPT_IDX.DBF',
20 'E:/oracle/oradata/hbzspt/ODM01.DBF',
21 'E:/oracle/oradata/hbzspt/PERM_IDX.DBF',
22 'E:/oracle/oradata/hbzspt/PERM_MAIN.DBF',
23 'E:/oracle/oradata/hbzspt/SYSTEM01.DBF',
24 'E:/oracle/oradata/hbzspt/TOOLS01.DBF',
25 'E:/oracle/oradata/hbzspt/UNDOTBS01.DBF',
26 'E:/oracle/oradata/hbzspt/USERS01.DBF',
27 'E:/oracle/oradata/hbzspt/XDB01.DBF',
28 'E:/oracle/oradata/hbzspt/CGS_BB.ORA',
29 'E:/oracle/oradata/hbzspt/CGS_GD.ORA',
30 'E:/oracle/oradata/hbzspt/CGS_IDX.ORA',
31 'E:/oracle/oradata/hbzspt/CGS_ZH.ORA',
32 'E:/oracle/oradata/hbzspt/CGS_ZS.ORA',
33 'E:/oracle/oradata/hbzspt/TBS_SKSKJ_MAIN.ORA'
34 CHARACTER SET ZHS16GBK
35 ;
控制文件已创建
SQL> shutdown
ORA-01109: ??????
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount
ORACLE 例程已经启动。
Total System Global Area 126950956 bytes
Fixed Size 454188 bytes
Variable Size 109051904 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
数据库装载完毕。
SQL> recover database using backup controlfile until cancel;
ORA-00279: 更改 9470563558941 (在 04/13/2010 11:15:56 生成) 对于线程 1 是必需的
ORA-00289: 建议: E:/ORACLE/ORA92/RDBMS/ARC89922.001
ORA-00280: 更改 9470563558941 对于线程 1 是按序列 # 89922 进行的
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
'E:/oracle/oradata/hbzspt/REDO01.LOG'
ORA-00310: 存档日志包含序列 89921;要求序列 89922
ORA-00334: 归档日志: 'E:/ORACLE/ORADATA/HBZSPT/REDO01.LOG'
SQL> recover database using backup controlfile until cancel;
ORA-00279: 更改 9470563558941 (在 04/13/2010 11:15:56 生成) 对于线程 1 是必需的
ORA-00289: 建议: E:/ORACLE/ORA92/RDBMS/ARC89922.001
ORA-00280: 更改 9470563558941 对于线程 1 是按序列 # 89922 进行的
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
'E:/oracle/oradata/hbzspt/REDO03.LOG'
ORA-00310: 存档日志包含序列 89920;要求序列 89922
ORA-00334: 归档日志: 'E:/ORACLE/ORADATA/HBZSPT/REDO03.LOG'
SQL> alter database open resetlogs;
数据库已更改。
SQL>