ITPub博客

首页 > 数据库 > Oracle > 11g RAC库恢复过程小记

11g RAC库恢复过程小记

原创 Oracle 作者:jichengjie 时间:2014-02-12 17:05:54 0 删除 编辑

今天作个测试,先把两个节点的库停掉,开始恢复
[oracle@rac2 backup]$ ll
total 3106320
drwxr-xr-x 2 oracle oinstall       4096 Feb 12 06:06 file-bak
-rw-r----- 1 oracle asmadmin  266158080 Feb 12 06:07 rac_20140212_1_1.dbf
-rw-r----- 1 oracle asmadmin  816562176 Feb 12 07:29 rac_20140212_2_1.dbf
-rw-r----- 1 oracle asmadmin 2019778560 Feb 12 07:30 rac_20140212_3_1.dbf
-rw-r----- 1 oracle asmadmin   18612224 Feb 12 07:30 rac_20140212_4_1.dbf
-rw-r----- 1 oracle asmadmin   26966528 Feb 12 07:31 rac_20140212_5_1.arc
-rw-r----- 1 oracle asmadmin   10949632 Feb 12 07:31 rac_20140212_6_1.arc
-rw-r----- 1 oracle asmadmin   18579456 Feb 12 07:31 rac_20140212_7_1.ctl
-rw-r----- 1 oracle asmadmin      98304 Feb 12 07:31 rac_20140212_8_1.spf
drwxr-xr-x 2 oracle oinstall       4096 Feb 12 06:07 scripts
-rw-r--r-- 1 oracle oinstall       1414 Feb 12 07:29 tmp.dat
[oracle@rac2 backup]$ rman

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Feb 12 08:38:55 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect / as sysdba

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "/"

RMAN> connect target /

connected to target database (not started)

RMAN> startup nomount;

Oracle instance started

Total System Global Area     943669248 bytes

Fixed Size                     2234000 bytes
Variable Size                566233456 bytes
Database Buffers             369098752 bytes
Redo Buffers                   6103040 bytes

RMAN> restore controlfile from '/s01/oracle/backup/rac_20140212_7_1.ctl';

Starting restore at 12-FEB-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 instance=rac2 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output file name=+DATABASEDG/rac/controlfile/current.260.836789301
output file name=+BACKUPDG/rac/controlfile/current.256.836789303
Finished restore at 12-FEB-14

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> list backup of archivelog all;


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


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4       25.72M     DISK        00:00:01     12-FEB-14     
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20140212T073123
        Piece Name: /s01/oracle/backup/rac_20140212_5_1.arc

  List of Archived Logs in backup set 4
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    23      3403555    12-FEB-14 3476656    12-FEB-14
  1    24      3476656    12-FEB-14 3480849    12-FEB-14
  1    25      3480922    12-FEB-14 3482720    12-FEB-14
  1    26      3482720    12-FEB-14 3482741    12-FEB-14
  1    27      3482741    12-FEB-14 3482792    12-FEB-14
  1    28      3482792    12-FEB-14 3482815    12-FEB-14
  1    29      3482815    12-FEB-14 3482827    12-FEB-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       10.44M     DISK        00:00:01     12-FEB-14     
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20140212T073133
        Piece Name: /s01/oracle/backup/rac_20140212_6_1.arc

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  2    22      3378022    12-FEB-14 3403518    12-FEB-14
  2    23      3404107    12-FEB-14 3476655    12-FEB-14
  2    24      3476655    12-FEB-14 3482726    12-FEB-14
  2    25      3482726    12-FEB-14 3482737    12-FEB-14
  2    26      3482737    12-FEB-14 3482801    12-FEB-14
  2    27      3482801    12-FEB-14 3482812    12-FEB-14
  2    28      3482812    12-FEB-14 3482832    12-FEB-14
  2    29      3482832    12-FEB-14 3482851    12-FEB-14

RMAN>
RMAN> run{
2>  set until sequence 30 thread 1;
3>  restore database;
4>  recover database;
5>  }

executing command: SET until clause

Starting restore at 12-FEB-14
Starting implicit crosscheck backup at 12-FEB-14
allocated channel: ORA_DISK_1
Crosschecked 5 objects
Finished implicit crosscheck backup at 12-FEB-14

Starting implicit crosscheck copy at 12-FEB-14
using channel ORA_DISK_1
Finished implicit crosscheck copy at 12-FEB-14

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: +backupdg/RAC/ARCHIVELOG/2014_02_12/thread_2_seq_30.264.839320639

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00013 to +DATABASEDG/rac/datafile/eport_tab_l.277.839233953
channel ORA_DISK_1: reading from backup piece /s01/oracle/backup/rac_20140212_2_1.dbf
channel ORA_DISK_1: piece handle=/s01/oracle/backup/rac_20140212_2_1.dbf tag=TAG20140212T072918
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:16
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATABASEDG/rac/datafile/system.256.836789011
channel ORA_DISK_1: restoring datafile 00002 to +DATABASEDG/rac/datafile/sysaux.257.836789015
channel ORA_DISK_1: restoring datafile 00003 to +DATABASEDG/rac/datafile/undotbs1.258.836789019
channel ORA_DISK_1: restoring datafile 00004 to +DATABASEDG/rac/datafile/users.259.836789019
channel ORA_DISK_1: restoring datafile 00005 to +DATABASEDG/rac/datafile/undotbs2.266.836810891
channel ORA_DISK_1: restoring datafile 00006 to +DATABASEDG/rac/datafile/eport_fee_idx.274.839233923
channel ORA_DISK_1: restoring datafile 00007 to +DATABASEDG/rac/datafile/jablog.271.837406687
channel ORA_DISK_1: restoring datafile 00008 to +DATABASEDG/rac/datafile/jablog_blob.272.837406747
channel ORA_DISK_1: restoring datafile 00009 to +DATABASEDG/rac/datafile/dpe.273.837406883
channel ORA_DISK_1: restoring datafile 00010 to +DATABASEDG/rac/datafile/eport_fee_tab.270.839233931
channel ORA_DISK_1: restoring datafile 00011 to +DATABASEDG/rac/datafile/eport_idx_l.275.839233937
channel ORA_DISK_1: restoring datafile 00012 to +DATABASEDG/rac/datafile/eport_idx_s.276.839233945
channel ORA_DISK_1: restoring datafile 00014 to +DATABASEDG/rac/datafile/eport_tab_s.278.839233959
channel ORA_DISK_1: restoring datafile 00015 to +DATABASEDG/rac/datafile/eport_tab_xl.279.839233967
channel ORA_DISK_1: reading from backup piece /s01/oracle/backup/rac_20140212_3_1.dbf
channel ORA_DISK_1: piece handle=/s01/oracle/backup/rac_20140212_3_1.dbf tag=TAG20140212T072918
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:27
Finished restore at 12-FEB-14

Starting recover at 12-FEB-14
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 25 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_25.287.839316661
archived log for thread 1 with sequence 26 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_26.281.839316667
archived log for thread 1 with sequence 27 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_27.280.839316673
archived log for thread 1 with sequence 28 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_28.275.839316677
archived log for thread 1 with sequence 29 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_29.273.839316681
archived log for thread 2 with sequence 24 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_24.285.839316661
archived log for thread 2 with sequence 25 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_25.283.839316663
archived log for thread 2 with sequence 26 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_26.277.839316675
archived log for thread 2 with sequence 27 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_27.276.839316675
archived log for thread 2 with sequence 28 is already on disk as file +BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_28.271.839316683
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_24.285.839316661 thread=2 sequence=24
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_25.287.839316661 thread=1 sequence=25
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_26.281.839316667 thread=1 sequence=26
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_25.283.839316663 thread=2 sequence=25
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_26.277.839316675 thread=2 sequence=26
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_27.280.839316673 thread=1 sequence=27
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_28.275.839316677 thread=1 sequence=28
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_27.276.839316675 thread=2 sequence=27
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_2_seq_28.271.839316683 thread=2 sequence=28
archived log file name=+BACKUPDG/rac/archivelog/2014_02_12/thread_1_seq_29.273.839316681 thread=1 sequence=29
media recovery complete, elapsed time: 00:00:05
Finished recover at 12-FEB-14

RMAN>

[oracle@rac2 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 13 01:57:36 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> connect / as sysdba
Connected.

SQL>alter database open resetlogs;

SQL> select tablespace_name from dba_tablespaces where contents='UNDO';

TABLESPACE_NAME
------------------------------
UNDOTBS1
UNDOTBS2

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
+DATABASEDG/rac/tempfile/temp.264.836789383

SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME
------------------------------
TEMP

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

上一篇: ORA-27125错误解决
请登录后发表评论 登录
全部评论
成为全能!

注册时间:2012-04-10

  • 博文量
    163
  • 访问量
    439325