谁能介绍一下备份和恢复整库的步骤
解决方案 »
- sql语句优化讨论,主要针对oracle、mysql
- 请问,Orcle和MSSQL的restore有什么不同?
- Oracle Job
- 求助:需要IMP数据
- 如何优化SQL语句速度?
- Oracle 11g 数据库已经发布下载
- 我想用 utl_file 来写文件 如果我想写入 某个盘下,并创建目录怎么办 在线等
- 在用schema manager建表时,怎么样设定主键为自动升序?
- oracle managermentserver服务能启动,但登录EMC时输完迷码一确定该服务又关闭了。为什么?
- 如何把Oracle中Select出来的数据保存成mdb或文本文件(挥泪大送分)
- 连接MS SQL 2000数据库,oracle透明网关技术讨论
- 征询standby热备数据库的创建步骤?
Time /t >> f:\backup\backup.log
ECHO Backup Start ----------------------------------------------->> f:\backup\backup.log
REM ****** Stop Oracle ******
ECHO Stop OracleAgent Service......>> f:\backup\backup.log
net.exe stop OracleAgent /yes ECHO Shutdown Oracle......>> f:\backup\backup.log
oradim73.exe -shutdown -sid orcl -usrpwd oracle -shuttype srvc,inst -shutmode i
IF ERRORLEVEL 1 GOTO ABORT2 REM ****** Copy Oracle Files ******
ECHO Copy Oracle Initial File......>> f:\backup\backup.log
xcopy.exe /q /k /r /h f:\init\initorcl.ora x:\init\
IF ERRORLEVEL 1 GOTO ABORT3 ECHO Copy Oracle Control Files......>> f:\backup\backup.log
xcopy.exe /q /k /r /h f:\cntl\* x:\cntl\
IF ERRORLEVEL 1 GOTO ABORT4 ECHO Copy Oracle Redo Files......>> f:\backup\backup.log
xcopy.exe /q /k /r /h f:\redo\* x:\redo\
IF ERRORLEVEL 1 GOTO ABORT5 ECHO Copy MS0_DATA01.ORA ......>> f:\backup\backup.log
xcopy.exe /q /k /r /h f:\database\ms0_data01.ora x:\database\
IF ERRORLEVEL 1 GOTO ABORT6 ECHO Copy MS0_INDEX01.ORA ......>> f:\backup\backup.log
xcopy.exe /q /k /r /h f:\database\ms0_index01.ora x:\database\
IF ERRORLEVEL 1 GOTO ABORT7 ECHO Copy SYSTEM.ORA ......>> f:\backup\backup.log
xcopy.exe /q /k /r /h f:\database\system.ora x:\database\
IF ERRORLEVEL 1 GOTO ABORT8 ECHO Copy RBS.ORA ......>> f:\backup\backup.log
xcopy.exe /q /k /r /h f:\database\rbs.ora x:\database\
IF ERRORLEVEL 1 GOTO ABORT9 ECHO Copy TMP1.ORA ......>> f:\backup\backup.log
xcopy.exe /q /k /r /h f:\database\temp1.ora x:\database\
IF ERRORLEVEL 1 GOTO ABORT10 ECHO Copy PWDORCL.ORA ......>> f:\backup\backup.log
xcopy.exe /q /k /r /h f:\orant\database\pwdorcl.ora x:\database\
IF ERRORLEVEL 1 GOTO ABORT11 REM ****** Delete Archive Files ******
ECHO Delete Oracle Archive Files......>> f:\backup\backup.log
del /q /f f:\archive\
GOTO OK :ABORT1
ECHO Stop OracleAgent Service --- Error(%ERRORLEVEL%), Backup Aborted. >> f:\backup\backup.log
GOTO EXIT :ABORT2
ECHO Shutdown Oracle --- Error(%ERRORLEVEL%), Backup Aborted. >> f:\backup\backup.log
GOTO REBOOT :ABORT3
ECHO Copy Oracle Initial File --- Error(%ERRORLEVEL%), Backup Aborted. >> f:\backup\backup.log
GOTO REBOOT :ABORT4
ECHO Copy Oracle Control Files --- Error(%ERRORLEVEL%), Backup Aborted. >> f:\backup\backup.log
GOTO REBOOT :ABORT5
ECHO Copy Oracle Redo Files --- Error(%ERRORLEVEL%), Backup Aborted. >> f:\backup\backup.log
GOTO REBOOT :ABORT6
ECHO Copy MS0_DATA01.ORA --- Error(%ERRORLEVEL%), Backup Aborted. >> f:\backup\backup.log
GOTO REBOOT :ABORT7
ECHO Copy MS0_INDEX01.ORA --- Error(%ERRORLEVEL%), Backup Aborted. >> f:\backup\backup.log
GOTO REBOOT :ABORT8
ECHO Copy SYSTEM.ORA --- Error(%ERRORLEVEL%), Backup Aborted. >> f:\backup\backup.log
GOTO REBOOT :ABORT9
ECHO Copy RBS.ORA --- Error(%ERRORLEVEL%), Backup Aborted. >> f:\backup\backup.log
GOTO REBOOT :ABORT10
ECHO Copy TMP1.ORA --- Error(%ERRORLEVEL%), Backup Aborted. >> f:\backup\backup.log
GOTO REBOOT :ABORT11
ECHO Copy PWDORCL.ORA --- Error(%ERRORLEVEL%), Backup Aborted. >> f:\backup\backup.log
GOTO REBOOT :OK
ECHO Backup OK ! >> f:\backup\backup.log :REBOOT
ECHO Reboot Oracle ...... >> f:\backup\backup.log
oradim73.exe -startup -sid orcl -usrpwd oracle -starttype srvc,inst -pfile f:\init\initorcl.ora :EXIT
ECHO Backup End -------------------------------------------------->> f:\backup\backup.log
Time /t >> f:\backup\backup.log
ECHO # >> f:\backup\backup.log
ECHO # >> f:\backup\backup.log
应该没有问题,我曾经在WIN2000下试过。
先安装ORACLE 815,建表空间TEST
CREATE TABLESPACE TEST DATAFILE 'C:\ORACLE\DATAFILE\ORACLE\TEST.DBF' SIZE 500M;
CREATE USER TEST IDENTIFIED BY TEST DEFAULT TABLESPACE TEST TEMPORARY TABLESPACE TEMP;
GRANT CONNECT,RESOURCE TO TEST;
CONNECT TEST/TEST;
CREATE TABLE A( A VARCHAR2(1),B NUMBER);
INSERT INTO A VALUES('A',1);
INSERT INTO A SELECT * FROM A;
上一命令执行多次。
在CMD下输入:
SVRMGRL
CONNECT INTERNAL/ORACLE;
SHUTDOWN;
EXIT;
进入控制面板;关闭所有ORACLE相关的服务。
备份CONTROL FILE,DATAFILE,REDO。LOG FILE,INIT。ORA和PASSWORD FILE至其他位置。
然后删除整个ORACLE,重新安装ORACLE(必须和原来的安装目录一致并且SID也必须一致),安装完毕后,关闭相关的ORACLE服务,将上面的备份文件COPY回原位置,重起服务,OK!
怎么解决???(在装载完数据库后打开数据库之前出现)