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

[uk]

[guo]

我可以给你一个控制文件重建的脚本,但没有日志文件的重建这没试过

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.
#


弄好后说一声

[uk]

上班后我才能试，到时候再跟你联系，谢谢！

[uk]

我试了一下，服务是连上了（太好了 ），可为什么我的数据库里面的用户表都没有了呢？

[uk]

guo(正在消化Oracle)　：　你在csdn吗？