Thinking Out Loud

July 2, 2013

RMAN restore

Filed under: 11g,Recovery,RMAN — mdinh @ 1:38 pm

Is my backup any good? Let’s find out.

Today, I needed to restore the database due to a failed upgrade to 12c and here is the process.

$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 2 06:02:45 2013

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

connected to target database (not started)

RMAN> startup force nomount;

Oracle instance started

Total System Global Area     534462464 bytes

Fixed Size                     2230072 bytes
Variable Size                163580104 bytes
Database Buffers             364904448 bytes
Redo Buffers                   3747840 bytes

RMAN> exit

$ ls -l /oracle/backup/
total 179536
-rw-r----- 1 oracle oinstall 22029824 Jun 28 22:01 DB01_1439793859_20130628_tbodbp63_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall 12934144 Jun 28 22:01 DB01_1439793859_20130628_tcodbp6a_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  1236992 Jun 28 22:01 DB01_1439793859_20130628_tdodbp6d_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  6857728 Jun 28 22:01 DB01_1439793859_20130628_teodbp6f_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall 23293952 Jun 28 22:01 DB01_1439793859_20130628_tfodbp6i_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  1555456 Jun 28 22:01 DB01_1439793859_20130628_tgodbp6l_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  7286272 Jun 28 22:01 DB01_1439793859_20130628_thodbp6m_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  9636352 Jun 28 22:02 DB01_1439793859_20130628_tiodbp6p_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  1377280 Jun 28 22:02 DB01_1439793859_20130628_tjodbp6t_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  5707264 Jun 28 22:02 DB01_1439793859_20130628_tkodbp6u_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall 37765120 Jun 28 22:02 DB01_1439793859_20130628_tlodbp6v_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  4841472 Jun 28 22:02 DB01_1439793859_20130628_tmodbp7e_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall 20168704 Jun 28 22:02 DB01_1439793859_20130628_tnodbp7i_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  2678784 Jun 28 22:02 DB01_1439793859_20130628_toodbp8b_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  1073152 Jun 28 22:02 DB01_1439793859_20130628_tpodbp8i_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  1073152 Jun 28 22:02 DB01_1439793859_20130628_tqodbp8j_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  1073152 Jun 28 22:03 DB01_1439793859_20130628_trodbp8k_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  1073152 Jun 28 22:03 DB01_1439793859_20130628_tsodbp8l_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  1073152 Jun 28 22:03 DB01_1439793859_20130628_ttodbp8n_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  1277952 Jun 28 22:03 DB01_1439793859_20130628_tuodbp8o_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall    42496 Jun 28 22:03 DB01_1439793859_20130628_tvodbp8t_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall    98304 Jun 28 22:03 DB01_1439793859_20130628_u0odbp8u_1_1.inc0_Fri
-rw-r----- 1 oracle oinstall  9830400 Jun 28 22:03 DB01_c-1439793859-20130628-08
-rw-r----- 1 oracle oinstall  9830400 Jul  1 17:06 DB01_c-1439793859-20130701-00

$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 2 06:03:54 2013

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

connected to target database: DB01 (not mounted)

RMAN> restore controlfile from '/oracle/backup/DB01_c-1439793859-20130628-08';

Starting restore at 02-jul-2013 06:04:17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/oracle/flashrecovery/LAX_DB01/controlfile/o1_mf_8nctts7b_.ctl
Finished restore at 02-jul-2013 06:04:21

RMAN> startup force mount;

Oracle instance started
database mounted

Total System Global Area     534462464 bytes

Fixed Size                     2230072 bytes
Variable Size                163580104 bytes
Database Buffers             364904448 bytes
Redo Buffers                   3747840 bytes

RMAN> restore database;

Starting restore at 02-jul-2013 06:04:45
Starting implicit crosscheck backup at 02-jul-2013 06:04:45
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=19 device type=DISK
Crosschecked 22 objects
Finished implicit crosscheck backup at 02-jul-2013 06:04:48

Starting implicit crosscheck copy at 02-jul-2013 06:04:48
using channel ORA_DISK_1
using channel ORA_DISK_2
Finished implicit crosscheck copy at 02-jul-2013 06:04:48

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

List of Cataloged Files
=======================
File Name: /oracle/flashrecovery/LAX_DB01/archivelog/2013_07_01/o1_mf_1_136_8x450667_.arc

using channel ORA_DISK_1
using channel ORA_DISK_2

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 /oracle/oradata/db02/system_1.dbf
channel ORA_DISK_1: reading from backup piece /oracle/backup/DB01_1439793859_20130628_tlodbp6v_1_1.inc0_Fri
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00004 to /oracle/oradata/db02/user_data_1.dbf
channel ORA_DISK_2: reading from backup piece /oracle/backup/DB01_1439793859_20130628_tmodbp7e_1_1.inc0_Fri
channel ORA_DISK_2: piece handle=/oracle/backup/DB01_1439793859_20130628_tmodbp7e_1_1.inc0_Fri tag=INC0_FRI
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:25
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00002 to /oracle/oradata/db02/sysaux_1.dbf
channel ORA_DISK_2: reading from backup piece /oracle/backup/DB01_1439793859_20130628_tnodbp7i_1_1.inc0_Fri
channel ORA_DISK_1: piece handle=/oracle/backup/DB01_1439793859_20130628_tlodbp6v_1_1.inc0_Fri tag=INC0_FRI
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:30
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 00003 to /oracle/oradata/db02/undotbs_1.dbf
channel ORA_DISK_1: reading from backup piece /oracle/backup/DB01_1439793859_20130628_toodbp8b_1_1.inc0_Fri
channel ORA_DISK_2: piece handle=/oracle/backup/DB01_1439793859_20130628_tnodbp7i_1_1.inc0_Fri tag=INC0_FRI
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:01:05
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00005 to /oracle/oradata/db02/udata_1.dbf
channel ORA_DISK_2: reading from backup piece /oracle/backup/DB01_1439793859_20130628_tpodbp8i_1_1.inc0_Fri
channel ORA_DISK_2: piece handle=/oracle/backup/DB01_1439793859_20130628_tpodbp8i_1_1.inc0_Fri tag=INC0_FRI
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:25
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00006 to /oracle/oradata/db02/user_index_1.dbf
channel ORA_DISK_2: reading from backup piece /oracle/backup/DB01_1439793859_20130628_tqodbp8j_1_1.inc0_Fri
channel ORA_DISK_1: piece handle=/oracle/backup/DB01_1439793859_20130628_toodbp8b_1_1.inc0_Fri tag=INC0_FRI
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:26
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 00007 to /oracle/oradata/db02/user_data_2.dbf
channel ORA_DISK_1: reading from backup piece /oracle/backup/DB01_1439793859_20130628_trodbp8k_1_1.inc0_Fri
channel ORA_DISK_1: piece handle=/oracle/backup/DB01_1439793859_20130628_trodbp8k_1_1.inc0_Fri tag=INC0_FRI
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 00008 to /oracle/oradata/db02/nidx_1.dbf
channel ORA_DISK_1: reading from backup piece /oracle/backup/DB01_1439793859_20130628_tsodbp8l_1_1.inc0_Fri
channel ORA_DISK_2: piece handle=/oracle/backup/DB01_1439793859_20130628_tqodbp8j_1_1.inc0_Fri tag=INC0_FRI
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:07
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00009 to /oracle/oradata/db02/nlob_1.dbf
channel ORA_DISK_2: reading from backup piece /oracle/backup/DB01_1439793859_20130628_ttodbp8n_1_1.inc0_Fri
channel ORA_DISK_1: piece handle=/oracle/backup/DB01_1439793859_20130628_tsodbp8l_1_1.inc0_Fri tag=INC0_FRI
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_DISK_2: piece handle=/oracle/backup/DB01_1439793859_20130628_ttodbp8n_1_1.inc0_Fri tag=INC0_FRI
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:07
Finished restore at 02-jul-2013 06:07:00

RMAN> list backup of archivelog all;

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
855     21.01M     DISK        00:00:03     28-jun-2013 22:01:42
        BP Key: 855   Status: AVAILABLE  Compressed: YES  Tag: INC0_FRI
        Piece Name: /oracle/backup/DB01_1439793859_20130628_tbodbp63_1_1.inc0_Fri

  List of Archived Logs in backup set 855
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    69      1263640    14-jun-2013 20:24:54 1263670    14-jun-2013 20:25:37
  1    70      1263670    14-jun-2013 20:25:37 1285630    15-jun-2013 06:03:19

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
856     12.33M     DISK        00:00:02     28-jun-2013 22:01:48
        BP Key: 856   Status: AVAILABLE  Compressed: YES  Tag: INC0_FRI
        Piece Name: /oracle/backup/DB01_1439793859_20130628_tcodbp6a_1_1.inc0_Fri

  List of Archived Logs in backup set 856
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    71      1285630    15-jun-2013 06:03:19 1311478    21-jun-2013 14:08:17
  1    72      1311478    21-jun-2013 14:08:17 1334378    22-jun-2013 10:30:56
  1    73      1334378    22-jun-2013 10:30:56 1337697    22-jun-2013 10:38:42

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
857     1.18M      DISK        00:00:01     28-jun-2013 22:01:50
        BP Key: 857   Status: AVAILABLE  Compressed: YES  Tag: INC0_FRI
        Piece Name: /oracle/backup/DB01_1439793859_20130628_tdodbp6d_1_1.inc0_Fri

  List of Archived Logs in backup set 857
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    74      1337697    22-jun-2013 10:38:42 1338000    22-jun-2013 10:45:53
  1    75      1338000    22-jun-2013 10:45:53 1338078    22-jun-2013 10:46:27
  1    76      1338078    22-jun-2013 10:46:27 1338436    22-jun-2013 10:47:21
  1    77      1338436    22-jun-2013 10:47:21 1338524    22-jun-2013 10:47:33
  1    78      1338524    22-jun-2013 10:47:33 1338551    22-jun-2013 10:48:07
  1    79      1338551    22-jun-2013 10:48:07 1338727    22-jun-2013 10:50:49
  1    80      1338727    22-jun-2013 10:50:49 1338803    22-jun-2013 10:51:18
  1    81      1338803    22-jun-2013 10:51:18 1338919    22-jun-2013 10:54:58

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
858     6.54M      DISK        00:00:01     28-jun-2013 22:01:52
        BP Key: 858   Status: AVAILABLE  Compressed: YES  Tag: INC0_FRI
        Piece Name: /oracle/backup/DB01_1439793859_20130628_teodbp6f_1_1.inc0_Fri

  List of Archived Logs in backup set 858
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    82      1338919    22-jun-2013 10:54:58 1338943    22-jun-2013 10:55:25
  1    83      1338943    22-jun-2013 10:55:25 1339111    22-jun-2013 10:58:58
  1    84      1339111    22-jun-2013 10:58:58 1339136    22-jun-2013 10:59:25
  1    85      1339136    22-jun-2013 10:59:25 1339690    22-jun-2013 11:18:52
  1    86      1339690    22-jun-2013 11:18:52 1339721    22-jun-2013 11:19:37
  1    87      1339721    22-jun-2013 11:19:37 1339880    22-jun-2013 11:22:45
  1    88      1339880    22-jun-2013 11:22:45 1339909    22-jun-2013 11:23:24
  1    89      1339909    22-jun-2013 11:23:24 1351681    22-jun-2013 17:42:30

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
859     22.21M     DISK        00:00:02     28-jun-2013 22:01:56
        BP Key: 859   Status: AVAILABLE  Compressed: YES  Tag: INC0_FRI
        Piece Name: /oracle/backup/DB01_1439793859_20130628_tfodbp6i_1_1.inc0_Fri

  List of Archived Logs in backup set 859
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    90      1351681    22-jun-2013 17:42:30 1351714    22-jun-2013 17:43:16
  1    91      1351714    22-jun-2013 17:43:16 1351826    22-jun-2013 17:44:39
  1    92      1351826    22-jun-2013 17:44:39 1351861    22-jun-2013 17:45:22
  1    93      1351861    22-jun-2013 17:45:22 1351958    22-jun-2013 17:46:02
  1    94      1351958    22-jun-2013 17:46:02 1351996    22-jun-2013 17:46:52
  1    95      1351996    22-jun-2013 17:46:52 1386594    23-jun-2013 11:14:04

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
860     1.48M      DISK        00:00:00     28-jun-2013 22:01:57
        BP Key: 860   Status: AVAILABLE  Compressed: YES  Tag: INC0_FRI
        Piece Name: /oracle/backup/DB01_1439793859_20130628_tgodbp6l_1_1.inc0_Fri

  List of Archived Logs in backup set 860
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    96      1386594    23-jun-2013 11:14:04 1386656    23-jun-2013 11:14:59
  1    97      1386656    23-jun-2013 11:14:59 1386846    23-jun-2013 11:15:52
  1    98      1386846    23-jun-2013 11:15:52 1387089    23-jun-2013 11:21:53
  1    99      1387089    23-jun-2013 11:21:53 1387121    23-jun-2013 11:22:42
  1    100     1387121    23-jun-2013 11:22:42 1390442    23-jun-2013 13:34:48
  1    101     1390442    23-jun-2013 13:34:48 1390476    23-jun-2013 13:35:25
  1    102     1390476    23-jun-2013 13:35:25 1390885    23-jun-2013 13:47:06
  1    103     1390885    23-jun-2013 13:47:06 1390921    23-jun-2013 13:47:49

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
861     6.95M      DISK        00:00:01     28-jun-2013 22:01:59
        BP Key: 861   Status: AVAILABLE  Compressed: YES  Tag: INC0_FRI
        Piece Name: /oracle/backup/DB01_1439793859_20130628_thodbp6m_1_1.inc0_Fri

  List of Archived Logs in backup set 861
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    104     1390921    23-jun-2013 13:47:49 1391006    23-jun-2013 13:48:47
  1    105     1391006    23-jun-2013 13:48:47 1391034    23-jun-2013 13:49:23
  1    106     1391034    23-jun-2013 13:49:23 1397432    23-jun-2013 16:13:40
  1    107     1397432    23-jun-2013 16:13:40 1397462    23-jun-2013 16:14:22
  1    108     1397462    23-jun-2013 16:14:22 1397656    23-jun-2013 16:17:59
  1    109     1397656    23-jun-2013 16:17:59 1397695    23-jun-2013 16:19:10
  1    110     1397695    23-jun-2013 16:19:10 1397815    23-jun-2013 16:20:15
  1    111     1397815    23-jun-2013 16:20:15 1397853    23-jun-2013 16:21:16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
862     9.19M      DISK        00:00:02     28-jun-2013 22:02:03
        BP Key: 862   Status: AVAILABLE  Compressed: YES  Tag: INC0_FRI
        Piece Name: /oracle/backup/DB01_1439793859_20130628_tiodbp6p_1_1.inc0_Fri

  List of Archived Logs in backup set 862
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    112     1397853    23-jun-2013 16:21:16 1398226    23-jun-2013 16:35:17
  1    113     1398226    23-jun-2013 16:35:17 1398247    23-jun-2013 16:35:32
  1    114     1398247    23-jun-2013 16:35:32 1423648    24-jun-2013 08:13:39
  1    115     1423648    24-jun-2013 08:13:39 1450863    28-jun-2013 17:52:16
  1    116     1450863    28-jun-2013 17:52:16 1471023    28-jun-2013 20:55:14
  1    117     1471023    28-jun-2013 20:55:14 1471238    28-jun-2013 20:58:24
  1    118     1471238    28-jun-2013 20:58:24 1471271    28-jun-2013 20:59:17
  1    119     1471271    28-jun-2013 20:59:17 1471466    28-jun-2013 21:03:46

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
863     1.31M      DISK        00:00:00     28-jun-2013 22:02:05
        BP Key: 863   Status: AVAILABLE  Compressed: YES  Tag: INC0_FRI
        Piece Name: /oracle/backup/DB01_1439793859_20130628_tjodbp6t_1_1.inc0_Fri

  List of Archived Logs in backup set 863
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    120     1471466    28-jun-2013 21:03:46 1471508    28-jun-2013 21:05:00
  1    121     1471508    28-jun-2013 21:05:00 1471606    28-jun-2013 21:05:48
  1    122     1471606    28-jun-2013 21:05:48 1471703    28-jun-2013 21:07:03
  1    123     1471703    28-jun-2013 21:07:03 1471832    28-jun-2013 21:09:18
  1    124     1471832    28-jun-2013 21:09:18 1471874    28-jun-2013 21:10:19
  1    125     1471874    28-jun-2013 21:10:19 1471940    28-jun-2013 21:10:44
  1    126     1471940    28-jun-2013 21:10:44 1472320    28-jun-2013 21:11:27
  1    127     1472320    28-jun-2013 21:11:27 1472806    28-jun-2013 21:30:06

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
864     5.44M      DISK        00:00:00     28-jun-2013 22:02:06
        BP Key: 864   Status: AVAILABLE  Compressed: YES  Tag: INC0_FRI
        Piece Name: /oracle/backup/DB01_1439793859_20130628_tkodbp6u_1_1.inc0_Fri

  List of Archived Logs in backup set 864
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    128     1472806    28-jun-2013 21:30:06 1472858    28-jun-2013 21:30:38
  1    129     1472858    28-jun-2013 21:30:38 1472879    28-jun-2013 21:30:55
  1    130     1472879    28-jun-2013 21:30:55 1473684    28-jun-2013 21:57:32
  1    131     1473684    28-jun-2013 21:57:32 1473722    28-jun-2013 21:58:34
  1    132     1473722    28-jun-2013 21:58:34 1473801    28-jun-2013 21:59:35
  1    133     1473801    28-jun-2013 21:59:35 1474126    28-jun-2013 22:00:05
  1    134     1474126    28-jun-2013 22:00:05 1476611    28-jun-2013 22:01:37

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
875     41.00K     DISK        00:00:00     28-jun-2013 22:03:09
        BP Key: 875   Status: AVAILABLE  Compressed: YES  Tag: INC0_FRI
        Piece Name: /oracle/backup/DB01_1439793859_20130628_tvodbp8t_1_1.inc0_Fri

  List of Archived Logs in backup set 875
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    135     1476611    28-jun-2013 22:01:37 1476657    28-jun-2013 22:03:08

RMAN> recover database until sequence 136;

Starting recover at 02-jul-2013 06:08:54
using channel ORA_DISK_1
using channel ORA_DISK_2
datafile 6 not processed because file is read-only
datafile 7 not processed because file is read-only

starting media recovery

archived log for thread 1 with sequence 135 is already on disk as file /oracle/flashrecovery/LAX_DB01/archivelog/2013_06_28/o1_mf_1_135_8wwtndz2_.arc
archived log file name=/oracle/flashrecovery/LAX_DB01/archivelog/2013_06_28/o1_mf_1_135_8wwtndz2_.arc thread=1 sequence=135
media recovery complete, elapsed time: 00:00:01
Finished recover at 02-jul-2013 06:08:57

RMAN> alter database open resetlogs;

database opened

RMAN>
About these ads

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 302 other followers

%d bloggers like this: