Skip to content
Advertisements

RMAN-06025: no backup of archived log for thread 1 with sequence

When i tried to test the validate archivelog files using rman , It shows following errors.

Database in mount stage.

RMAN> restore archivelog all validate;

Starting restore at 31-AUG-10
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/31/2010 22:07:24
RMAN-06026: some targets not found – aborting restore
RMAN-06025: no backup of archived log for thread 1 with sequence 171 and starting SCN of 3709282 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 170 and starting SCN of 3679505 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 169 and starting SCN of 3652387 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 168 and starting SCN of 3625416 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 167 and starting SCN of 3604154 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 166 and starting SCN of 3589298 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 165 and starting SCN of 3555509 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 164 and starting SCN of 3529461 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 163 and starting SCN of 3507588 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 162 and starting SCN of 3492156 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 161 and starting SCN of 3465574 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 160 and starting SCN of 3435239 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 159 and starting SCN of 3405625 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 158 and starting SCN of 3377158 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 157 and starting SCN of 3348248 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 156 and starting SCN of 3326494 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 155 and starting SCN of 3317149 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 154 and starting SCN of 3278618 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 153 and starting SCN of 3250224 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 152 and starting SCN of 3216117 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 151 and starting SCN of 3192026 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 150 and starting SCN of 3182856 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 149 and starting SCN of 3151576 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 148 and starting SCN of 3130636 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 147 and starting SCN of 3110194 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 146 and starting SCN of 3088359 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 145 and starting SCN of 3047655 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 144 and starting SCN of 3019436 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 143 and starting SCN of 2986647 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 142 and starting SCN of 2964338 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 141 and starting SCN of 2951686 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 140 and starting SCN of 2921236 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 139 and starting SCN of 2898469 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 138 and starting SCN of 2882299 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 137 and starting SCN of 2846145 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 136 and starting SCN of 2823076 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 135 and starting SCN of 2797568 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 134 and starting SCN of 2776014 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 133 and starting SCN of 2754783 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 132 and starting SCN of 2722946 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 131 and starting SCN of 2691062 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 130 and starting SCN of 2670482 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 129 and starting SCN of 2658786 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 128 and starting SCN of 2626592 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 127 and starting SCN of 2605511 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 126 and starting SCN of 2592171 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 125 and starting SCN of 2571042 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 124 and starting SCN of 2553751 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 123 and starting SCN of 2515571 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 122 and starting SCN of 2486471 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 121 and starting SCN of 2451401 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 120 and starting SCN of 2418851 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 119 and starting SCN of 2382607 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 118 and starting SCN of 2356092 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 117 and starting SCN of 2321831 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 116 and starting SCN of 2301728 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 115 and starting SCN of 2278153 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 114 and starting SCN of 2252731 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 113 and starting SCN of 2234269 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 112 and starting SCN of 2211440 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 111 and starting SCN of 2179088 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 110 and starting SCN of 2153325 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 109 and starting SCN of 2127317 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 108 and starting SCN of 2100895 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 107 and starting SCN of 2074132 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 106 and starting SCN of 2040703 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 105 and starting SCN of 2013057 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 104 and starting SCN of 1996708 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 103 and starting SCN of 1965702 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 102 and starting SCN of 1937541 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 101 and starting SCN of 1908149 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 100 and starting SCN of 1882257 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 99 and starting SCN of 1857140 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 98 and starting SCN of 1818717 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 97 and starting SCN of 1793468 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 96 and starting SCN of 1762243 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 95 and starting SCN of 1730809 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 94 and starting SCN of 1696341 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 93 and starting SCN of 1669601 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 92 and starting SCN of 1644524 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 91 and starting SCN of 1622311 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 90 and starting SCN of 1597648 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 89 and starting SCN of 1562727 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 88 and starting SCN of 1525719 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 87 and starting SCN of 1490745 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86 and starting SCN of 1462723 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 85 and starting SCN of 1432580 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 84 and starting SCN of 1404044 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 83 and starting SCN of 1376784 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 82 and starting SCN of 1348841 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 81 and starting SCN of 1323473 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 80 and starting SCN of 1293085 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 79 and starting SCN of 1263759 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 78 and starting SCN of 1236889 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 77 and starting SCN of 1211496 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 76 and starting SCN of 1184992 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 75 and starting SCN of 1148510 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 74 and starting SCN of 1117984 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 73 and starting SCN of 1088051 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 72 and starting SCN of 1057677 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 71 and starting SCN of 1031110 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 70 and starting SCN of 1003274 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 69 and starting SCN of 971649 found to restore

So that I checked the log sequence staus using sql plus.

SQL> select sequence#,status from v$archived_log;

 SEQUENCE# S
———- –
        69 D
        70 D
        71 D
        72 D
        73 D
        74 D
        75 D
        76 D
        77 D
        78 D
        79 D

 SEQUENCE# S
———- –
        80 D
        81 D
        82 D
        83 D
        84 D
        85 D
        86 D
        87 D
        88 D
        89 D
        90 D

 SEQUENCE# S
———- –
        91 D
        92 D
        93 D
        94 D
        95 D
        96 D
        97 D
        98 D
        99 D
       100 D
       101 D

 SEQUENCE# S
———- –
       102 D
       103 D
       104 D
       105 D
       106 D
       107 D
       108 D
       109 D
       110 D
       111 D
       112 D

 SEQUENCE# S
———- –
       113 D
       114 D
       115 D
       116 D
       117 D
       118 D
       119 D
       120 D
       121 D
       122 D
       123 D

 SEQUENCE# S
———- –
       124 D
       125 D
       126 D
       127 D
       128 D
       129 D
       130 D
       131 D
       132 D
       133 D
       134 D

 SEQUENCE# S
———- –
       135 D
       136 D
       137 D
       138 D
       139 D
       140 D
       141 D
       142 D
       143 D
       144 D
       145 D

 SEQUENCE# S
———- –
       146 D
       147 D
       148 D
       149 D
       150 D
       151 D
       152 D
       153 D
       154 D
       155 D
       156 D

 SEQUENCE# S
———- –
       157 D
       158 D
       159 D
       160 D
       161 D
       162 D
       163 D
       164 D
       165 D
       166 D
       167 D

 SEQUENCE# S
———- –
       168 D
       169 D
       170 D
       171 D
       172 D
       173 D
       174 D
       175 D
       176 D
       177 D
       178 D

 SEQUENCE# S
———- –
       179 D
       180 D
       181 D
       182 D
       183 D
       184 D
       185 D
       186 D
       187 D
       188 D
       189 D

 SEQUENCE# S
———- –
       190 D
       191 D
       192 D
       193 D
       194 D
       195 D
       196 D
       197 D
       198 D
       199 D
       200 D

 SEQUENCE# S
———- –
       201 D
       202 D
       203 D
       204 D
       205 D
       206 D
       207 D
       208 D
       209 D
       210 D
       211 D

 SEQUENCE# S
———- –
       212 D
       213 D
       214 D
       215 D
       216 D
       217 D
       218 D
       219 D
       220 A
       221 A
       222 A

 SEQUENCE# S
———- –
       223 A
       224 A
       225 A
       226 A
       227 A
       228 A

160 rows selected.

SQL>

It shows the log sequence was deleted from 69 to 219.It may be deleted like manually by OS or crosschecked when those log sequence expired .

You can see here

RMAN> list archivelog all;

List of Archived Log Copies for database with db_unique_name AZAR
=====================================================================

Key     Thrd Seq     S Low Time
——- —- ——- – ———
152     1    220     A 25-AUG-10
        Name: C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_25\O1_MF_1_220_67BS362G_.ARC

153     1    221     A 25-AUG-10
        Name: C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_27\O1_MF_1_221_67J390NN_.ARC

154     1    222     A 27-AUG-10
        Name: C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_28\O1_MF_1_222_67LFPL34_.ARC

155     1    223     A 28-AUG-10
        Name: C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_29\O1_MF_1_223_67MF6M67_.ARC

156     1    224     A 29-AUG-10
        Name: C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_29\O1_MF_1_224_67O2495F_.ARC

157     1    225     A 29-AUG-10
        Name: C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_29\O1_MF_1_225_67OKFOTO_.ARC

158     1    226     A 29-AUG-10
        Name: C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_30\O1_MF_1_226_67QP6OFQ_.ARC

159     1    227     A 30-AUG-10
        Name: C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_31\O1_MF_1_227_67TK110L_.ARC

160     1    228     A 31-AUG-10
        Name: C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_31\O1_MF_1_228_67TK9NMW_.ARC

The above command showed which log sequence was backedup.So you can use to restore from those logs.

RMAN> restore  validate check logical archivelog from sequence 220;

Starting restore at 31-AUG-10
using channel ORA_DISK_1

channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_25\O1_MF_1_220_67BS362G_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_27\O1_MF_1_221_67J390NN_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_28\O1_MF_1_222_67LFPL34_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_29\O1_MF_1_223_67MF6M67_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_29\O1_MF_1_224_67O2495F_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_29\O1_MF_1_225_67OKFOTO_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_30\O1_MF_1_226_67QP6OFQ_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_31\O1_MF_1_227_67TK110L_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_31\O1_MF_1_228_67TK9NMW_.ARC
Finished restore at 31-AUG-10

The validation was succeeded.

But when I trying to use the first command as database open stage,It doesnot show those deleted files validation.

RMAN> restore  archivelog all validate;

Starting restore at 31-AUG-10
using channel ORA_DISK_1

channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_25\O1_MF_1_220_67BS362G_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_27\O1_MF_1_221_67J390NN_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_28\O1_MF_1_222_67LFPL34_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_29\O1_MF_1_223_67MF6M67_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_29\O1_MF_1_224_67O2495F_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_29\O1_MF_1_225_67OKFOTO_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_30\O1_MF_1_226_67QP6OFQ_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_31\O1_MF_1_227_67TK110L_.ARC
channel ORA_DISK_1: scanning archived log C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\ARCHIVELOG\2010_08_31\O1_MF_1_228_67TK9NMW_.ARC
channel ORA_DISK_1: starting validation of archived log backup set
channel ORA_DISK_1: reading from backup piece C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\BACKUPSET\2010_08_25\O1_MF_ANNNN_TAG20100825T213530_67BRVM5X_.BKP
channel ORA_DISK_1: piece handle=C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\BACKUPSET\2010_08_25\O1_MF_ANNNN_TAG20100825T213530_67BRVM5X_.BKP tag=TAG20100825T21
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:36
channel ORA_DISK_1: starting validation of archived log backup set
channel ORA_DISK_1: reading from backup piece C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\BACKUPSET\2010_08_31\O1_MF_ANNNN_TAG20100831T210420_67TK18GF_.BKP
channel ORA_DISK_1: piece handle=C:\APP\AZAR\FLASH_RECOVERY_AREA\AZAR\BACKUPSET\2010_08_31\O1_MF_ANNNN_TAG20100831T210420_67TK18GF_.BKP tag=TAG20100831T21
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:31
Finished restore at 31-AUG-10

Advertisements
One Comment Post a comment
  1. TuptDordtrere #

    Condivido totalmente verso le idee espresse finora. Continuate similmente.

    October 29, 2012

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

%d bloggers like this: