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

1 Comment »

  1. Working as a team, these specialists would then offer a customized back pain management plan to suit the patient’s condition,
    severity and medical history. With effective breathing, there would be an inducement of relaxation response in your
    parasympathetic nervous system and that response can help to further relieve back pain and muscle tension. ‘ If you remember to do all these things on a daily basis, your back
    will thank you for it.

    Comment by ปวดหลัง — September 2, 2014 @ 10:05 am | Reply


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. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 300 other followers

%d bloggers like this: