eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 使用Oracle10g新特性简化数据库镜像COPY | Blog首页 | 小技巧-如何让页面上所有的链接都在新窗口打开 »

使用COPY的镜像文件进行基于表空间/数据文件的恢复
modb.pro

假设数据文件或表空间丢失之前进行了镜像COPY备份,那么以下过程可以用于参考恢复:
1.查看备份情况

RMAN> list copy ; List of Datafile Copies Key File S Completion Time Ckp SCN Ckp Time Name ------- ---- - --------------- ---------- --------------- ---- 13 1 A 28-MAR-05 10557893 28-MAR-05 /data5/flash_recovery_area/EYGLE/datafile/o1_mf_system_14h9tbms_.dbf 16 2 A 28-MAR-05 10557921 28-MAR-05 /data5/flash_recovery_area/EYGLE/datafile/o1_mf_undotbs1_14h9wfq7_.dbf 17 3 A 28-MAR-05 10557950 28-MAR-05 /data5/flash_recovery_area/EYGLE/datafile/o1_mf_sysaux_14h9wxfn_.dbf 19 4 A 28-MAR-05 10557960 28-MAR-05 /data5/flash_recovery_area/EYGLE/datafile/o1_mf_users_14h9xjx2_.dbf 14 5 A 28-MAR-05 10557903 28-MAR-05 /data5/flash_recovery_area/EYGLE/datafile/o1_mf_eygle_14h9v4bd_.dbf 15 6 A 28-MAR-05 10557910 28-MAR-05 /data5/flash_recovery_area/EYGLE/datafile/o1_mf_test_14h9vn0z_.dbf 20 7 A 28-MAR-05 10557967 28-MAR-05 /data5/flash_recovery_area/EYGLE/datafile/o1_mf_itpub_14h9y0pg_.dbf 22 8 A 28-MAR-05 4544220 13-JUN-04 /data5/flash_recovery_area/EYGLE/datafile/o1_mf_trans_14h9ymw3_.dbf 12 9 A 28-MAR-05 10557876 28-MAR-05 /data5/flash_recovery_area/EYGLE/datafile/o1_mf_bigtbs_14h9rwv9_.dbf 21 10 A 28-MAR-05 10557974 28-MAR-05 /data5/flash_recovery_area/EYGLE/datafile/o1_mf_dfmbrc_14h9yjfg_.dbf 18 11 A 28-MAR-05 10557957 28-MAR-05 /data5/flash_recovery_area/EYGLE/datafile/o1_mf_t2k_14h9xf4y_.dbf List of Archived Log Copies Key Thrd Seq S Low Time Name ------- ---- ------- - --------- ---- 229 1 1753 A 28-MAR-05 /data5/flash_recovery_area/EYGLE/archivelog/2005_03_28/o1_mf_1_1753_14hcp43x_.arc RMAN>

2.恢复相关文件
可以通过SETNAME指定恢复文件到不同的位置.

$ rman target / Recovery Manager: Release 10.1.0.2.0 - 64bit Production Copyright (c) 1995, 2004, Oracle. All rights reserved. connected to target database (not started) RMAN> startup mount; Oracle instance started database mounted Total System Global Area 314572800 bytes Fixed Size 1301704 bytes Variable Size 261890872 bytes Database Buffers 50331648 bytes Redo Buffers 1048576 bytes RMAN> run { 2> SET NEWNAME FOR DATAFILE 8 TO '/opt/oracle/oradata/eygle/trans01.dbf'; 3> RESTORE DATAFILE 8; 4> SWITCH DATAFILE ALL; 5> RECOVER DATAFILE 8; }6> executing command: SET NEWNAME using target database controlfile instead of recovery catalog Starting restore at 28-MAR-05 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=160 devtype=DISK channel ORA_DISK_1: restoring datafile 00008 input datafilecopy recid=25 stamp=554139614 filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_trans_14h9ymw3_.dbf destination for restore of datafile 00008: /opt/oracle/oradata/eygle/trans01.dbf channel ORA_DISK_1: copied datafilecopy of datafile 00008 output filename=/opt/oracle/oradata/eygle/trans01.dbf recid=26 stamp=554142136 Finished restore at 28-MAR-05 datafile 8 switched to datafile copy input datafilecopy recid=27 stamp=554142139 filename=/opt/oracle/oradata/eygle/trans01.dbf Starting recover at 28-MAR-05 using channel ORA_DISK_1 starting media recovery media recovery complete Finished recover at 28-MAR-05 RMAN> alter database open; database opened RMAN>

3.alert文件的记录
我们可以看一下恢复过程中,alert文件中记录的信息:

Mon Mar 28 16:21:09 2005 Database mounted in Exclusive Mode. Completed: alter database mount Mon Mar 28 16:22:16 2005 Copy of datafile copy /data5/flash_recovery_area/EYGLE/datafile/o1_mf_trans_14h9ymw3_.dbf complete to datafile copy /opt/oracle/oradata/eygle/test01.dbf checkpoint is 4544220 Mon Mar 28 16:22:20 2005 Switch of datafile 8 complete to datafile copy checkpoint is 4544220 Mon Mar 28 16:22:22 2005 alter database recover datafile list clear Completed: alter database recover datafile list clear Mon Mar 28 16:22:22 2005 alter database recover if needed datafile 8 Media Recovery Datafile: 8 Media Recovery Start ORA-264 signalled during: alter database recover if needed datafile 8 ... Mon Mar 28 16:22:35 2005 alter database open Mon Mar 28 16:22:35 2005 Block change tracking file is current. Mon Mar 28 16:22:35 2005 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=15, OS id=29888 ARC0: Archival started Mon Mar 28 16:22:35 2005 LGWR: STARTING ARCH PROCESSES COMPLETE ARC1 started with pid=16, OS id=29890 ARC1: Archival started ARC1: Becoming the 'no FAL' ARCH ARC1: Becoming the 'no SRL' ARCH Mon Mar 28 16:22:35 2005 ARC0: Becoming the heartbeat ARCH Mon Mar 28 16:22:35 2005 LGWR: Primary database is in CLUSTER CONSISTENT mode Maximum redo generation record size = 132096 bytes Maximum redo generation change vector size = 116476 bytes Private_strands 3 at log switch Thread 1 opened at log sequence 1755 Current log# 3 seq# 1755 mem# 0: /opt/oracle/oradata/eygle/redo03.log Successful open of redo thread 1 Mon Mar 28 16:22:36 2005 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Mon Mar 28 16:22:37 2005 Starting background process CTWR CTWR started with pid=17, OS id=29892 Block change tracking service is active. Mon Mar 28 16:22:37 2005 SMON: enabling cache recovery Mon Mar 28 16:22:39 2005 Successfully onlined Undo Tablespace 1. Mon Mar 28 16:22:39 2005 SMON: enabling tx recovery Mon Mar 28 16:22:39 2005 Database Characterset is ZHS16GBK Mon Mar 28 16:22:39 2005 Published database character set on system events channel Mon Mar 28 16:22:42 2005 Starting background process QMNC QMNC started with pid=18, OS id=29896 Mon Mar 28 16:22:44 2005 replication_dependency_tracking turned off (no async multimaster replication found) Mon Mar 28 16:22:45 2005 Starting background process MMON Starting background process MMNL MMON started with pid=19, OS id=29911 MMNL started with pid=20, OS id=29913 Mon Mar 28 16:22:46 2005 Completed: alter database open Mon Mar 28 16:22:49 2005 db_recovery_file_dest_size of 10240 MB is 25.07% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup.

恢复过程,仅供参考。

历史上的今天...
    >> 2013-03-28文章:
    >> 2012-03-28文章:
           JRE问题之未解决 - 备案
    >> 2011-03-28文章:
    >> 2009-03-28文章:
    >> 2008-03-28文章:
    >> 2006-03-28文章:
           Oracle的前尘旧版

By eygle on 2005-03-28 16:28 | Comments (0) | Backup&Recovery | 222 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com