ORACLE 数据库RMAN备份恢复

前端之家收集整理的这篇文章主要介绍了ORACLE 数据库RMAN备份恢复前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

机器A: @H_403_0@select instancename from v$instance; @H4030@select name from v$database; @H4030@select name from v$datafile; @H403_0@查询日志模式: @H_4030@archive log list; @H4030@shutdown immediate; @H4030@startup mount; @H4030@把日志改为归档模式: @H4030@alter database archivelog; @H4030@alter database open; @H4030@alter system archive log current; @H403_0@select name from v$archivedlog; @H403_0@打开控制文件跟踪: @H_4030@alter database backup controlfile to trace; @H403_0@查看跟踪文件位置: @H_403_0@show parameter user_dumpdest @H4030@cmd: @H403_0@set oraclesid=orcl @H4030@rman target sys/abc @H4030@host "md c:\back"; @H4030@run @H4030@{ @H4030@backup database; @H4030@format 'c:\back\%d%s_%Tfull.bak'; @H4030@} @H4030@select file#,name from v$datafile; @H403_0@传送以下文件到机器B: @H_4030@c:\back @H4030@d:\oracle\product\10.2.0\admin\orcl @H4030@CREATE CONTROLFILE SET DATABASE "ORCL" RESETLOGS ARCHIVELOG @H4030@MAXLOGFILES 16 @H4030@MAXLOGMEMBERS 3 @H4030@MAXDATAFILES 100 @H4030@MAXINSTANCES 8 @H4030@MAXLOGHISTORY 292 @H4030@LOGFILE @H4030@GROUP 1 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG' SIZE 50M,@H4030@GROUP 2 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG' SIZE 50M,@H4030@GROUP 3 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG' SIZE 50M @H4030@-- STANDBY LOGFILE @H4030@DATAFILE @H4030@'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF',@H4030@'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF',@H4030@'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF',@H4030@'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF',@H4030@'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\XM' @H4030@CHARACTER SET ZHS16GBK 机器B: @H4030@创建要恢复oracle的目录 @H4030@e:\oracle\product\10.2.0\oradata\orcl @H4030@e:\oracle\product\10.2.0\admin @H403_0@e:\oracle\product\10.2.0\falsh_recoveryarea @H403_0@把收到的文件夹orcl放到e:\oracle\product\10.2.0\admin @H_4030@拷贝 @H403_0@e:\oracle\product\10.2.0\admin\orcl\pfile中的参数文件到自己真实数据库db_1\database文件夹中,并改名为initorcl.ora @H_4030@打开initorcl.ora @H403_0@把里面的路径改为真实oracle数据库的位置 @H_4030@d:\替换为e:\ @H4030@cmd1: @H403_0@set oraclesid=orcl @H4030@oracle orcl @H403_0@等到提示ctrl+c @H_4030@cmd2: @H403_0@set oraclesid=orcl @H403_0@sqlplus / as sysdba @H_4030@startup nomount; @H4030@cmd3: @H403_0@set oraclesid=orcl @H4030@rman target sys/abc @H403_0@restore controlfile from 'C:\back\ORCL_2_20090414FULL.BAK'; @H4030@cmd2: @H4030@alter database mount; @H4030@cmd3: @H4030@run{ @H4030@set newname for datafile 1 to 'E:\oracle\product\10.2.0\oradata\orcl\SYSTEM01.DBF'; @H4030@set newname for datafile 2 to 'E:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF'; @H4030@set newname for datafile 3 to 'E:\oracle\product\10.2.0\oradata\orcl\SYSAUX01.DBF'; @H4030@set newname for datafile 4 to 'E:\oracle\product\10.2.0\oradata\orcl\USERS01.DBF'; @H4030@set newname for datafile 5 to 'E:\oracle\product\10.2.0\oradata\orcl\XM'; @H4030@restore database; @H4030@switch datafile all; @H4030@} @H4030@cmd2: @H4030@select name from v$database; @H4030@shutdown immediate; @H4030@startup mount; @H4030@alter database backup controlfile to trace; @H403_0@找到跟踪文件: @H_403_0@重做控制文件:把里面的路径改为正确路径: @H_4030@d:\改为 e:\ @H4030@shutdown immediate; @H4030@startup nomount; @H403_0@执行生成控制文件的语句;执行钱必须先删除.ctl的文件 @H_4030@alter database open resetlogs; @H4030@select name from v$database; @H403_0@select member from v$logfile;

猜你在找的Oracle相关文章