recover database skip [forever] tablespace XXX 的用法介绍

最新推荐文章于 2023-05-24 15:23:07 发布
最新推荐文章于 2023-05-24 15:23:07 发布
阅读量1k 收藏
点赞数
文章标签： 数据库
recovery过程中可以临时将某个暂无法恢复出来的tablespace skip掉，先恢复其它部分， 待recovery database完成并open database后，再recover这个被skip掉的表空间；recover database skip [forever] tablespace ... 可以支持以上功能
// complete recovery场景下使用 skip tablespace XXX

###列出database备份
RMAN> list backup of database;




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




BS Key  Type LV Size       Device Type Elapsed Time Completion Time  
------- ---- -- ---------- ----------- ------------ -----------------
76278   Full    2.00G      DISK        00:00:26     20150623 05:56:05
        BP Key: 76281   Status: AVAILABLE  Compressed: NO  Tag: TAG20150623T055537
        Piece Name: /oradata06/fra/TSTDB1/backupset/2015_06_23/o1_mf_nnndf_TAG20150623T055537_1kR5zK8Nx_.bkp
  List of Datafiles in backup set 76278
  File LV Type Ckp SCN    Ckp Time          Name
  ---- -- ---- ---------- ----------------- ----
  1       Full 12723362138466 20150623 05:55:39 /oradata06/testaaaaa/system01.dbf
  2       Full 12723362138466 20150623 05:55:39 /oradata06/testaaaaa/sysaux01.dbf
  3       Full 12723362138466 20150623 05:55:39 /oradata06/testaaaaa/undotbs01.dbf
  4       Full 12723362138466 20150623 05:55:39 /oradata06/testaaaaa/users01.dbf
  5       Full 12723362138466 20150623 05:55:39 /oradata06/testaaaaa/ts0329_1.dbf
  6       Full 12723362138466 20150623 05:55:39 /oradata06/testaaaaa/xdbts1.dbf
  7       Full 12723362138466 20150623 05:55:39 /oradata06/testaaaaa/ts0212.dbf
  8       Full 12723362138466 20150623 05:55:39 /oradata06/testaaaaa/ts0212_1.dbf
  9       Full 12723362138466 20150623 05:55:39 /oradata06/testaaaaa/ts0422_1.dbf
  10      Full 12723362138466 20150623 05:55:39 /oradata06/testaaaaa/ts0611.dbf


RMAN> list backup of controlfile
2> ;




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




BS Key  Type LV Size       Device Type Elapsed Time Completion Time  
------- ---- -- ---------- ----------- ------------ -----------------
76277   Full    13.64M     DISK        00:00:00     20150621 16:56:29
        BP Key: 76280   Status: AVAILABLE  Compressed: NO  Tag: TAG20150621T165532
        Piece Name: /oradata06/fra/TSTDB1/backupset/2015_06_21/o1_mf_ncsnf_TAG20150621T165532_1kP9z0FUh_.bkp
  Control File Included: Ckp SCN: 12723362045827   Ckp time: 20150621 16:56:29


BS Key  Type LV Size       Device Type Elapsed Time Completion Time  
------- ---- -- ---------- ----------- ------------ -----------------
76279   Full    13.64M     DISK        00:00:01     20150623 05:56:15
        BP Key: 76282   Status: AVAILABLE  Compressed: NO  Tag: TAG20150623T055537
        Piece Name: /oradata06/fra/TSTDB1/backupset/2015_06_23/o1_mf_ncsnf_TAG20150623T055537_1kR5_UAqO_.bkp
  Control File Included: Ckp SCN: 12723362138489   Ckp time: 20150623 05:56:14


###当前database schema
RMAN> report schema;


Report of database schema for database with db_unique_name TSTDB1


List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    1024     SYSTEM               YES     /oradata06/testaaaaa/system01.dbf
2    896      SYSAUX               NO      /oradata06/testaaaaa/sysaux01.dbf
3    2048     UNDOTBS              YES     /oradata06/testaaaaa/undotbs01.dbf
4    1024     USERS                NO      /oradata06/testaaaaa/users01.dbf
5    128      TS0329               NO      /oradata06/testaaaaa/ts0329_1.dbf
6    500      XDBTS                NO      /oradata06/testaaaaa/xdbts1.dbf
7    128      TS0212               NO      /oradata06/testaaaaa/ts0212.dbf
8    48       TS0212               NO      /oradata06/testaaaaa/ts0212_1.dbf
9    1800     TS0422_1             NO      /oradata06/testaaaaa/ts0422_1.dbf
10   128      TS0611_NEW           NO      /oradata06/testaaaaa/ts0611.dbf


List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    1024     TEMP                 1024        /oradata06/testaaaaa/temp01.dbf
  
###关闭数据库进行restore
shutdown immediate;
startup mount;
restore database;


###重命名数据文件，模拟datafile丢失的场景，recover database提示缺datafile 10
mv /oradata06/testaaaaa/ts0611.dbf /oradata06/testaaaaa/ts0611.dbf.bak


RMAN> recover database;


Starting recover at 20150623 09:24:10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=398 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/23/2015 09:24:11
RMAN-06094: datafile 10 must be restored


select ts.ts#,ts.name from v$tablespace ts,v$datafile df where df.ts#=ts.ts# and df.file#=10;
       TS# NAME
---------- ------------------------------
        15 TS0611_NEW


RMAN> recover database skip tablespace TS0611_NEW;


Starting recover at 20150623 09:35:43
using channel ORA_DISK_1


Executing: alter database datafile 10 offline    
starting media recovery


archived log for thread 1 with sequence 2 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc
archived log for thread 1 with sequence 3 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_3_1kR6teZeM_.arc
archived log for thread 1 with sequence 4 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_4_1kR6tmGw7_.arc
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc thread=1 sequence=2
media recovery complete, elapsed time: 00:00:02
Finished recover at 20150623 09:35:47


col name format a50
set linesize 100 pagesize 40
select name,status from v$datafile;
NAME                                               STATUS
-------------------------------------------------- -------
/oradata06/testaaaaa/system01.dbf                  SYSTEM
/oradata06/testaaaaa/sysaux01.dbf                  ONLINE
/oradata06/testaaaaa/undotbs01.dbf                 ONLINE
/oradata06/testaaaaa/users01.dbf                   ONLINE
/oradata06/testaaaaa/ts0329_1.dbf                  ONLINE
/oradata06/testaaaaa/xdbts1.dbf                    ONLINE
/oradata06/testaaaaa/ts0212.dbf                    ONLINE
/oradata06/testaaaaa/ts0212_1.dbf                  ONLINE
/oradata06/testaaaaa/ts0422_1.dbf                  ONLINE
/oradata06/testaaaaa/ts0611.dbf                    OFFLINE    


alter database open;


###挪回datafile 10, recover tablespace ts0611_new
mv /oradata06/testaaaaa/ts0611.dbf.bak /oradata06/testaaaaa/ts0611.dbf 


recover tablespace ts0611_new;


alter tablespace ts0611_new online;


SYS@tstdb1-SQL> select name,status from v$datafile;


NAME                                               STATUS
-------------------------------------------------- -------
/oradata06/testaaaaa/system01.dbf                  SYSTEM
/oradata06/testaaaaa/sysaux01.dbf                  ONLINE
/oradata06/testaaaaa/undotbs01.dbf                 ONLINE
/oradata06/testaaaaa/users01.dbf                   ONLINE
/oradata06/testaaaaa/ts0329_1.dbf                  ONLINE
/oradata06/testaaaaa/xdbts1.dbf                    ONLINE
/oradata06/testaaaaa/ts0212.dbf                    ONLINE
/oradata06/testaaaaa/ts0212_1.dbf                  ONLINE
/oradata06/testaaaaa/ts0422_1.dbf                  ONLINE
/oradata06/testaaaaa/ts0611.dbf                    ONLINE



//complete recovery场景下使用 skip forever XXX

shutdown immediate
rman target / catalog rman/773946@tstdb2
startup nomount
restore database;
alter database mount;


mv /oradata06/testaaaaa/ts0611.dbf /oradata06/testaaaaa/ts0611.dbf.bak


RMAN> recover database;


Starting recover at 20150623 09:54:34
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=332 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/23/2015 09:54:35
RMAN-06094: datafile 10 must be restored


###complete recovery的场景下使用skip forever
RMAN>  recover database skip forever tablespace ts0611_new;


Starting recover at 20150623 10:02:19
using channel ORA_DISK_1


Executing: alter database datafile 10 offline drop    
starting media recovery


archived log for thread 1 with sequence 2 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc
archived log for thread 1 with sequence 3 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_3_1kR6teZeM_.arc
archived log for thread 1 with sequence 4 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_4_1kR6tmGw7_.arc
archived log for thread 1 with sequence 5 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_5_1kRIdmC2Q_.arc
archived log for thread 1 with sequence 6 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_6_1kRIdovOA_.arc
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc thread=1 sequence=2
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_3_1kR6teZeM_.arc thread=1 sequence=3
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_4_1kR6tmGw7_.arc thread=1 sequence=4
media recovery complete, elapsed time: 00:00:02
Finished recover at 20150623 10:02:23


col name format a60
set linesize 120
select name,status,checkpoint_change# from v$datafile;
NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            SYSTEM      12723362144126
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362144126
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362144126
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362144126
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362144126
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362144126
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362144126
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362144126
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362144126
/oradata06/testaaaaa/ts0611.dbf                              OFFLINE     12723362144126    


alter database open;


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile;


NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            SYSTEM      12723362144129
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362144129
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362144129
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362144129
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362144129
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362144129
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362144129
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362144129
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362144129
/oradata06/testaaaaa/ts0611.dbf                              OFFLINE     12723362144126    


###挪回原位
mv /oradata06/testaaaaa/ts0611.dbf.bak /oradata06/testaaaaa/ts0611.dbf


SYS@tstdb1-SQL> alter tablespace ts0611_new online;
alter tablespace ts0611_new online
*
ERROR at line 1:
ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: '/oradata06/testaaaaa/ts0611.dbf'


###skip forever的tablespace依然可以recover
RMAN> recover tablespace ts0611_new;


Starting recover at 20150623 10:06:11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=332 device type=DISK


starting media recovery


archived log for thread 1 with sequence 2 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc
archived log for thread 1 with sequence 3 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_3_1kR6teZeM_.arc
archived log for thread 1 with sequence 4 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_4_1kR6tmGw7_.arc
archived log for thread 1 with sequence 5 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_5_1kRIdmC2Q_.arc
archived log for thread 1 with sequence 6 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_6_1kRIdovOA_.arc
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc thread=1 sequence=2
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_3_1kR6teZeM_.arc thread=1 sequence=3
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_4_1kR6tmGw7_.arc thread=1 sequence=4
media recovery complete, elapsed time: 00:00:00
Finished recover at 20150623 10:06:12


10 rows selected.


SYS@tstdb1-SQL> alter tablespace ts0611_new online;


Tablespace altered.


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile;


NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            SYSTEM      12723362144129
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362144129
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362144129
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362144129
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362144129
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362144129
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362144129
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362144129
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362144129
/oradata06/testaaaaa/ts0611.dbf                              ONLINE      12723362144824    


10 rows selected.



//incomplete recovery场景下使用 skip tablespace XXX，open db后还能继续恢复这个表空间

shutdown immediate
startup mount
restore database;


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile_header;


NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            ONLINE      12723362138466
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362138466
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362138466
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362138466
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362138466
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362138466
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362138466
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362138466
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362138466
/oradata06/testaaaaa/ts0611.dbf                              ONLINE      12723362138466


mv /oradata06/testaaaaa/ts0611.dbf /oradata06/testaaaaa/ts0611.dbf.bak


---recover database until scn
RMAN> recover database  until scn 12723362144133;


Starting recover at 20150623 10:17:25
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/23/2015 10:17:25
RMAN-06094: datafile 10 must be restored


---recover database until scn ... skip tablespace ...
RMAN> recover database  until scn 12723362144133 skip tablespace ts0611_new;


Starting recover at 20150623 10:18:15
using channel ORA_DISK_1


Executing: alter database datafile 10 offline    
starting media recovery


archived log for thread 1 with sequence 2 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc
archived log for thread 1 with sequence 3 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_3_1kR6teZeM_.arc
archived log for thread 1 with sequence 4 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_4_1kR6tmGw7_.arc
archived log for thread 1 with sequence 5 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_5_1kRIdmC2Q_.arc
archived log for thread 1 with sequence 6 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_6_1kRIdovOA_.arc
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc thread=1 sequence=2
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_3_1kR6teZeM_.arc thread=1 sequence=3
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_4_1kR6tmGw7_.arc thread=1 sequence=4
media recovery complete, elapsed time: 00:00:02
Finished recover at 20150623 10:18:19


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile_header;


NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            ONLINE      12723362144133
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362144133
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362144133
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362144133
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362144133
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362144133
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362144133
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362144133
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362144133
                                                             OFFLINE                  0


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile;


NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            SYSTEM      12723362145858
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362145858
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362145858
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362145858
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362145858
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362145858
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362145858
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362145858
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362145858
/oradata06/testaaaaa/ts0611.dbf                              OFFLINE     12723362145858


###打开数据库
alter database open resetlogs


col name format a60
set linesize 120 numwidth 16
select name,status,checkpoint_change# from v$datafile;
NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            SYSTEM      12723362145859
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362145859
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362145859
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362145859
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362145859
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362145859
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362145859
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362145859
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362145859
/oradata06/testaaaaa/ts0611.dbf                              OFFLINE     12723362145858


select name,status,checkpoint_change# from v$datafile_header;
NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            ONLINE      12723362145859
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362145859
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362145859
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362145859
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362145859
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362145859
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362145859
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362145859
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362145859
                                                             OFFLINE                  0


###挪回datafile 10
mv /oradata06/testaaaaa/ts0611.dbf.bak /oradata06/testaaaaa/ts0611.dbf


###online tablespace，提示Datafile 10是resetlogs前的版本
SYS@tstdb1-SQL> alter tablespace ts0611_new online;
alter tablespace ts0611_new online
*
ERROR at line 1:
ORA-01190: control file or data file 10 is from before the last RESETLOGS
ORA-01110: data file 10: '/oradata06/testaaaaa/ts0611.dbf'


###recover tablespace ts0611_new依然成功
RMAN> recover tablespace ts0611_new;


Starting recover at 20150623 10:28:50
using channel ORA_DISK_1


starting media recovery


archived log for thread 1 with sequence 2 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc
archived log for thread 1 with sequence 3 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_3_1kR6teZeM_.arc
archived log for thread 1 with sequence 4 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_4_1kR6tmGw7_.arc
archived log for thread 1 with sequence 5 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_5_1kRIdmC2Q_.arc
archived log for thread 1 with sequence 6 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_6_1kRIdovOA_.arc
archived log for thread 1 with sequence 7 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_7_1kRKxVWK7_.arc
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc thread=1 sequence=2
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_3_1kR6teZeM_.arc thread=1 sequence=3
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_4_1kR6tmGw7_.arc thread=1 sequence=4
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_5_1kRIdmC2Q_.arc thread=1 sequence=5
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_6_1kRIdovOA_.arc thread=1 sequence=6
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_7_1kRKxVWK7_.arc thread=1 sequence=7
media recovery complete, elapsed time: 00:00:01
Finished recover at 20150623 10:28:51


SYS@tstdb1-SQL> select name,status,resetlogs_change#,checkpoint_change# from v$datafile_header;


NAME                                                         STATUS  RESETLOGS_CHANGE# CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ----------------- ------------------
/oradata06/testaaaaa/system01.dbf                            ONLINE     12723362144134     12723362145859
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE     12723362144134     12723362145859
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE     12723362144134     12723362145859
/oradata06/testaaaaa/users01.dbf                             ONLINE     12723362144134     12723362145859
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE     12723362144134     12723362145859
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE     12723362144134     12723362145859
/oradata06/testaaaaa/ts0212.dbf                              ONLINE     12723362144134     12723362145859
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE     12723362144134     12723362145859
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE     12723362144134     12723362145859
/oradata06/testaaaaa/ts0611.dbf                              ONLINE     12723362144134     12723362146664


10 rows selected.


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile;


NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            SYSTEM      12723362145859
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362145859
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362145859
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362145859
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362145859
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362145859
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362145859
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362145859
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362145859
/oradata06/testaaaaa/ts0611.dbf                              ONLINE      12723362146664





//incomplete recovery场景下使用 skip forever tablespace XXX，open db后XXX表空间仍可以恢复

shutdown immediate
startup mount
restore database;


mv /oradata06/testaaaaa/ts0611.dbf /oradata06/testaaaaa/ts0611.dbf.bak


SYS@tstdb1-SQL> select name,status,resetlogs_change#,checkpoint_change# from v$datafile_header;


NAME                                                         STATUS  RESETLOGS_CHANGE# CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ----------------- ------------------
/oradata06/testaaaaa/system01.dbf                            ONLINE     12723362054987     12723362138466
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE     12723362054987     12723362138466
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE     12723362054987     12723362138466
/oradata06/testaaaaa/users01.dbf                             ONLINE     12723362054987     12723362138466
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE     12723362054987     12723362138466
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE     12723362054987     12723362138466
/oradata06/testaaaaa/ts0212.dbf                              ONLINE     12723362054987     12723362138466
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE     12723362054987     12723362138466
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE     12723362054987     12723362138466
                                                             ONLINE                  0                  0


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile;


NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            SYSTEM      12723362147430
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362147430
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362147430
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362147430
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362147430
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362147430
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362147430
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362147430
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362147430
/oradata06/testaaaaa/ts0611.dbf                              ONLINE      12723362147430


RMAN> recover database until scn 12723362147000 skip forever tablespace ts0611_new;


Starting recover at 20150623 10:40:21
using channel ORA_DISK_1


Executing: alter database datafile 10 offline drop    
starting media recovery


archived log for thread 1 with sequence 2 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc
archived log for thread 1 with sequence 3 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_3_1kR6teZeM_.arc
archived log for thread 1 with sequence 4 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_4_1kR6tmGw7_.arc
archived log for thread 1 with sequence 5 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_5_1kRIdmC2Q_.arc
archived log for thread 1 with sequence 6 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_6_1kRIdovOA_.arc
archived log for thread 1 with sequence 7 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_7_1kRKxVWK7_.arc
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc thread=1 sequence=2
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_3_1kR6teZeM_.arc thread=1 sequence=3
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_4_1kR6tmGw7_.arc thread=1 sequence=4
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_5_1kRIdmC2Q_.arc thread=1 sequence=5
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_6_1kRIdovOA_.arc thread=1 sequence=6
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_7_1kRKxVWK7_.arc thread=1 sequence=7
media recovery complete, elapsed time: 00:00:02
Finished recover at 20150623 10:40:25


alter database open resetlogs;


mv /oradata06/testaaaaa/ts0611.dbf.bak /oradata06/testaaaaa/ts0611.dbf


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile;


NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            SYSTEM      12723362147004
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362147004
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362147004
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362147004
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362147004
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/ts0611.dbf                              OFFLINE                  0


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile_header;


NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362147004
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362147004
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362147004
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362147004
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/ts0611.dbf                              OFFLINE     12723362138466


RMAN> recover tablespace ts0611_new;


Starting recover at 20150623 10:48:20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=398 device type=DISK


starting media recovery


archived log for thread 1 with sequence 2 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc
archived log for thread 1 with sequence 3 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_3_1kR6teZeM_.arc
archived log for thread 1 with sequence 4 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_4_1kR6tmGw7_.arc
archived log for thread 1 with sequence 5 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_5_1kRIdmC2Q_.arc
archived log for thread 1 with sequence 6 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_6_1kRIdovOA_.arc
archived log for thread 1 with sequence 7 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_7_1kRKxVWK7_.arc
archived log for thread 1 with sequence 1 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_1_1kRLv2UWQ_.arc
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_2_1kR6taPTD_.arc thread=1 sequence=2
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_3_1kR6teZeM_.arc thread=1 sequence=3
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_4_1kR6tmGw7_.arc thread=1 sequence=4
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_5_1kRIdmC2Q_.arc thread=1 sequence=5
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_6_1kRIdovOA_.arc thread=1 sequence=6
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_7_1kRKxVWK7_.arc thread=1 sequence=7
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_23/o1_mf_1_1_1kRLv2UWQ_.arc thread=1 sequence=1
media recovery complete, elapsed time: 00:00:00
Finished recover at 20150623 10:48:21
starting full resync of recovery catalog
full resync complete


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile_header;


NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362147004
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362147004
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362147004
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362147004
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/ts0611.dbf                              OFFLINE     12723362147001


10 rows selected.


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile;


NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            SYSTEM      12723362147004
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362147004
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362147004
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362147004
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362147004
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/ts0611.dbf                              OFFLINE     12723362147000


alter tablespace ts0611_new online


Tablespace altered.


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile;


NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            SYSTEM      12723362147004
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362147004
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362147004
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362147004
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362147004
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/ts0611.dbf                              ONLINE      12723362148075


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile_header;


NAME                                                         STATUS  CHECKPOINT_CHANGE#
------------------------------------------------------------ ------- ------------------
/oradata06/testaaaaa/system01.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/sysaux01.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/undotbs01.dbf                           ONLINE      12723362147004
/oradata06/testaaaaa/users01.dbf                             ONLINE      12723362147004
/oradata06/testaaaaa/ts0329_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/xdbts1.dbf                              ONLINE      12723362147004
/oradata06/testaaaaa/ts0212.dbf                              ONLINE      12723362147004
/oradata06/testaaaaa/ts0212_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/ts0422_1.dbf                            ONLINE      12723362147004
/oradata06/testaaaaa/ts0611.dbf                              ONLINE      12723362148075


SYS@tstdb1-SQL> create table aaa(id number) tablespace ts0611_new;


Table created.



// incomplete recovery场景下使用 skip forever tablespace XXX，open db后XXX表空间仍可以恢复并验证XXX表空间的恢复点

###新建表空间，进行备份
create tablespace ts0625_1 datafile '/oradata06/testaaaaa/ts0625_1.dbf' size 128m;


backup database plus archivelog;    
archivelog备份在tag=TAG20150625T095036、TAG20150625T095110
datafile & controlfile备份在tag=TAG20150625T095039


###创建测试表，记录before drop时间
create table t0625_2 tablespace ts0625_1 as select * from all_users;


SYS@tstdb1-SQL> select count(*) from t0625_2;


        COUNT(*)
----------------
              19
              
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;


select sysdate from dual;
SYSDATE
-----------------
20150625 09:52:50          


drop table t0625_1;
select sysdate from dual;
SYSDATE
-----------------
20150625 09:55:00          


alter system switch logfile;
alter system switch logfile;
alter system switch logfile;    


shutdown immediate
startup mount;


###restore到before drop time
RMAN> restore database until time '20150625 09:52:50';


Starting restore at 20150625 10:01:13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=332 device type=DISK


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 /oradata06/testaaaaa/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /oradata06/testaaaaa/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /oradata06/testaaaaa/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /oradata06/testaaaaa/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /oradata06/testaaaaa/ts0422_1.dbf
channel ORA_DISK_1: restoring datafile 00006 to /oradata06/testaaaaa/xdbts1.dbf
channel ORA_DISK_1: restoring datafile 00007 to /oradata06/testaaaaa/ts0212.dbf
channel ORA_DISK_1: restoring datafile 00008 to /oradata06/testaaaaa/ts0212_1.dbf
channel ORA_DISK_1: restoring datafile 00009 to /oradata06/testaaaaa/ts0623.dbf
channel ORA_DISK_1: restoring datafile 00010 to /oradata06/testaaaaa/ts0624.dbf
channel ORA_DISK_1: restoring datafile 00011 to /oradata06/testaaaaa/ts0624_2.dbf
channel ORA_DISK_1: restoring datafile 00012 to /oradata06/testaaaaa/ts0625.dbf
channel ORA_DISK_1: restoring datafile 00013 to /oradata06/testaaaaa/ts0625_1.dbf
channel ORA_DISK_1: reading from backup piece /oradata06/fra/TSTDB1/backupset/2015_06_25/o1_mf_nnndf_TAG20150625T095039_1kTq1Y_mg_.bkp
channel ORA_DISK_1: piece handle=/oradata06/fra/TSTDB1/backupset/2015_06_25/o1_mf_nnndf_TAG20150625T095039_1kTq1Y_mg_.bkp tag=TAG20150625T095039
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 20150625 10:02:19


###模拟ts0625_1.dbf文件丢失
mv /oradata06/testaaaaa/ts0625_1.dbf /oradata06/testaaaaa/ts0625_1.dbf.old


col name format a40
set numwidth 16 linesize 140 pagesize 50 
SYS@tstdb1-SQL> select name,status,resetlogs_change#,checkpoint_change# from v$datafile_header;
NAME                                     STATUS  RESETLOGS_CHANGE# CHECKPOINT_CHANGE#
---------------------------------------- ------- ----------------- ------------------
/oradata06/testaaaaa/system01.dbf        ONLINE     12723362559613     12723362561576
/oradata06/testaaaaa/sysaux01.dbf        ONLINE     12723362559613     12723362561576
/oradata06/testaaaaa/undotbs01.dbf       ONLINE     12723362559613     12723362561576
/oradata06/testaaaaa/users01.dbf         ONLINE     12723362559613     12723362561576
/oradata06/testaaaaa/ts0422_1.dbf        ONLINE     12723362559613     12723362561576
/oradata06/testaaaaa/xdbts1.dbf          ONLINE     12723362559613     12723362561576
/oradata06/testaaaaa/ts0212.dbf          ONLINE     12723362559613     12723362561576
/oradata06/testaaaaa/ts0212_1.dbf        ONLINE     12723362559613     12723362561576
/oradata06/testaaaaa/ts0623.dbf          ONLINE     12723362559613     12723362561576
/oradata06/testaaaaa/ts0624.dbf          ONLINE     12723362559613     12723362561576
/oradata06/testaaaaa/ts0624_2.dbf        ONLINE     12723362559613     12723362561576
/oradata06/testaaaaa/ts0625.dbf          ONLINE     12723362559613     12723362561576
                                         ONLINE                  0                  0


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile;
NAME                                     STATUS  CHECKPOINT_CHANGE#
---------------------------------------- ------- ------------------
/oradata06/testaaaaa/system01.dbf        SYSTEM      12723362563571
/oradata06/testaaaaa/sysaux01.dbf        ONLINE      12723362563571
/oradata06/testaaaaa/undotbs01.dbf       ONLINE      12723362563571
/oradata06/testaaaaa/users01.dbf         ONLINE      12723362563571
/oradata06/testaaaaa/ts0422_1.dbf        ONLINE      12723362563571
/oradata06/testaaaaa/xdbts1.dbf          ONLINE      12723362563571
/oradata06/testaaaaa/ts0212.dbf          ONLINE      12723362563571
/oradata06/testaaaaa/ts0212_1.dbf        ONLINE      12723362563571
/oradata06/testaaaaa/ts0623.dbf          ONLINE      12723362563571
/oradata06/testaaaaa/ts0624.dbf          ONLINE      12723362563571
/oradata06/testaaaaa/ts0624_2.dbf        ONLINE      12723362563571
/oradata06/testaaaaa/ts0625.dbf          ONLINE      12723362563571
/oradata06/testaaaaa/ts0625_1.dbf        ONLINE      12723362563571


###必须recover database skip tablespace XXX才能保证recover database的顺利进行
RMAN> recover database until time '20150625 09:52:50';


Starting recover at 20150625 10:06:39
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/25/2015 10:06:40
RMAN-06094: datafile 13 must be restored


RMAN> recover database skip forever tablespace ts0625_1 until time '20150625 09:52:50';


Starting recover at 20150625 10:07:12
using channel ORA_DISK_1


Executing: alter database datafile 13 offline drop
starting media recovery


archived log for thread 1 with sequence 2 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_2_1kTq3AZHd_.arc
archived log for thread 1 with sequence 3 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_3_1kTq8e8FN_.arc
archived log for thread 1 with sequence 4 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_4_1kTq8obLf_.arc
archived log for thread 1 with sequence 5 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_5_1kTq8-6p7_.arc
archived log for thread 1 with sequence 6 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_6_1kTqAaKlg_.arc
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_2_1kTq3AZHd_.arc thread=1 sequence=2
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_3_1kTq8e8FN_.arc thread=1 sequence=3
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_4_1kTq8obLf_.arc thread=1 sequence=4
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_5_1kTq8-6p7_.arc thread=1 sequence=5
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_6_1kTqAaKlg_.arc thread=1 sequence=6
media recovery complete, elapsed time: 00:00:01
Finished recover at 20150625 10:07:15


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile_header;


NAME                                     STATUS  CHECKPOINT_CHANGE#
---------------------------------------- ------- ------------------
/oradata06/testaaaaa/system01.dbf        ONLINE      12723362562753
/oradata06/testaaaaa/sysaux01.dbf        ONLINE      12723362562753
/oradata06/testaaaaa/undotbs01.dbf       ONLINE      12723362562753
/oradata06/testaaaaa/users01.dbf         ONLINE      12723362562753
/oradata06/testaaaaa/ts0422_1.dbf        ONLINE      12723362562753
/oradata06/testaaaaa/xdbts1.dbf          ONLINE      12723362562753
/oradata06/testaaaaa/ts0212.dbf          ONLINE      12723362562753
/oradata06/testaaaaa/ts0212_1.dbf        ONLINE      12723362562753
/oradata06/testaaaaa/ts0623.dbf          ONLINE      12723362562753
/oradata06/testaaaaa/ts0624.dbf          ONLINE      12723362562753
/oradata06/testaaaaa/ts0624_2.dbf        ONLINE      12723362562753
/oradata06/testaaaaa/ts0625.dbf          ONLINE      12723362562753
                                         OFFLINE                  0


###open resetlogs
alter database open resetlogs;


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile_header;


NAME                                     STATUS  CHECKPOINT_CHANGE#
---------------------------------------- ------- ------------------
/oradata06/testaaaaa/system01.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/sysaux01.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/undotbs01.dbf       ONLINE      12723362562757
/oradata06/testaaaaa/users01.dbf         ONLINE      12723362562757
/oradata06/testaaaaa/ts0422_1.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/xdbts1.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0212.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0212_1.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/ts0623.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0624.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0624_2.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/ts0625.dbf          ONLINE      12723362562757
                                         OFFLINE                  0


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile;


NAME                                     STATUS  CHECKPOINT_CHANGE#
---------------------------------------- ------- ------------------
/oradata06/testaaaaa/system01.dbf        SYSTEM      12723362562757
/oradata06/testaaaaa/sysaux01.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/undotbs01.dbf       ONLINE      12723362562757
/oradata06/testaaaaa/users01.dbf         ONLINE      12723362562757
/oradata06/testaaaaa/ts0422_1.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/xdbts1.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0212.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0212_1.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/ts0623.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0624.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0624_2.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/ts0625.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0625_1.dbf        OFFLINE                  0


###恢复datafile 12的至源路径
mv /oradata06/testaaaaa/ts0625_1.dbf.old /oradata06/testaaaaa/ts0625_1.dbf


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile_header;
NAME                                     STATUS  CHECKPOINT_CHANGE#
---------------------------------------- ------- ------------------
/oradata06/testaaaaa/system01.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/sysaux01.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/undotbs01.dbf       ONLINE      12723362562757
/oradata06/testaaaaa/users01.dbf         ONLINE      12723362562757
/oradata06/testaaaaa/ts0422_1.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/xdbts1.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0212.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0212_1.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/ts0623.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0624.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0624_2.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/ts0625_1.dbf        OFFLINE     12723362561576


###PRIOR_RESETLOGS_CHANGE#=12723362559613，根据resetlogs_change#=12723362559613到v$archived_log查找最大的sequence#
SYS@tstdb1-SQL> select max(sequence#) from v$archived_log where resetlogs_change#=12723362559613;


  MAX(SEQUENCE#)
----------------
              12
              
RMAN> recover tablespace ts0625_1;    


Starting recover at 20150625 10:12:28
starting full resync of recovery catalog
full resync complete
using channel ORA_DISK_1


starting media recovery


archived log for thread 1 with sequence 2 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_2_1kTq3AZHd_.arc
archived log for thread 1 with sequence 3 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_3_1kTq8e8FN_.arc
archived log for thread 1 with sequence 4 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_4_1kTq8obLf_.arc
archived log for thread 1 with sequence 5 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_5_1kTq8-6p7_.arc
archived log for thread 1 with sequence 6 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_6_1kTqAaKlg_.arc
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_2_1kTq3AZHd_.arc thread=1 sequence=2
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_3_1kTq8e8FN_.arc thread=1 sequence=3
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_4_1kTq8obLf_.arc thread=1 sequence=4
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_5_1kTq8-6p7_.arc thread=1 sequence=5
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_06_25/o1_mf_1_6_1kTqAaKlg_.arc thread=1 sequence=6
media recovery complete, elapsed time: 00:00:01
Finished recover at 20150625 10:12:31
starting full resync of recovery catalog
full resync complete


SYS@tstdb1-SQL> select name,status,checkpoint_change#,resetlogs_change# from v$datafile_header;


NAME                                     STATUS  CHECKPOINT_CHANGE# RESETLOGS_CHANGE#
---------------------------------------- ------- ------------------ -----------------
/oradata06/testaaaaa/system01.dbf        ONLINE      12723362562757    12723362562754
/oradata06/testaaaaa/sysaux01.dbf        ONLINE      12723362562757    12723362562754
/oradata06/testaaaaa/undotbs01.dbf       ONLINE      12723362562757    12723362562754
/oradata06/testaaaaa/users01.dbf         ONLINE      12723362562757    12723362562754
/oradata06/testaaaaa/ts0422_1.dbf        ONLINE      12723362562757    12723362562754
/oradata06/testaaaaa/xdbts1.dbf          ONLINE      12723362562757    12723362562754
/oradata06/testaaaaa/ts0212.dbf          ONLINE      12723362562757    12723362562754
/oradata06/testaaaaa/ts0212_1.dbf        ONLINE      12723362562757    12723362562754
/oradata06/testaaaaa/ts0623.dbf          ONLINE      12723362562757    12723362562754
/oradata06/testaaaaa/ts0624.dbf          ONLINE      12723362562757    12723362562754
/oradata06/testaaaaa/ts0624_2.dbf        ONLINE      12723362562757    12723362562754
/oradata06/testaaaaa/ts0625_1.dbf        OFFLINE     12723362562754    12723362562754            


---12723362562754包含在log sequence# 6里
SYS@tstdb1-SQL> select sequence#,first_change#,next_change# from v$archived_log where resetlogs_change#=12723362559613 and 12723362562754 between first_change# and next_change#;


       SEQUENCE#    FIRST_CHANGE#     NEXT_CHANGE#
---------------- ---------------- ----------------
               6   12723362562746   12723362562767


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile;


NAME                                     STATUS  CHECKPOINT_CHANGE#
---------------------------------------- ------- ------------------
/oradata06/testaaaaa/system01.dbf        SYSTEM      12723362562757
/oradata06/testaaaaa/sysaux01.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/undotbs01.dbf       ONLINE      12723362562757
/oradata06/testaaaaa/users01.dbf         ONLINE      12723362562757
/oradata06/testaaaaa/ts0422_1.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/xdbts1.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0212.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0212_1.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/ts0623.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0624.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0624_2.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/ts0625_1.dbf        OFFLINE     12723362562753


SYS@tstdb1-SQL> select count(*) from t0625_2;
select count(*) from t0625_2
                     *
ERROR at line 1:
ORA-00376: file 13 cannot be read at this time
ORA-01110: data file 13: '/oradata06/testaaaaa/ts0625_1.dbf'


alter tablespace ts0625_1 online;


###验证表t0625_2存在
SYS@tstdb1-SQL> select count(*) from t0625_2;


        COUNT(*)
----------------
              19


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile;


NAME                                     STATUS  CHECKPOINT_CHANGE#
---------------------------------------- ------- ------------------
/oradata06/testaaaaa/system01.dbf        SYSTEM      12723362562757
/oradata06/testaaaaa/sysaux01.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/undotbs01.dbf       ONLINE      12723362562757
/oradata06/testaaaaa/users01.dbf         ONLINE      12723362562757
/oradata06/testaaaaa/ts0422_1.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/xdbts1.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0212.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0212_1.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/ts0623.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0624.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0624_2.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/ts0625_1.dbf        ONLINE      12723362564357


12 rows selected.


SYS@tstdb1-SQL> select name,status,checkpoint_change# from v$datafile_header;


NAME                                     STATUS  CHECKPOINT_CHANGE#
---------------------------------------- ------- ------------------
/oradata06/testaaaaa/system01.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/sysaux01.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/undotbs01.dbf       ONLINE      12723362562757
/oradata06/testaaaaa/users01.dbf         ONLINE      12723362562757
/oradata06/testaaaaa/ts0422_1.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/xdbts1.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0212.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0212_1.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/ts0623.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0624.dbf          ONLINE      12723362562757
/oradata06/testaaaaa/ts0624_2.dbf        ONLINE      12723362562757
/oradata06/testaaaaa/ts0625_1.dbf        ONLINE      12723362564357


结论：skip tablespace /skip forever tablespace用在incomplete recovery/complete recovery的场景中都可以起到将延迟recover表空间的功能，先把db拉起来，再恢复这个表空间；incomplete recovery先把database recover到指定时间点open resetlogs，之后再执行recover tablespace XXX的效果相当于将该表空间从备份点恢复到open resetlogs后的当前最新的时间点。skip tablespace和skip forever tablespace作用上没有明显区别

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

转载于:http://blog.itpub.net/53956/viewspace-1726049/

cuiqiong6888
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mysql中关于Myisam_recover自动修复的使用方法
09-10
主要介绍了mysql中关于Myisam_recover自动修复的使用方法,需要的朋友可以参考下
ORACLE rman 部分恢复
gaobudong1234的博客
06-12 551
查出数据库文件名列表 前面已经将库置mount，从controlfile中得到logfile和datafile,tempfile列表，在恢复时用到 sqlplus / as sysdba set linesize 120 set pagesize 0 col name format a70 select file#,name from V$datafile; select f
Oracle19c 误删除恢复（PDB指定表空间恢复）
最新发布
qq_29431123的博客
05-24 1017
5月20日客户反应某个系统两张表少数据，这两个表位于一套Oracle 19c RAC容器数据库的一个PDB中，需要使用备份将这两个表恢复到5月17日早上8点。出问题的PDB大小5T，只恢复一个PDB效率也不理想。提示1：这里需要恢复的两个表自包含于一个表空间pdb1_FM,所以只需要恢复这一个表空间，再加上SYSTEM表空间和UNDO表空间，就可以将PDB拉起来。但是本次没有做全库的恢复，只做了指定表空间恢复，没有恢复SYSAUX而且也没有新建TEMP表空间，使用数据泵导出会报错，所以使用DBLINK。
异地恢复某个表空间
u012232730的博客
05-17 1003
情景：一张表的数据被误删除，数据库有rman备份。 措施：首先保留现场，将所有备份及归档备份一份，然后准备机器，将备份和归档复制到上面，最好做到所有目录和原库一致。 生成set newname语句 select 'set newname for datafile '||file#||' to ''/u01/app/oracle/oradata/orcl/'||substr(name,21,1...
oracle--rman备份纪要
jiujiederoushan的博客
11-12 3253
1、设置channel数量，增加备份/恢复传输速度。 2、设置最大坏块数，set maxcorrupt，避免少数坏块引起备份或恢复失败。 3、跳过只读数据块，backup指令加上skip readonly参数。 4、设置默认备份类型，默认为disk，可改为sbt，rman将顺序执行sbt库中函数。 ..................
Oracle RMAN 表空间恢复
wubaohu1314的博客
09-04 683
需求： 恢复1天前(05/06/2021 08:05:05)数据库内一个用户的数据。 环境说明： DB:Oracle 11204 RAC OS:AIX 7.1 操作： 1 2 3 4 1.由于之前只有rman备份，没有逻辑备份，只能进行rman恢复。 2.全库有3T多，数据量较大，恢复机剩余空间不到1T，无法进行全库恢复。 3.查看用户所在表空间很小，只有300G，考虑只恢复用户数据所在表空间，在加上system,sysa
go语言异常panic和恢复recover用法实例
09-22
主要介绍了go语言异常panic和恢复recover用法,实例分析了异常panic和恢复recover使用技巧,具有一定参考借鉴价值,需要的朋友可以参考下
go语言的panic和recover函数用法实例
09-19
今天小编就为大家分享一篇关于go语言的panic和recover函数用法实例，小编觉得内容挺不错的，现在分享给大家，具有很好的参考价值，需要的朋友一起跟随小编来看看吧
rac to single rman手动注册归档日志备份集进行recover database
04-14
本文主要描述Oracle DB 在使用rman进行恢复时，如何利用rman注册备份集的方式达到主库和目标库数据一致的目的。当然Oracle数据库的话使用DG或ADG技术、或者rman的duplicate技术都是非常好的选择。
Logminer 数据库恢复及恢复归档文件
weixin_33921089的博客
02-13 101
1.从源库生成spfile文件，并拷贝到目标库 sqlplus '/as sysdba' create pfile='/oracle/tmp/pfile_dbname1_20130319.ora' from spfile; 2.目标库使用源库的pfile文件，去掉相关参数，打开数据库到nomount状态 export ORACLE_SID=dbname1 s...
rman备份异机恢复部分pdb
weixin_30500663的博客
08-25 1379
rman备份异机恢复部分pdb参考资料：How to use Rman to Restore Of Single PDB in Multitenant to Alternate Server (文档 ID 2142675.1) recover database skip forever tablespace CFMDB_PRD:SYSTEM,CFMDB_PRD:SYSAUX,CFMDB_PRD:U...
通过nbu恢复oracle数据库（恢复实例）
安全解决方案
03-12 3665
关闭开启的实例数据库（未关监听） shutdown immediate 2、传NBU客户端 3、安装NBU客户端 /usr/openv/netbackup/bin ./oracle_link 建立连接 新客户端必须启动这个命令，不然无法进行还原，需要在oracle用户下跑命令 4、查询备份信息 ...
linux修复表空间,如何使用 RMAN 异机恢复部分表空间
weixin_42632434的博客
05-11 151
在Oracle 数据库的日常维护和使用期间难免会遇到误删数据(drop，delete， truncate)当我们使用常规手段(flashback query ，flashback drop)也无法恢复数据时，我们可以使用最近的逻辑备份，在异机使用dmp 来恢复相应的表，但是如果没有这些逻辑备份，但是有一个最近的rman 全备，那么我们就可以利用这个备份来恢复被误删的表空间，从而实现数据的恢复，这里...
oracle rman 显示太乱,【RMAN】Oracle_rman中skip引发的血案
weixin_35651855的博客
04-05 405
好久没有动脑子了，最近一直在跑步、踢球，练就成了四肢发达、头脑简单的高级动物，当同学把rman恢复错误信息给我发过来之后，都不知道怎么下手了，更囧的是一个项目组的哥们让我帮忙看看数据库问题，parameter参数竟然瞬间忘了，整天文档、文章的，荒废了。为了调整，我决定没事找事，OK，咱看一下下面的问题。(以下信息是在我的测试机上还原的)同学发过来的问题如下：RMAN-00571:=========...
记一次集群数据库异机恢复单个表空间中的一张表
Olympia_的博客
10-21 366
前景：因为修改表的结构后，导致程序执行中出现问题，将原有表全部刷新，需要将这张表数据恢复到2021.10.15日下午14：30的状态 版本：数据库19c rac 恢复机器：19c 单机 备份工具：NBU 备份情况：10.14日,10.15日都是累计增量备份，全备时间为10.13日。 需要有一个大致的恢复思路，为了恢复的较快一点，选择了恢复单个表空间的方法。 恢复过程： 首先去查看需要恢复的表所在的表空间，包括表的约束，索引等元数据情况。这张表无任何约束索引，也不是分区表，这就很好办了。 ...
12c-RECOVER PLUGGABLE DATABASE
06-07 250
[oracle@orat3 ~]$ export ORACLE_SID=prd12cdb1 [oracle@orat3 ~]$ rman target / Recovery Manager: Relea...
oracle rman恢复表空间,rman恢复部分表空间
weixin_31008853的博客
04-04 377
SQL> conn / as sysdbaConnected.SQL> select name from v$datafile;NAME--------------------------------------------------------------------------------/u01/oracle/oradata/orcl/system01.dbf/u01/orac...
Oracle-Rman备份恢复单个PDB
sinat_36757755的博客
06-02 2755
对于Oracle 12C之后的CDB，PDB备份，如果每次恢复都需要恢复整个CDB，那么这将大大增大恢复的时间以及空间，特别是在CDB包含多个PDB的时候，如果我们可以只从备份里面恢复某个PDB，将大大减少恢复的时间以及空间，本文将讲述如何从NBU全备里面恢复某个PDB的操作过程。...
oracle 11203 ora32701,love wife love life —Roger的Oracle/MySQL数据恢复博客
weixin_39831170的博客
04-07 530
前几天某客户的一个数据库出现故障，需要我们紧急救援支持。了解了一下环境，着实也吓了一跳，数据量55TB左右。首先我们来看看故障的信息：Fri Mar 25 22:57:10 2016Errors in file /oracle/app/oracle/diag/rdbms/njsdb/njsdb1/trace/xxxx1_dia0_30474350.trc (incident=640081):OR...
recover standby database from service
05-24
To recover a standby database from a service, you can follow the below steps: 1. Connect to the primary database using SQL*Plus or any other database client tool. 2. Check the status of the standby database using the following command: ``` SELECT NAME, DB_UNIQUE_NAME, DATABASE_ROLE, OPEN_MODE FROM V$DATABASE; ``` This command will display the name, unique name, database role, and open mode of the primary and standby databases. 3. If the standby database is not in sync with the primary database, you need to perform a switchover to make it the primary database. 4. Once the standby database is in sync with the primary database, you can start the recovery process by executing the following command: ``` RECOVER DATABASE USING SERVICE '<service_name>'; ``` This command will initiate the recovery process on the standby database using the specified service name. 5. Monitor the progress of the recovery process using the following command: ``` SELECT PROCESS, SEQUENCE#, BLOCK#, STATUS FROM V$MANAGED_STANDBY; ``` This command will display the current status of the recovery process. 6. Once the recovery process is complete, you can open the standby database in read-only mode using the following command: ``` ALTER DATABASE OPEN READ ONLY; ``` This command will allow you to access the standby database in read-only mode. Note: Make sure to maintain proper backups of both the primary and standby databases to avoid any data loss.

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值