今天下午做的简单的rac恢复到异地单机节点上面的实验

下面整个过程的快速记录，有时间在整理一下，但是以下步骤肯定是正确的

0/copy backup piece to new localtion

1/ restore spfile from backup
run
{
allocate channle t1 type to disk;
restore spfile from '/path';
release channle t1;
}
2/modify spfile to consistent to signal instance
*.audit_file_dest='/opt/app/oracle/admin/test/adump'
*.audit_sys_operations=TRUE
*.background_dump_dest='/opt/app/oracle/admin/test/bdump'
*.compatible='10.2.0.3.0'
*.control_file_record_keep_time=30
*.control_files='/oradata/test/control01.ctl','/oradata/test/control02.ctl','/oradata/test/control03.ctl'
*.core_dump_dest='/opt/app/oracle/admin/test/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=32
*.db_name='test'
*.db_recovery_file_dest_size=107374182400
*.job_queue_processes=10
*.log_archive_dest_1='location=/oradata/test/arch'
*.log_archive_format='log_%t_%s_%r.arc'
*.log_archive_start=TRUE
*.open_cursors=300
*.pga_aggregate_target=97152000
*.processes=500
*.remote_login_passwordfile='exclusive'
*.resource_limit=TRUE
*.service_names='test'
*.sessions=555
*.sga_target=718592000
*.undo_management='AUTO'
*.undo_retention=1800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/app/oracle/admin/test/udump'

3/create spfile from pfile after modify
create spfile from pfile ='/path';

4/mount database
alter database mount;
5/restore control file
run
{
allocate channle ch1 type to disk;
resoter controlfile from 'path';
release channle ch1;
}
6/change redolog name and path
sqlplus /nolog
conn /as sysdba;

alter database rename file '/oradata/test/test/redo01a.log' to /oradata/test/
alter database rename file '/oradata/test/test/redo02a.log' to /oradata/test/
alter database rename file '/oradata/test/test/redo03a.log' to /oradata/test/
alter database rename file '/oradata/test/test/redo04a.log' to /oradata/test/
alter database rename file '/oradata/test/test/redo05a.log' to /oradata/test/
alter database rename file '/oradata/test/test/redo06a.log' to /oradata/test/
alter database rename file '/oradata/test/test/redo01b.log' to /oradata/test/
alter database rename file '/oradata/test/test/redo02b.log' to /oradata/test/
alter database rename file '/oradata/test/test/redo03b.log' to /oradata/test/
alter database rename file '/oradata/test/test/redo04b.log' to /oradata/test/
alter database rename file '/oradata/test/test/redo05b.log' to /oradata/test/
alter database rename file '/oradata/test/test/redo06b.log' to /oradata/test/
alter database rename file '/oradata/test/test/standby14.log' to /oradata/test/

7/regists backup ppices
catalog start with '/oradata/rmanbak';

crosscheck backup;

report schema;

8/set new name to accoding to new place;
RMAN> run
{
allocate channel t1 type disk;
set newname for datafile 1 to '/oradata/test/system01.dbf';
set newname for datafile 2 to '/oradata/test/undotbs01.dbf';
set newname for datafile 3 to '/oradata/test/sysaux01.dbf';
set newname for datafile 4 to '/oradata/test/undotbs02.dbf';
set newname for datafile 5 to '/oradata/test/users01.dbf';
set newname for datafile 6 to '/oradata/test/sale_ix01.dbf';
set newname for datafile 7 to '/oradata/test/sale01.dbf';
set newname for datafile 8 to '/oradata/test/cpc01.dbf';
set newname for datafile 9 to '/oradata/test/cpc_ix01.dbf';
restore datafile 1,2,3,5,6,7,8,9;
switch datafile all;
release channel t1;
}

继续上面的

通过 restore database preview

发现 确实下面的归档日志

RMAN> restore database preview;

Starting restore at 08-DEC-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=543 devtype=DISK

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4857 Full 8.11G DISK 00:03:09 08-DEC-09
BP Key: 4858 Status: AVAILABLE Compressed: NO Tag: TAG20091208T002103
Piece Name: /oradata/rmanbak/db_LD_20091208_p1l0bl7f_1_1
List of Datafiles in backup set 4857
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1480133519 08-DEC-09 /oradata/test/system01.dbf
2 Full 1480133519 08-DEC-09 /oradata/test/undotbs01.dbf
3 Full 1480133519 08-DEC-09 /oradata/test/sysaux01.dbf
4 Full 1480133519 08-DEC-09 /oradata/test/undotbs02.dbf
5 Full 1480133519 08-DEC-09 /oradata/test/users01.dbf
6 Full 1480133519 08-DEC-09 /oradata/test/sale_ix01.dbf
7 Full 1480133519 08-DEC-09 /oradata/test/sale01.dbf
8 Full 1480133519 08-DEC-09 /oradata/test/cpc01.dbf
9 Full 1480133519 08-DEC-09 /oradata/test/cpc_ix01.dbf
using channel ORA_DISK_1

List of Backup Sets
===================

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4866 1.60G DISK 00:00:00 08-DEC-09
BP Key: 4866 Status: AVAILABLE Compressed: NO Tag: TAG20091208T002438
Piece Name: /oradata/rmanbak/arc_LD_20091208_pcl0bm9b_1_1

List of Archived Logs in backup set 4866
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 16795 1480124875 08-DEC-09 1480136073 08-DEC-09
1 16796 1480136073 08-DEC-09 1480136120 08-DEC-09

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4868 863.88M DISK 00:00:00 08-DEC-09
BP Key: 4868 Status: AVAILABLE Compressed: NO Tag: TAG20091208T002438
Piece Name: /oradata/rmanbak/arc_LD_20091208_pel0bmbk_1_1

List of Archived Logs in backup set 4868
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
2 8546 1480056544 07-DEC-09 1480136091 08-DEC-09
2 8547 1480136091 08-DEC-09 1480136112 08-DEC-09
Media recovery start SCN is 1480133519
Recovery must be done beyond SCN 1480133519 to clear data files fuzziness
Finished restore at 08-DEC-09；

拷贝上面的两个日志过来

通过以下语句在test环境恢复archivelog

RMAN> run
{
set archivelog destination to '/oradata/test';
restore archivelog from logseq=8546 until logseq=8547 thread=2;
restore archivelog from logseq=16795 until logseq=16796 thread=1;
}

用下面的这个命令可以吧已经传到standby的archivelog备份出来，然后传到恢复环境中，应用缺失的archivelog

run
{
allocate channel ch1 device type disk;
backup archivelog from time 'sysdate-2' format '/opt/oracle/stage/archive/arc_%d_%T_%U';
release channel ch1;
}

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8432937/viewspace-1029481/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8432937/viewspace-1029481/