---------------------------------------------------------------------------------------------------------------------------

源端创建pfile

#create pfile='/home/oracle/pfile_20230601.ora' from spfile;

---------------------------------------------------------------------------------------------------------------------------

目标端创建对应的目录

mkdir -p /u01/app/oracle/admin/AMSDB/adump

mkdir -p /u01/app/oracle/oradata/AMSDB/

mkdir -p /u01/app/oracle/fast_recovery_area

---------------------------------------------------------------------------------------------------------------------------

目标端修改参数启动到nomount状态

export ORACLE_SID=AMSDB1

create spfile from pfile='/home/oracle/pfile_20230601.ora';

startup nomount

---------------------------------------------------------------------------------------------------------------------------

目标端编辑avamar参数文件

cat my-avtar-flages.txt

#NAME?

--logfile=/usr/local/avamar/etc/avtar.log

--vardir=/usr/local/avamar/var/clientlogs

#NAME?

--path=/zhfa_cim/zhrptdb

#NAME?

avamar平台上可以找到对应的备份集和数据库id--在备份集的控制文件后缀中

rman target /

set dbid=99242286;

set controlfile autobackup format for device type sbt to 'CONTROLFILE.AMSDB.%F';

run{

allocate channel c1 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so" FORMAT '%d_%U'trace 2;

send '"--prefix=11g/AMSDB/" "--flagfile=/home/oracle/my-avtar-flages.txt" "--sysdir=/usr/local/avamar/etc" "--bindir=/usr/local/avamar/bin" "--vardir=/usr/local/avamar/var/clientlogs" "--logfile=/usr/local/avamar/var/clientlogs/restore.log"';

restore controlfile from autobackup MAXSEQ=0 until time ="TO_DATE('20230531','YYYYMMDD')";

release channel c1;

}

alter database mount;

---------------------------------------------------------------------------------------------------------------------------

set pages 2000 line 2000

select 'set newname for datafile ' || a.FILE# || ' to "' || a.NAME || '";'

from v$datafile a

union all

select 'set newname for tempfile ' || a.FILE# || ' to "' || a.NAME || '";'

from v$tempfile a

union all

SELECT 'SQL "ALTER DATABASE RENAME FILE ''''' || a.MEMBER || ''''' to ''''' ||

a.MEMBER || ''''' ";'

FROM v$logfile a;

---------------------------------------------------------------------------------------------------------------------------

run{

allocate channel c1 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so" FORMAT '%d_%U'trace 2;

send '"--prefix=11g/AMSDB/" "--flagfile=/home/oracle/my-avtar-flages.txt" "--sysdir=/usr/local/avamar/etc" "--bindir=/usr/local/avamar/bin" "--vardir=/usr/local/avamar/var/clientlogs" "--logfile=/usr/local/avamar/var/clientlogs/restore.log"';

set newname for datafile 1 to "/u01/app/oracle/oradata/AMSDB/system.256.dbf";

set newname for datafile 2 to "/u01/app/oracle/oradata/AMSDB/sysaux.257.dbf";

set newname for datafile 3 to "/u01/app/oracle/oradata/AMSDB/undotbs1.258.dbf";

set newname for datafile 4 to "/u01/app/oracle/oradata/AMSDB/users.259.dbf";

set newname for datafile 5 to "/u01/app/oracle/oradata/AMSDB/undotbs2.267.dbf";

set newname for datafile 6 to "/u01/app/oracle/oradata/AMSDB/ts_alm_work.276.dbf";

set newname for datafile 7 to "/u01/app/oracle/oradata/AMSDB/ts_alm_work_info.277.dbf";

set newname for datafile 8 to "/u01/app/oracle/oradata/AMSDB/ts_alm_ignored.278.dbf";

set newname for datafile 9 to "/u01/app/oracle/oradata/AMSDB/ts_alm_invalid.279.dbf";

set newname for datafile 10 to "/u01/app/oracle/oradata/AMSDB/ts_alm_setting.280.dbf";

set newname for datafile 11 to "/u01/app/oracle/oradata/AMSDB/ts_alm_log.281.dbf";

set newname for tempfile 1 to "/u01/app/oracle/oradata/AMSDB/temp.266.dbf";

SQL "ALTER DATABASE RENAME FILE ''+AMSDATA/amsdb/onlinelog/group_2.264.1052959409'' to ''/u01/app/oracle/oradata/AMSDB/group_2.264.log'' ";

SQL "ALTER DATABASE RENAME FILE ''+AMSDATA/amsdb/onlinelog/group_2.265.1052959409'' to ''/u01/app/oracle/oradata/AMSDB/group_2.265.log'' ";

SQL "ALTER DATABASE RENAME FILE ''+AMSDATA/amsdb/onlinelog/group_1.262.1052959409'' to ''/u01/app/oracle/oradata/AMSDB/group_1.262.log'' ";

SQL "ALTER DATABASE RENAME FILE ''+AMSDATA/amsdb/onlinelog/group_1.263.1052959409'' to ''/u01/app/oracle/oradata/AMSDB/group_1.263.log'' ";

SQL "ALTER DATABASE RENAME FILE ''+AMSDATA/amsdb/onlinelog/group_3.268.1052959459'' to ''/u01/app/oracle/oradata/AMSDB/group_3.268.log'' ";

SQL "ALTER DATABASE RENAME FILE ''+AMSDATA/amsdb/onlinelog/group_3.269.1052959459'' to ''/u01/app/oracle/oradata/AMSDB/group_3.269.log'' ";

SQL "ALTER DATABASE RENAME FILE ''+AMSDATA/amsdb/onlinelog/group_4.270.1052959461'' to ''/u01/app/oracle/oradata/AMSDB/group_4.270.log'' ";

SQL "ALTER DATABASE RENAME FILE ''+AMSDATA/amsdb/onlinelog/group_4.271.1052959461'' to ''/u01/app/oracle/oradata/AMSDB/group_4.271.log'' ";

RESTORE DATABASE;

SWITCH DATAFILE ALL;

SWITCH TEMPFILE ALL;

recover database;

release channel c1;

}

根据报错提示，找对应的归档日志文件。

archived log file name=/u01/app/oracle/product/11.2/dbhome_1/dbs/arch2_3150_1052959408.dbf thread=2 sequence=3150

unable to find archived log

archived log thread=1 sequence=3450

released channel: c1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 06/01/2023 10:31:57

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 3450 and starting SCN of 72292228095

catalog start with '/home/oracle/rec_20230601';

#NAME?

再次recover

unable to find archived log

archived log thread=2 sequence=3153

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 06/01/2023 10:58:58

RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 3153 and starting SCN of 72292403969

根据日志提示，系统再次被推进，

接下来恢复redo，一个一个尝试即可，或者计算

（dd if=/home/oracle/rec_20230601/group_3.268.1052959459 skip=1 bs=512 count=1|od -x）第6位16进制转换为10进制。

recover database using BACKUP CONTROLFILE until cancel;

提示：

Log applied.

Media recovery complete.

完全一致性恢复成功

源端创建测试表，数据还在redo中。非必要不操作，不动生产。

create table rec_20230601(id int,name varchar2(50));

insert into rec_20230601 (id,name) values (2,'2023-6-1');

commit;

exit

su - grid

export ORACLE_SID=+ASM1

asmcmd

cp group_1.262.1052959409 /tmp/rec_20230601/

cp group_1.263.1052959409 /tmp/rec_20230601/

cp group_2.264.1052959409 /tmp/rec_20230601/

cp group_2.265.1052959409 /tmp/rec_20230601/

cp group_3.268.1052959459 /tmp/rec_20230601/

cp group_3.269.1052959459 /tmp/rec_20230601/

cp group_4.270.1052959461 /tmp/rec_20230601/

cp group_4.271.1052959461 /tmp/rec_20230601/

ITPub博客

Avamar 备份恢复 Oracle

最新文章