国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 數據庫 > Oracle > 正文

ORACLE 數據庫RMAN備份恢復

2024-08-29 13:56:41
字體:
來源:轉載
供稿:網友
機器A:
select instance_name from v$instance;
select name from v$database;
select name from v$datafile;
查詢日志模式:
archive log list;
shutdown immediate;
startup mount;
把日志改為歸檔模式:
alter database archivelog;
alter database open;
alter system archive log current;
select name from v$archived_log;
打開控制文件跟蹤:
alter database backup controlfile to trace;
查看跟蹤文件位置:
show parameter user_dump_dest
cmd:
set oracle_sid=orcl
rman target sys/abc
host "md c:/back";
run
{
backup database;
format 'c:/back/%d_%s_%T_full.bak';
}
select file#,name from v$datafile;
傳送以下文件到機器B:
c:/back
d:/oracle/product/10.2.0/admin/orcl
CREATE CONTROLFILE SET DATABASE "ORCL" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG' SIZE 50M,
GROUP 2 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG' SIZE 50M,
GROUP 3 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO03.LOG' SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/SYSTEM01.DBF',
'E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/UNDOTBS01.DBF',
'E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/SYSAUX01.DBF',
'E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/USERS01.DBF',
'E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/XM'
CHARACTER SET ZHS16GBK

機器B:
創建要恢復oracle的目錄
e:/oracle/product/10.2.0/oradata/orcl
e:/oracle/product/10.2.0/admin
e:/oracle/product/10.2.0/falsh_recovery_area
把收到的文件夾orcl放到e:/oracle/product/10.2.0/admin
拷貝
e:/oracle/product/10.2.0/admin/orcl/pfile中的參數文件到自己真實數據庫db_1/database文件夾中,并改名為initorcl.ora
打開initorcl.ora
把里面的路徑改為真實oracle數據庫的位置
d:/替換為e:/
cmd1:
set oracle_sid=orcl
oracle orcl
等到提示ctrl+c
cmd2:
set oracle_sid=orcl
sqlplus / as sysdba
startup nomount;
cmd3:
set oracle_sid=orcl
rman target sys/abc
restore controlfile from 'C:/back/ORCL_2_20090414_FULL.BAK';
cmd2:
alter database mount;
cmd3:
run{
set newname for datafile 1 to 'E:/oracle/product/10.2.0/oradata/orcl/SYSTEM01.DBF';
set newname for datafile 2 to 'E:/oracle/product/10.2.0/oradata/orcl/UNDOTBS01.DBF';
set newname for datafile 3 to 'E:/oracle/product/10.2.0/oradata/orcl/SYSAUX01.DBF';
set newname for datafile 4 to 'E:/oracle/product/10.2.0/oradata/orcl/USERS01.DBF';
set newname for datafile 5 to 'E:/oracle/product/10.2.0/oradata/orcl/XM';
restore database;
switch datafile all;
}
cmd2:
select name from v$database;
shutdown immediate;
startup mount;
alter database backup controlfile to trace;
找到跟蹤文件:
重做控制文件:把里面的路徑改為正確路徑:
d:/改為 e:/
shutdown immediate;
startup nomount;
執行生成控制文件的語句;執行錢必須先刪除.ctl的文件
alter database open resetlogs;
select name from v$database;
select member from v$logfile;
發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 香港| 庆阳市| 麦盖提县| 清新县| 营口市| 肇东市| 高台县| 红安县| 潮安县| 四平市| 龙江县| 肥东县| 托克托县| 柳州市| 霸州市| 沙洋县| 资溪县| 永平县| 宜州市| 盐池县| 保德县| 磴口县| 渝北区| 墨玉县| 泾源县| 淮北市| 黎城县| 遵义县| 西平县| 西城区| 玉林市| 商都县| 东丰县| 扎兰屯市| 左贡县| 金塔县| 恩施市| 塔河县| 响水县| 宕昌县| 奈曼旗|