oracle8.17中如何通过svgmgrl手工将数据库恢复(只有*.ora文件)

uk 2001-07-20 05:51:22
...全文
93 点赞 收藏 4
写回复
4 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
uk 2001-07-23
guo(正在消化Oracle) : 你在csdn吗?
回复
uk 2001-07-23
我试了一下,服务是连上了(太好了 ),可为什么我的数据库里面的用户表都没有了呢?
回复
uk 2001-07-21
上班后我才能试,到时候再跟你联系,谢谢!
回复
guo 2001-07-20
我可以给你一个控制文件重建的脚本,但没有日志文件的重建这没试过

Dump file D:\oracle\admin\win\udump\ORA01060.TRC
Fri Jul 20 18:14:29 2001
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 , CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 , CPU type 586
Instance name: win

Redo thread mounted by this instance: 1

Oracle process number: 11

Windows thread id: 1060, image: ORACLE.EXE


*** SESSION ID:(10.3) 2001-07-20 18:14:29.495
*** 2001-07-20 18:14:29.495
# The following commands will create a new control file and use it
# to open the database.
# Data used by the recovery manager will be lost. Additional logs may
# be required for media recovery of offline data files. Use this
# only if the current version of all online logs are available.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "WIN" NORESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE
GROUP 1 (
'D:\ORACLE\ORADATA\WIN\REDO11.LOG',
'D:\ORACLE\ORADATA\WIN\REDO12.LOG'
) SIZE 1M,
GROUP 2 (
'D:\ORACLE\ORADATA\WIN\REDO21.LOG',
'D:\ORACLE\ORADATA\WIN\REDO22.LOG'
) SIZE 1M,
GROUP 3 (
'D:\ORACLE\ORADATA\WIN\REDO31.LOG',
'D:\ORACLE\ORADATA\WIN\REDO32.LOG'
) SIZE 1M
DATAFILE
'D:\ORACLE\ORADATA\WIN\SYSTEM01.DBF',
'D:\ORACLE\ORADATA\WIN\RBS.DBF',
'D:\ORACLE\ORADATA\WIN\WIN_DAT.DBF',
'D:\ORACLE\ORADATA\WIN\TEMP01.DBF',
'D:\ORACLE\ORADATA\WIN\OEM_REPOSITORY.ORA'
CHARACTER SET ZHS16GBK
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# All logs need archiving and a log switch is needed.
ALTER SYSTEM ARCHIVE LOG ALL;
# Database can now be opened normally.
ALTER DATABASE OPEN;
# No tempfile entries found to add.
#


弄好后说一声
回复
相关推荐
发帖
Sybase
创建于2007-09-28

2576

社区成员

Sybase相关技术讨论区
申请成为版主
帖子事件
创建了帖子
2001-07-20 05:51
社区公告
暂无公告