Friday, 26 July 2019

Rman Backup database plus archivelog sequences Execution


The execution will be as follows:

1. Run an ALTER SYSTEM ARCHIVE LOG CURRENT statement

2. Run the BACKUP ARCHIVELOG ALL command

3. Back up the files specified in the BACKUPcommand

4. Run an ALTER SYSTEM ARCHIVE LOG CURRENT statement

5. Back up any remaining archived redo log files


 RMAN> backup database plus archivelog;


Starting backup at 26-JUL-19
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=86 instance=rac1 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=2 sequence=171 RECID=344 STAMP=1013984588
input archived log thread=1 sequence=179 RECID=342 STAMP=1013984560
input archived log thread=1 sequence=180 RECID=343 STAMP=1013984587
input archived log thread=1 sequence=181 RECID=345 STAMP=1013988631
input archived log thread=2 sequence=172 RECID=346 STAMP=1014018988
input archived log thread=1 sequence=182 RECID=347 STAMP=1014024631
input archived log thread=2 sequence=173 RECID=348 STAMP=1014057043
input archived log thread=1 sequence=183 RECID=349 STAMP=1014060610
input archived log thread=2 sequence=174 RECID=350 STAMP=1014069771
input archived log thread=1 sequence=184 RECID=351 STAMP=1014071046
input archived log thread=2 sequence=175 RECID=353 STAMP=1014078641
input archived log thread=1 sequence=185 RECID=352 STAMP=1014075035
input archived log thread=1 sequence=186 RECID=356 STAMP=1014104600
input archived log thread=2 sequence=176 RECID=354 STAMP=1014098518
input archived log thread=2 sequence=177 RECID=355 STAMP=1014104598
input archived log thread=2 sequence=178 RECID=357 STAMP=1014118213
input archived log thread=1 sequence=187 RECID=359 STAMP=1014139825
input archived log thread=2 sequence=179 RECID=358 STAMP=1014127420
input archived log thread=2 sequence=180 RECID=360 STAMP=1014141828
input archived log thread=1 sequence=188 RECID=362 STAMP=1014157547
input archived log thread=2 sequence=181 RECID=361 STAMP=1014156252
input archived log thread=2 sequence=182 RECID=364 STAMP=1014179432
input archived log thread=1 sequence=189 RECID=363 STAMP=1014161450
input archived log thread=1 sequence=190 RECID=366 STAMP=1014197456
input archived log thread=2 sequence=183 RECID=365 STAMP=1014184966
input archived log thread=2 sequence=184 RECID=367 STAMP=1014199604
input archived log thread=1 sequence=191 RECID=370 STAMP=1014228510
channel ORA_DISK_1: starting piece 1 at 26-JUL-19
channel ORA_DISK_1: finished piece 1 at 26-JUL-19
piece handle=/u01/Backup/ora_df1014640728_s121_s1 tag=TAG20190726T123846 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:16
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=2 sequence=185 RECID=368 STAMP=1014214097
input archived log thread=2 sequence=186 RECID=369 STAMP=1014228507
input archived log thread=2 sequence=187 RECID=371 STAMP=1014242973
input archived log thread=1 sequence=192 RECID=373 STAMP=1014260983
input archived log thread=2 sequence=188 RECID=372 STAMP=1014255018
input archived log thread=2 sequence=189 RECID=374 STAMP=1014291025
input archived log thread=1 sequence=193 RECID=375 STAMP=1014296469
input archived log thread=2 sequence=190 RECID=376 STAMP=1014306867
input archived log thread=1 sequence=194 RECID=377 STAMP=1014306868
input archived log thread=1 sequence=195 RECID=378 STAMP=1014307115
input archived log thread=2 sequence=191 RECID=379 STAMP=1014307116
input archived log thread=2 sequence=192 RECID=380 STAMP=1014307117
input archived log thread=1 sequence=196 RECID=381 STAMP=1014307123
input archived log thread=2 sequence=193 RECID=382 STAMP=1014307125
input archived log thread=2 sequence=194 RECID=383 STAMP=1014307126
input archived log thread=1 sequence=197 RECID=384 STAMP=1014310985
input archived log thread=2 sequence=195 RECID=385 STAMP=1014313363
input archived log thread=1 sequence=198 RECID=387 STAMP=1014313375
input archived log thread=2 sequence=196 RECID=386 STAMP=1014313370
input archived log thread=1 sequence=199 RECID=389 STAMP=1014315028
input archived log thread=2 sequence=197 RECID=388 STAMP=1014315028
input archived log thread=2 sequence=198 RECID=390 STAMP=1014316005
input archived log thread=1 sequence=200 RECID=391 STAMP=1014316010
input archived log thread=1 sequence=201 RECID=393 STAMP=1014321086
input archived log thread=2 sequence=199 RECID=392 STAMP=1014321085
input archived log thread=2 sequence=200 RECID=394 STAMP=1014321094
input archived log thread=1 sequence=202 RECID=395 STAMP=1014321095
input archived log thread=1 sequence=203 RECID=396 STAMP=1014321790
input archived log thread=2 sequence=201 RECID=398 STAMP=1014376807
input archived log thread=1 sequence=204 RECID=397 STAMP=1014376802
input archived log thread=2 sequence=202 RECID=399 STAMP=1014376811
input archived log thread=1 sequence=205 RECID=401 STAMP=1014376824
input archived log thread=2 sequence=203 RECID=400 STAMP=1014376823
input archived log thread=2 sequence=204 RECID=402 STAMP=1014376826
input archived log thread=1 sequence=206 RECID=403 STAMP=1014377286
input archived log thread=1 sequence=207 RECID=404 STAMP=1014409819
input archived log thread=1 sequence=208 RECID=405 STAMP=1014415384
input archived log thread=1 sequence=209 RECID=406 STAMP=1014435037
input archived log thread=1 sequence=210 RECID=407 STAMP=1014469488
input archived log thread=1 sequence=211 RECID=408 STAMP=1014483011
input archived log thread=2 sequence=205 RECID=410 STAMP=1014483020
input archived log thread=1 sequence=212 RECID=409 STAMP=1014483015
input archived log thread=2 sequence=206 RECID=411 STAMP=1014483780
input archived log thread=2 sequence=207 RECID=412 STAMP=1014483784
input archived log thread=1 sequence=213 RECID=414 STAMP=1014483796
input archived log thread=2 sequence=208 RECID=413 STAMP=1014483795
input archived log thread=2 sequence=209 RECID=415 STAMP=1014483797
input archived log thread=1 sequence=214 RECID=416 STAMP=1014487307
input archived log thread=2 sequence=210 RECID=417 STAMP=1014487314
input archived log thread=1 sequence=215 RECID=418 STAMP=1014487316
input archived log thread=2 sequence=211 RECID=419 STAMP=1014491334
input archived log thread=1 sequence=216 RECID=420 STAMP=1014491339
input archived log thread=1 sequence=217 RECID=422 STAMP=1014491348
input archived log thread=2 sequence=212 RECID=421 STAMP=1014491346
input archived log thread=2 sequence=213 RECID=423 STAMP=1014501726
input archived log thread=1 sequence=218 RECID=425 STAMP=1014525034
input archived log thread=2 sequence=214 RECID=424 STAMP=1014503924
input archived log thread=2 sequence=215 RECID=426 STAMP=1014539421
input archived log thread=1 sequence=219 RECID=427 STAMP=1014563397
input archived log thread=2 sequence=216 RECID=428 STAMP=1014563406
input archived log thread=2 sequence=217 RECID=429 STAMP=1014563411
input archived log thread=1 sequence=220 RECID=430 STAMP=1014563412
input archived log thread=1 sequence=221 RECID=432 STAMP=1014577234
input archived log thread=2 sequence=218 RECID=431 STAMP=1014574197
channel ORA_DISK_1: starting piece 1 at 26-JUL-19
channel ORA_DISK_1: finished piece 1 at 26-JUL-19
piece handle=/u01/Backup/ora_df1014640805_s122_s1 tag=TAG20190726T123846 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=2 sequence=219 RECID=435 STAMP=1014588134
input archived log thread=1 sequence=222 RECID=433 STAMP=1014577239
input archived log thread=1 sequence=223 RECID=434 STAMP=1014588132
input archived log thread=1 sequence=224 RECID=436 STAMP=1014588320
input archived log thread=2 sequence=220 RECID=437 STAMP=1014615026
input archived log thread=1 sequence=225 RECID=438 STAMP=1014622210
input archived log thread=2 sequence=221 RECID=440 STAMP=1014640268
input archived log thread=1 sequence=226 RECID=439 STAMP=1014640265
input archived log thread=1 sequence=227 RECID=442 STAMP=1014640378
input archived log thread=2 sequence=222 RECID=441 STAMP=1014640375
input archived log thread=2 sequence=223 RECID=444 STAMP=1014640403
input archived log thread=1 sequence=228 RECID=443 STAMP=1014640399
input archived log thread=1 sequence=229 RECID=446 STAMP=1014640411
input archived log thread=2 sequence=224 RECID=445 STAMP=1014640409
input archived log thread=2 sequence=225 RECID=448 STAMP=1014640425
input archived log thread=1 sequence=230 RECID=447 STAMP=1014640423
input archived log thread=1 sequence=231 RECID=449 STAMP=1014640436
input archived log thread=2 sequence=226 RECID=450 STAMP=1014640437
input archived log thread=1 sequence=232 RECID=452 STAMP=1014640646
input archived log thread=2 sequence=227 RECID=451 STAMP=1014640645
input archived log thread=2 sequence=228 RECID=453 STAMP=1014640719
input archived log thread=1 sequence=233 RECID=454 STAMP=1014640721
channel ORA_DISK_1: starting piece 1 at 26-JUL-19
channel ORA_DISK_1: finished piece 1 at 26-JUL-19
piece handle=/u01/Backup/ora_df1014640863_s123_s1 tag=TAG20190726T123846 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 26-JUL-19

Starting backup at 26-JUL-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/RAC/DATAFILE/sysaux.257.1011959959
input datafile file number=00001 name=+DATA/RAC/DATAFILE/system.258.1011960053
input datafile file number=00004 name=+DATA/RAC/DATAFILE/undotbs1.260.1011960171
input datafile file number=00005 name=+DATA/RAC/DATAFILE/undotbs2.265.1011960859
input datafile file number=00006 name=+DATA/RAC/DATAFILE/users.259.1011960169
channel ORA_DISK_1: starting piece 1 at 26-JUL-19
channel ORA_DISK_1: finished piece 1 at 26-JUL-19
piece handle=/u01/Backup/ora_df1014640890_s124_s1 tag=TAG20190726T124129 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:46
Finished backup at 26-JUL-19

Starting backup at 26-JUL-19
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=2 sequence=229 RECID=456 STAMP=1014641118
input archived log thread=1 sequence=234 RECID=455 STAMP=1014641117
channel ORA_DISK_1: starting piece 1 at 26-JUL-19
channel ORA_DISK_1: finished piece 1 at 26-JUL-19
piece handle=/u01/Backup/ora_df1014641121_s125_s1 tag=TAG20190726T124521 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JUL-19

Starting Control File and SPFILE Autobackup at 26-JUL-19
piece handle=+FRA/RAC/AUTOBACKUP/2019_07_26/s_1014641124.322.1014641127 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JUL-19

RMAN>

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)