ITPUB论坛－专业的IT技术社区

登录 注册
ITPUB论坛－专业的IT技术社区»论坛 › ≡ 大数据与数据库 ≡ › Oracle数据库管理 › 控制文件恢复，不慎弄得复杂了，不知道有没有的机会恢复 ...
1234下一页
返回列表 发新帖
楼主: 6month
收藏 | 打印 上一主题 下一主题

控制文件恢复，不慎弄得复杂了，不知道有没有的机会恢复出来了/

[复制链接]
shooterchan
论坛徽章:
4
生肖徽章2007版:鼠 日期:2008-01-02 17:35:53生肖徽章2007版:蛇 日期:2009-03-10 21:14:36生肖徽章2007版:鼠 日期:2009-03-10 21:19:05生肖徽章2007版:鼠 日期:2009-03-10 21:32:40
11#
发表于 2008-4-8 16:36 | 只看该作者
你确认用的是新的控制文件，仔细检查一下。

使用道具 举报

回复
6month
论坛徽章:
6
2008新春纪念徽章 日期:2008-02-13 12:43:03奥运会纪念徽章:击剑 日期:2008-06-22 18:55:25奥运会纪念徽章:击剑 日期:2008-07-26 19:36:52奥运会纪念徽章:蹦床 日期:2008-10-24 13:19:51生肖徽章2007版:羊 日期:2008-11-26 08:28:14CTO参与奖 日期:2009-02-12 11:45:48
12#
 楼主| 发表于 2008-4-8 17:01 | 只看该作者
是新的阿，这个是我今天上午用alter database backup controlfile to trace 生成的，
为什么现在就不行呢
而且我自动备份的archive今天的只有下面3个（4月8日的）
'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_234_3ZOS4YDP_.ARC'
'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_233_3ZO6ZJB8_.ARC
'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_232_3ZNN6QBQ_.ARC
根本没有发现提示的
'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_161_%U_.ARC'文件

奇怪了

使用道具 举报

回复
6month
论坛徽章:
6
2008新春纪念徽章 日期:2008-02-13 12:43:03奥运会纪念徽章:击剑 日期:2008-06-22 18:55:25奥运会纪念徽章:击剑 日期:2008-07-26 19:36:52奥运会纪念徽章:蹦床 日期:2008-10-24 13:19:51生肖徽章2007版:羊 日期:2008-11-26 08:28:14CTO参与奖 日期:2009-02-12 11:45:48
13#
 楼主| 发表于 2008-4-8 17:01 | 只看该作者
下面是我再次执行的步骤，。。。


SQL> startup nomount
ORACLE instance started.

Total System Global Area  251658240 bytes
Fixed Size                  1248356 bytes
Variable Size              75498396 bytes
Database Buffers          167772160 bytes
Redo Buffers                7139328 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS  ARCHIVELOG
  2      MAXLOGFILES 16
  3      MAXLOGMEMBERS 3
  4      MAXDATAFILES 100
  5      MAXINSTANCES 8
  6      MAXLOGHISTORY 292
  7  LOGFILE
  8    GROUP 1 'E:ORACLEPRODUCT10.2.0ORADATAORCLREDO01.LOG'  SIZE 50M,
  9    GROUP 2 'E:ORACLEPRODUCT10.2.0ORADATAORCLREDO02.LOG'  SIZE 50M,
10    GROUP 3 'E:ORACLEPRODUCT10.2.0ORADATAORCLREDO03.LOG'  SIZE 50M
11  -- STANDBY LOGFILE
12  DATAFILE
13    'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF',
14    'E:ORACLEPRODUCT10.2.0ORADATAORCLUNDOTBS01.DBF',
15    'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSAUX01.DBF',
16    'E:ORACLEPRODUCT10.2.0ORADATAORCLUSERS01.DBF',
17    'E:ORACLEPRODUCT10.2.0ORADATAORCLEXAMPLE01.DBF',
18    'E:ORACLEPRODUCT10.2.0ORADATAORCLCHINA.DBF',
19    'E:ORACLEPRODUCT10.2.0ORADATAORCLCHINA1.DBF'
20  CHARACTER SET WE8MSWIN1252
21  ;

Control file created.

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  251658240 bytes
Fixed Size                  1248356 bytes
Variable Size              75498396 bytes
Database Buffers          167772160 bytes
Redo Buffers                7139328 bytes
Database mounted.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 5555756 generated at 03/25/2008 10:30:21 needed for thread 1
ORA-00289: suggestion : E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_161_%U_.ARC
ORA-00280: change 5555756 for thread 1 is in sequence #161


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_161_%U_.ARC'
ORA-00308: cannot open archived log 'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_161_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_234_3ZOS4YDP_.ARC'
ORA-00310: archived log contains sequence 234; sequence 161 required
ORA-00334: archived log: 'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_234_3ZOS4YDP_.ARC'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 5555756 generated at 03/25/2008 10:30:21 needed for thread 1
ORA-00289: suggestion : E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_161_%U_.ARC
ORA-00280: change 5555756 for thread 1 is in sequence #161


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_234_3ZOS4YDP_.ARC'
ORA-00310: archived log contains sequence 234; sequence 161 required
ORA-00334: archived log: 'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_234_3ZOS4YDP_.ARC'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'

[ 本帖最后由 6month 于 2008-4-8 17:03 编辑 ]

使用道具 举报

回复
wobenkl
论坛徽章:
1
2010新春纪念徽章 日期:2010-03-01 11:19:52
14#
发表于 2008-4-8 17:10 | 只看该作者
mount后，alter database open resetlogs
用这个试试

使用道具 举报

回复
paulyibinyi
论坛徽章:
76
双子座 日期:2015-07-28 14:26:072012新春纪念徽章 日期:2012-02-13 15:09:52ITPUB十周年纪念徽章 日期:2011-11-01 16:21:15鲜花蛋 日期:2011-08-26 02:02:24管理团队成员 日期:2011-05-07 01:45:082010广州亚运会纪念徽章:皮划艇 日期:2011-04-18 11:24:412011新春纪念徽章 日期:2011-02-18 11:43:342011新春纪念徽章 日期:2011-01-25 15:42:562011新春纪念徽章 日期:2011-01-25 15:42:332011新春纪念徽章 日期:2011-01-25 15:42:15
15#
发表于 2008-4-8 17:20 | 只看该作者
原帖由 6month 于 2008-4-8 17:01 发表
下面是我再次执行的步骤，。。。


SQL> startup nomount
ORACLE instance started.

Total System Global Area  251658240 bytes
Fixed Size                  1248356 bytes
Variable Size              75498396 bytes
Database Buffers          167772160 bytes
Redo Buffers                7139328 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS  ARCHIVELOG
  2      MAXLOGFILES 16
  3      MAXLOGMEMBERS 3
  4      MAXDATAFILES 100
  5      MAXINSTANCES 8
  6      MAXLOGHISTORY 292
  7  LOGFILE
  8    GROUP 1 'E:ORACLEPRODUCT10.2.0ORADATAORCLREDO01.LOG'  SIZE 50M,
  9    GROUP 2 'E:ORACLEPRODUCT10.2.0ORADATAORCLREDO02.LOG'  SIZE 50M,
10    GROUP 3 'E:ORACLEPRODUCT10.2.0ORADATAORCLREDO03.LOG'  SIZE 50M
11  -- STANDBY LOGFILE
12  DATAFILE
13    'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF',
14    'E:ORACLEPRODUCT10.2.0ORADATAORCLUNDOTBS01.DBF',
15    'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSAUX01.DBF',
16    'E:ORACLEPRODUCT10.2.0ORADATAORCLUSERS01.DBF',
17    'E:ORACLEPRODUCT10.2.0ORADATAORCLEXAMPLE01.DBF',
18    'E:ORACLEPRODUCT10.2.0ORADATAORCLCHINA.DBF',
19    'E:ORACLEPRODUCT10.2.0ORADATAORCLCHINA1.DBF'
20  CHARACTER SET WE8MSWIN1252
21  ;

Control file created.

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  251658240 bytes
Fixed Size                  1248356 bytes
Variable Size              75498396 bytes
Database Buffers          167772160 bytes
Redo Buffers                7139328 bytes
Database mounted.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 5555756 generated at 03/25/2008 10:30:21 needed for thread 1
ORA-00289: suggestion : E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_161_%U_.ARC
ORA-00280: change 5555756 for thread 1 is in sequence #161


Specify log: {=suggested | filename | AUTO | CANCEL}
'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_161_%U_.ARC'
ORA-00308: cannot open archived log 'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_161_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


Specify log: {=suggested | filename | AUTO | CANCEL}
'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_234_3ZOS4YDP_.ARC'
ORA-00310: archived log contains sequence 234; sequence 161 required
ORA-00334: archived log: 'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_234_3ZOS4YDP_.ARC'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 5555756 generated at 03/25/2008 10:30:21 needed for thread 1
ORA-00289: suggestion : E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_161_%U_.ARC
ORA-00280: change 5555756 for thread 1 is in sequence #161


Specify log: {=suggested | filename | AUTO | CANCEL}
'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_234_3ZOS4YDP_.ARC'
ORA-00310: archived log contains sequence 234; sequence 161 required
ORA-00334: archived log: 'E:ARCHIVELOGORCLARCHIVELOG2008_04_08O1_MF_1_234_3ZOS4YDP_.ARC'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'

输入cancel
再alter database open resetlogs;

使用道具 举报

回复
五“宅”一生
论坛徽章:
98
2009日食纪念 日期:2009-07-22 09:30:002010新春纪念徽章 日期:2010-03-01 11:05:012010年世界杯参赛球队：美国 日期:2010-05-02 21:32:232010数据库技术大会纪念徽章 日期:2010-05-13 09:34:23ITPUB季度 技术新星 日期:2010-05-17 15:53:17数据库板块每日发贴之星 日期:2010-05-24 01:01:072010年世界杯参赛球队：意大利 日期:2010-05-31 20:55:432010年世界杯参赛球队：巴拉圭 日期:2010-07-03 13:06:582010世博会纪念徽章 日期:2010-08-18 23:53:44ITPUB9周年纪念徽章 日期:2010-10-08 09:28:51
16#
发表于 2008-4-8 22:14 | 只看该作者
关注中！！

使用道具 举报

回复
ZALBB
论坛徽章:
314
行业板块每日发贴之星 日期:2012-07-12 18:47:29双黄蛋 日期:2011-08-12 17:31:04咸鸭蛋 日期:2011-08-18 15:13:51迷宫蛋 日期:2011-08-18 16:58:25紫蛋头 日期:2011-08-31 10:57:28ITPUB十周年纪念徽章 日期:2011-09-27 16:30:47蜘蛛蛋 日期:2011-10-20 15:51:25迷宫蛋 日期:2011-10-29 11:12:59ITPUB十周年纪念徽章 日期:2011-11-01 16:19:41鲜花蛋 日期:2011-11-09 20:33:30
17#
发表于 2008-4-8 23:02 | 只看该作者
楼主，你在恢复前，有没有备份了这个数据库？

使用道具 举报

回复
6month
论坛徽章:
6
2008新春纪念徽章 日期:2008-02-13 12:43:03奥运会纪念徽章:击剑 日期:2008-06-22 18:55:25奥运会纪念徽章:击剑 日期:2008-07-26 19:36:52奥运会纪念徽章:蹦床 日期:2008-10-24 13:19:51生肖徽章2007版:羊 日期:2008-11-26 08:28:14CTO参与奖 日期:2009-02-12 11:45:48
18#
 楼主| 发表于 2008-4-9 08:34 | 只看该作者
今早我再做的时候，又提示我要用4-09的archivelog了，但是我今天的还都没生成呢，奇怪了


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 5555756 generated at 03/25/2008 10:30:21 needed for thread 1
ORA-00289: suggestion : E:ARCHIVELOGORCLARCHIVELOG2008_04_09O1_MF_1_161_%U_.ARC
ORA-00280: change 5555756 for thread 1 is in sequence #161


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
'Eracleproduct10.2.0oradataorcl
edo01.log'
ORA-00310: archived log contains sequence 234; sequence 161 required
ORA-00334: archived log: 'E:ORACLEPRODUCT10.2.0ORADATAORCLREDO01.LOG'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'


SQL> 'Eracleproduct10.2.0oradataorcl
edo02.log'
SP2-0734: unknown command beginning "'Eracle..." - rest of line ignored.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 5555756 generated at 03/25/2008 10:30:21 needed for thread 1
ORA-00289: suggestion : E:ARCHIVELOGORCLARCHIVELOG2008_04_09O1_MF_1_161_%U_.ARC
ORA-00280: change 5555756 for thread 1 is in sequence #161


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
'Eracleproduct10.2.0oradataorcl
edo02.log'
ORA-00310: archived log contains sequence 233; sequence 161 required
ORA-00334: archived log: 'E:ORACLEPRODUCT10.2.0ORADATAORCLREDO02.LOG'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 5555756 generated at 03/25/2008 10:30:21 needed for thread 1
ORA-00289: suggestion : E:ARCHIVELOGORCLARCHIVELOG2008_04_09O1_MF_1_161_%U_.ARC
ORA-00280: change 5555756 for thread 1 is in sequence #161


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
'Eracleproduct10.2.0oradataorcl
edo03.log'
ORA-00310: archived log contains sequence 235; sequence 161 required
ORA-00334: archived log: 'E:ORACLEPRODUCT10.2.0ORADATAORCLREDO03.LOG'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 5555756 generated at 03/25/2008 10:30:21 needed for thread 1
ORA-00289: suggestion : E:ARCHIVELOGORCLARCHIVELOG2008_04_09O1_MF_1_161_%U_.ARC
ORA-00280: change 5555756 for thread 1 is in sequence #161


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'


ORA-01112: media recovery not started


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 5555756 generated at 03/25/2008 10:30:21 needed for thread 1
ORA-00289: suggestion : E:ARCHIVELOGORCLARCHIVELOG2008_04_09O1_MF_1_161_%U_.ARC
ORA-00280: change 5555756 for thread 1 is in sequence #161


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
'E:ARCHIVELOGORCLARCHIVELOG2008_04_09O1_MF_1_161_%U_.ARC'
ORA-00308: cannot open archived log 'E:ARCHIVELOGORCLARCHIVELOG2008_04_09O1_MF_1_161_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'


ORA-01112: media recovery not started

使用道具 举报

回复
6month
论坛徽章:
6
2008新春纪念徽章 日期:2008-02-13 12:43:03奥运会纪念徽章:击剑 日期:2008-06-22 18:55:25奥运会纪念徽章:击剑 日期:2008-07-26 19:36:52奥运会纪念徽章:蹦床 日期:2008-10-24 13:19:51生肖徽章2007版:羊 日期:2008-11-26 08:28:14CTO参与奖 日期:2009-02-12 11:45:48
19#
 楼主| 发表于 2008-4-9 08:50 | 只看该作者
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     233
Next log sequence to archive   233
Current log sequence           235
SQL> show parameter use_db
SQL>

使用道具 举报

回复
paulyibinyi
论坛徽章:
76
双子座 日期:2015-07-28 14:26:072012新春纪念徽章 日期:2012-02-13 15:09:52ITPUB十周年纪念徽章 日期:2011-11-01 16:21:15鲜花蛋 日期:2011-08-26 02:02:24管理团队成员 日期:2011-05-07 01:45:082010广州亚运会纪念徽章:皮划艇 日期:2011-04-18 11:24:412011新春纪念徽章 日期:2011-02-18 11:43:342011新春纪念徽章 日期:2011-01-25 15:42:562011新春纪念徽章 日期:2011-01-25 15:42:332011新春纪念徽章 日期:2011-01-25 15:42:15
20#
发表于 2008-4-9 08:53 | 只看该作者
关闭数据库后 物理删除控制文件
SQL> STARTUP NOMOUNT
ORACLE instance started.

Total System Global Area  546382300 bytes
Fixed Size                   455132 bytes
Variable Size             520093696 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "PUBTEST" NORESETLOGS  ARCHIVELOG
  2  --  SET STANDBY TO MAXIMIZE PERFORMANCE
  3      MAXLOGFILES 5
  4      MAXLOGMEMBERS 3
  5      MAXDATAFILES 5305
  6      MAXINSTANCES 1
  7      MAXLOGHISTORY 226
  8  LOGFILE
  9    GROUP 1 'D:ORACLEORADATAPUBTESTREDO01.LOG'  SIZE 100M,
10    GROUP 2 'D:ORACLEORADATAPUBTESTREDO02.LOG'  SIZE 100M,
11    GROUP 3 'D:ORACLEORADATAPUBTESTREDO03.LOG'  SIZE 100M
12  -- STANDBY LOGFILE
13  DATAFILE
14    'D:ORACLEORADATAPUBTESTSYSTEM01.DBF',
15    'D:ORACLEORADATAPUBTESTUNDOTBS01.DBF',
16    'D:ORACLEORADATAPUBTESTUSERS01.DBF'
17  CHARACTER SET ZHS16GBK
18  ;

Control file created.

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1217722 generated at 04/09/2008 08:49:09 needed for thread 1
ORA-00289: suggestion : D:ORACLEORA92RDBMSARC00005.001
ORA-00280: change 1217722 for thread 1 is in sequence #5


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log 'D:ORACLEORA92RDBMSARC00005.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


ORA-00308: cannot open archived log 'D:ORACLEORA92RDBMSARC00005.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL>




我这边这样也行啊,输入auto试试

使用道具 举报

回复

1234下一页
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有　联系我们 未成年人举报专区　
京ICP备16024965号-8 　北京市公安局海淀分局网监中心备案编号：11010802021510　广播电视节目制作经营许可证：编号（京）字第1149号   
快速回复 返回顶部 返回列表