This discussion is archived
9 Replies Latest reply: Oct 24, 2013 7:58 PM by Lonion RSS

Why it automatically recover current redo log in RMAN command window?

Lonion Newbie
Currently Being Moderated

Firstly, I restore controlfile and datafiles from a backupset.

 

Then when I recover database in RMAN command window like below:

 

RMAN> recover database;

 

 

Starting recover at 15-AUG-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=156 devtype=DISK

 

 

starting media recovery

 

 

archive log thread 1 sequence 9 is already on disk as file /u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_9_90sd0slz_.arc

archive log thread 1 sequence 10 is already on disk as file

 

 

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_10_90sd0tsb_.arc

archive log thread 1 sequence 11 is already on disk as file

 

 

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_11_90sd110b_.arc

archive log thread 1 sequence 12 is already on disk as file

 

 

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_12_90sd2ksr_.arc

archive log thread 1 sequence 13 is already on disk as file

 

 

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_13_90sd2mc6_.arc

archive log thread 1 sequence 14 is already on disk as file

 

 

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_14_90sd2qrm_.arc

archive log thread 1 sequence 15 is already on disk as file

 

 

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_15_90sd2s0w_.arc

archive log thread 1 sequence 16 is already on disk as file /u01/app/oracle/oradata/lonion/redo03.log

archive log filename=/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_9_90sd0slz_.arc thread=1 sequence=9

archive log filename=/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_10_90sd0tsb_.arc thread=1 sequence=10

archive log filename=/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_11_90sd110b_.arc thread=1 sequence=11

archive log filename=/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_12_90sd2ksr_.arc thread=1 sequence=12

archive log filename=/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_13_90sd2mc6_.arc thread=1 sequence=13

archive log filename=/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_14_90sd2qrm_.arc thread=1 sequence=14

archive log filename=/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_15_90sd2s0w_.arc thread=1 sequence=15

archive log filename=/u01/app/oracle/oradata/lonion/redo03.log thread=1 sequence=16

media recovery complete, elapsed time: 00:00:04

Finished recover at 15-AUG-13

RMAN>

 

 

 

But, when I recover database in SQL*Plus command window like below:

 

[oracle@lonion ~]$ uniread sqlplus /nolog

[uniread] Loaded history (2178 lines)

 

 

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 15 19:25:38 2013

 

 

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

 

 

SQL> conn /as sysdba

Connected.

SQL>

SQL> recover database;

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

 

 

 

 

SQL> recover database using backup controlfile;

ORA-00279: change 2147842454 generated at 08/15/2013 18:34:28 needed for thread

1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_9_%u_.a

rc

ORA-00280: change 2147842454 for thread 1 is in sequence #9

 

 

 

 

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 2147842651 generated at 08/15/2013 18:40:25 needed for thread

1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_10_%u_.

arc

ORA-00280: change 2147842651 for thread 1 is in sequence #10

ORA-00278: log file

'/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_9_90sd

0slz_.arc' no longer needed for this recovery

 

 

 

 

ORA-00279: change 2147842653 generated at 08/15/2013 18:40:26 needed for thread

1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_11_%u_.

arc

ORA-00280: change 2147842653 for thread 1 is in sequence #11

ORA-00278: log file

'/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_10_90s

d0tsb_.arc' no longer needed for this recovery

 

 

 

 

ORA-00279: change 2147842656 generated at 08/15/2013 18:40:32 needed for thread

1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_12_%u_.

arc

ORA-00280: change 2147842656 for thread 1 is in sequence #12

ORA-00278: log file

'/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_11_90s

d110b_.arc' no longer needed for this recovery

 

 

 

 

ORA-00279: change 2147842684 generated at 08/15/2013 18:41:21 needed for thread

1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_13_%u_.

arc

ORA-00280: change 2147842684 for thread 1 is in sequence #13

ORA-00278: log file

'/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_12_90s

d2ksr_.arc' no longer needed for this recovery

 

 

 

 

ORA-00279: change 2147842686 generated at 08/15/2013 18:41:23 needed for thread

1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_14_%u_.

arc

ORA-00280: change 2147842686 for thread 1 is in sequence #14

ORA-00278: log file

'/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_13_90s

d2mc6_.arc' no longer needed for this recovery

 

 

 

 

ORA-00279: change 2147842689 generated at 08/15/2013 18:41:27 needed for thread

1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_15_%u_.

arc

ORA-00280: change 2147842689 for thread 1 is in sequence #15

ORA-00278: log file

'/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_14_90s

d2qrm_.arc' no longer needed for this recovery

 

 

 

 

ORA-00279: change 2147842691 generated at 08/15/2013 18:41:28 needed for thread

1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_16_%u_.

arc

ORA-00280: change 2147842691 for thread 1 is in sequence #16

ORA-00278: log file

'/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_15_90s

g0or9_.arc' no longer needed for this recovery

 

 

 

 

ORA-00279: change 2147842986 generated at 08/15/2013 19:14:29 needed for thread

1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_17_%u_.

arc

ORA-00280: change 2147842986 for thread 1 is in sequence #17

ORA-00278: log file

'/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_16_90s

g0os5_.arc' no longer needed for this recovery

 

 

 

 

ORA-00308: cannot open archived log

'/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_17_%u_

.arc'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

 

 

SQL> recover database using backup controlfile;

ORA-00279: change 2147842986 generated at 08/15/2013 19:14:29 needed for thread

1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/LONION/archivelog/2013_08_15/o1_mf_1_17_%u_.

arc

ORA-00280: change 2147842986 for thread 1 is in sequence #17

 

 

 

 

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/u01/app/oracle/oradata/lonion/redo01.log        ---- Yon see, proceeding this process, it can't automatically apply the current redo log.

Log applied.

Media recovery complete.

SQL>

 

 

Question Coming:

 

Now, my question is that 「Why it automatically recover current redo log in RMAN command window but not in SQL*Plus」?

 

BTW: Please pay attention to the red font.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points