1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Problem recovering archive logs - RMAN-06025, RMAN-06102

Discussion in 'Security, Backup and Recovery' started by General Franco, Jul 17, 2012.

  1. General Franco

    General Franco Active Member

    Messages:
    22
    Likes Received:
    1
    Trophy Points:
    90
    Hi. I'm getting the following errors when running an archive log restore command. I'm using the control file rather than the RMAN catalog. It's an 11.2.0.2 DB. Any ideas?

    Many thanks for any advice.





    RMAN> run {
    2> SET ARCHIVELOG DESTINATION TO '/arch01/TESTDB1/arch';
    3> RESTORE ARCHIVELOG ALL;
    4> }

    executing command: SET ARCHIVELOG DESTINATION
    using target database control file instead of recovery catalog

    Starting restore at 17-JUL-12
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=5 device type=DISK

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 07/17/2012 09:41:34
    RMAN-06026: some targets not found - aborting restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 208 and starting SCN of 9668998969097 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 207 and starting SCN of 9668998967135 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 24 and starting SCN of 422232 found to restore
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 206 and starting SCN of 9668998967123
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 205 and starting SCN of 9668998967106
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 204 and starting SCN of 9668998964981
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 203 and starting SCN of 9668998962975
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 202 and starting SCN of 9668998960932
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 201 and starting SCN of 9668998958992
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 200 and starting SCN of 9668998956911
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 199 and starting SCN of 9668998954896
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 198 and starting SCN of 9668998952866
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 197 and starting SCN of 9668998950898
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 196 and starting SCN of 9668998950889
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 195 and starting SCN of 9668998950848
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 194 and starting SCN of 9668998948708
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 193 and starting SCN of 9668998946700
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 192 and starting SCN of 9668998944692
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 191 and starting SCN of 9668998942747
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 190 and starting SCN of 9668998940657
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 189 and starting SCN of 9668998938718
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 188 and starting SCN of 9668998936624
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 187 and starting SCN of 9668998934541
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 186 and starting SCN of 9668998934531
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 185 and starting SCN of 9668998932448
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 184 and starting SCN of 9668998930500
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 183 and starting SCN of 9668998928302
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 182 and starting SCN of 9668998926351
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 181 and starting SCN of 9668998924184
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 180 and starting SCN of 9668998922230
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 179 and starting SCN of 9668998920065
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 178 and starting SCN of 9668998918065
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 177 and starting SCN of 9668998915802
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 176 and starting SCN of 9668998913836
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 175 and starting SCN of 9668998911659
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 174 and starting SCN of 9668998909717
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 173 and starting SCN of 9668998906532
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 172 and starting SCN of 9668998904461
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 171 and starting SCN of 9668998902395
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 170 and starting SCN of 9668998900419
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 169 and starting SCN of 9668998900410
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 168 and starting SCN of 9668998898159
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 167 and starting SCN of 9668998896100
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 166 and starting SCN of 9668998894060
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 165 and starting SCN of 9668998892030
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 164 and starting SCN of 9668998887826
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 163 and starting SCN of 9668998885878
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 162 and starting SCN of 9668998883722
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 161 and starting SCN of 9668998881736
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 160 and starting SCN of 9668998881725
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 159 and starting SCN of 9668998879512
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 158 and starting SCN of 9668998877563
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 157 and starting SCN of 9668998875393
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 156 and starting SCN of 9668998873335
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 155 and starting SCN of 9668998869910
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 154 and starting SCN of 9668998867829
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 153 and starting SCN of 9668998865743
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 152 and starting SCN of 9668998862802
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 151 and starting SCN of 9668998862793
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 150 and starting SCN of 9668998862690
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 149 and starting SCN of 9668998860541
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 148 and starting SCN of 9668998858604
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 147 and starting SCN of 9668998856481
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 146 and starting SCN of 9668998854519
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 145 and starting SCN of 9668998850537
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 144 and starting SCN of 9668998848579
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 143 and starting SCN of 9668998846417
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 142 and starting SCN of 9668998844312
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 141 and starting SCN of 9668998844303
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 140 and starting SCN of 9668998842209
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 139 and starting SCN of 9668998840149
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 138 and starting SCN of 9668998838071
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 137 and starting SCN of 9668998836113
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 136 and starting SCN of 9668998831344
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 135 and starting SCN of 9668998829322
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 134 and starting SCN of 9668998827296
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 133 and starting SCN of 9668998825289
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 132 and starting SCN of 9668998825279
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 131 and starting SCN of 9668998823281
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 130 and starting SCN of 9668998821431
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 129 and starting SCN of 9668998819314
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 128 and starting SCN of 9668998817354
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 127 and starting SCN of 9668998815184
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 126 and starting SCN of 9668998813221
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 125 and starting SCN of 9668998810966
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 124 and starting SCN of 9668998808764
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 123 and starting SCN of 9668998808647
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 122 and starting SCN of 9668998806330
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 121 and starting SCN of 9668998804382
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 120 and starting SCN of 9668998802210
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 119 and starting SCN of 9668998800267
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 118 and starting SCN of 9668998796476
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 117 and starting SCN of 9668998794397
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 116 and starting SCN of 9668998792362
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 115 and starting SCN of 9668998790374
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 114 and starting SCN of 9668998790363
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 113 and starting SCN of 9668998790351
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 112 and starting SCN of 9668998788087
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 111 and starting SCN of 9668998785995
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 110 and starting SCN of 9668998783949
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 109 and starting SCN of 9668998781892
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 108 and starting SCN of 9668998778197
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 107 and starting SCN of 9668998776253
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 106 and starting SCN of 9668998774111
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 105 and starting SCN of 9668998771989
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 104 and starting SCN of 9668998771980
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 103 and starting SCN of 9668998771909
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 102 and starting SCN of 9668998769856
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 101 and starting SCN of 9668998767898
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 100 and starting SCN of 9668998765752
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 99 and starting SCN of 9668998763664
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 98 and starting SCN of 9668998759736
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 97 and starting SCN of 9668998757794
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 96 and starting SCN of 9668998755558
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 95 and starting SCN of 9668998753566
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 94 and starting SCN of 9668998753556
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 93 and starting SCN of 9668998749571
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 92 and starting SCN of 9668998747625
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 91 and starting SCN of 9668998745435
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 90 and starting SCN of 9668998743367
    RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 89 and starting SCN of 9668998739221
    RMAN-00567: Recovery Manager could not print some error messages
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    I expect that you haven't increased control_file_record_keep_time from its default value of 7 and I also suspect these archivelogs are older than the 7 day limit. You cannot restore what you have no record of thus the errors at the start of the script. The other logs are likely not found in a backupset on disk thus the second set of errors about no channel for a restore operation.

    You need to use a catalog to restore these archivelogs; you can do it no other way.
     
  3. General Franco

    General Franco Active Member

    Messages:
    22
    Likes Received:
    1
    Trophy Points:
    90
    Hi. Thanks for the reply. I understand what you're saying and yes the controlfile_record_keep_time is set to the default but the control file itself was part of the original backup. I'm restoring this control file first before mounting the DB .. therefor it should have all the info.
     
  4. General Franco

    General Franco Active Member

    Messages:
    22
    Likes Received:
    1
    Trophy Points:
    90
    Thanks for the reply David. The control file was part of the backup that I'm restoring from. I restore the control file first before mounting the DB and restoring the datafiles. Then I try to restore the archive logs to the correct location before attempting a restore .. but I just can't get the arch logs restored.
    The control_file_record_keep_time is as you pointed out set to the default (I copy over the spfile file also) .. but since I'm using the backed up control files it should be ok ... right?

    Thanks.
     
  5. General Franco

    General Franco Active Member

    Messages:
    22
    Likes Received:
    1
    Trophy Points:
    90
    Just noticed my own typo ...
    "Then I try to restore the archive logs to the correct location before attempting a RECOVER .. but I just can't get the arch logs restored."
     
  6. General Franco

    General Franco Active Member

    Messages:
    22
    Likes Received:
    1
    Trophy Points:
    90
    This worked for me:

    RESTORE ARCHIVELOG FROM SCN ${SCN};

    Got the SCN with the following:
    select max(NEXT_CHANGE#)-1 n from v$backup_archivelog_details;
     
  7. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Not necessarily -- if you backup the controlfile 'manually' at the start of the backup then it won't contain the required information; if you have auto controlfile backup configured then it will as that will be the last thing in the backup before it completes.