Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> When does rman backups Archive logs, Rman backups
Pankaj Sharma fu...
post Aug 23 2017, 05:23 AM
Post #1


Newbie
*

Group: Members
Posts: 3
Joined: 29-May 14
From: India,New Delhi
Member No.: 49,661



rolleyes.gif Please help me understand when does rman backups archive logs(without explicitly specified by us to back archivelog in command).

I executed rman level 0 backup below is output(i did not explicitly specified to backup archive logs and in logs it did not specified that it backedup archive logs)

-----------------------------------------------------------------------------------------------------------------------------
RMAN> run
{
allocate channel mychannel device type disk;
backup incremental level 0 database;
}

2> 3> 4> 5>
released channel: ORA_DISK_1
allocated channel: mychannel
channel mychannel: SID=35 device type=DISK

Starting backup at 23-AUG-17
channel mychannel: starting incremental level 0 datafile backup set
channel mychannel: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
channel mychannel: starting piece 1 at 23-AUG-17
channel mychannel: finished piece 1 at 23-AUG-17
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_23/o1_mf_nnnd0_TAG20170823T143144_dstk3t2z_.bkp tag=TAG20170823T143144 comment=NONE
channel mychannel: backup set complete, elapsed time: 00:05:16
channel mychannel: starting incremental level 0 datafile backup set
channel mychannel: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel mychannel: starting piece 1 at 23-AUG-17
channel mychannel: finished piece 1 at 23-AUG-17
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_23/o1_mf_ncsn0_TAG20170823T143144_dstkfrgv_.bkp tag=TAG20170823T143144 comment=NONE
channel mychannel: backup set complete, elapsed time: 00:00:05
Finished backup at 23-AUG-17
released channel: mychannel

RMAN>
-----------------------------------------------------------------------------------------------------------------------------------------





Even I tried full database backup(here too I did not specified to backup archivelogs and it did not showed in logs it it backed by those or not)below are logs

RMAN> run
{
allocate channel mychannel device type disk;
backup database;
}2> 3> 4> 5>

allocated channel: mychannel
channel mychannel: SID=35 device type=DISK

Starting backup at 23-AUG-17
channel mychannel: starting full datafile backup set
channel mychannel: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
channel mychannel: starting piece 1 at 23-AUG-17
channel mychannel: finished piece 1 at 23-AUG-17
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_23/o1_mf_nnndf_TAG20170823T144010_dstkmlrx_.bkp tag=TAG20170823T144010 comment=NONE
channel mychannel: backup set complete, elapsed time: 00:04:45
channel mychannel: starting full datafile backup set
channel mychannel: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel mychannel: starting piece 1 at 23-AUG-17
channel mychannel: finished piece 1 at 23-AUG-17
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_23/o1_mf_ncsnf_TAG20170823T144010_dstkwlxx_.bkp tag=TAG20170823T144010 comment=NONE
channel mychannel: backup set complete, elapsed time: 00:00:02
Finished backup at 23-AUG-17
released channel: mychannel

RMAN>

----------------------------------------------------------------------------------------------------------------------------------------------------------


Go to the top of the page
 
+Quote Post
burleson
post Aug 23 2017, 11:33 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,532
Joined: 26-January 04
Member No.: 13



Hi Pankaj, and welcome to the forum!

RMAN will backup redo logs under many circumstances!

Please read:

http://www.dba-oracle.com/t_rman_32_backup...o_log_files.htm

Good luck!


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Pankaj Sharma fu...
post Aug 25 2017, 05:40 AM
Post #3


Newbie
*

Group: Members
Posts: 3
Joined: 29-May 14
From: India,New Delhi
Member No.: 49,661



QUOTE (burleson @ Aug 23 2017, 12:33 PM) *
Hi Pankaj, and welcome to the forum!

RMAN will backup redo logs under many circumstances!

Please read:

http://www.dba-oracle.com/t_rman_32_backup...o_log_files.htm

Good luck!


Hi Donald ,

Thanks a lot for prompt reply,

Your post helped me dive deep into investigation. :-)

I know that it is standard/good practice to specify rman to take backup of archive logs explicitly(by rman commnad backup ....PLUS ARCHIVELOG)But I just want to know will rman take backup of archive logs if not asked explicitly to do so .


Donald ,I just want to know if not specified explicitly in rman command will rman backup archive logs (say command is "Backup incremental level 0 database;" or "Backup incremental level 1 database;")

Please check some logs below
---------------------------------




#######===========================Checking for all archive logs Before backup===========================#######


17:31:36 SQL> select recid, stamp, sequence#, name from v$archived_log;

RECID STAMP SEQUENCE# NAME
---------- ---------- ---------- ----------------------------------------------------------------------------------------------------
1 952781904 58
2 952781910 59
3 952781918 60
4 952781925 61
5 952781931 62
6 952781936 63
7 952781942 64
8 952781946 65
9 952781952 66
10 952781959 67
11 952781965 68
12 952781972 69
13 952781978 70
14 952781984 71
15 952781990 72
16 952781996 73
17 952782007 74
18 952782015 75
19 952782024 76
20 952782032 77
21 952782040 78
22 952782045 79
23 952782061 80
24 952782067 81
25 952783055 82
26 952783102 83
27 952783788 84
28 952783801 85
29 952783818 86
30 952783831 87
31 952783845 88
32 952783859 89
33 952783874 90
34 952783901 91
35 952783916 92
36 952783928 93
37 952783938 94
38 952783949 95
39 952783971 96
40 952783991 97
41 952784010 98
42 952784026 99
43 952784046 100
44 952784059 101
45 952784082 102
46 952784100 103
47 952784133 104
48 952784149 105
49 952784168 106
50 952784190 107
51 952786681 108
52 952786683 109
53 952786693 110
54 952786699 111
55 952786715 112
56 952786723 113
57 952786733 114
58 952786740 115
59 952786749 116
60 952786763 117
61 952786780 118
62 952786794 119
63 952786807 120
64 952786820 121
65 952786839 122
66 952786852 123
67 952786870 124
68 952786890 125
69 952786913 126
70 952786925 127
71 952786938 128
72 952786951 129
73 952786960 130
74 952786970 131
75 952786989 132
76 952788148 133
77 952788148 134
78 952788151 135
79 952788152 136
80 952788469 137
81 952788945 138
82 952881451 139 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2017_08_24/o1_mf_1_139_dsxh6m1s_.arc
83 952881817 140 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2017_08_24/o1_mf_1_140_dsxhl1c1_.arc
84 952881853 141 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2017_08_24/o1_mf_1_141_dsxhm59x_.arc

84 rows selected.


#######===========================Now checking in Rman what all archive logs were backed up===========================#######


RMAN> list backup of archivelog all;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
12 1.16G DISK 00:01:42 23-AUG-17
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20170823T152749
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_23/o1_mf_annnn_TAG20170823T152749_dstndykq_.bkp

List of Archived Logs in backup set 12
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 108 1137321 23-AUG-17 1139121 23-AUG-17
1 109 1139121 23-AUG-17 1139254 23-AUG-17
1 110 1139254 23-AUG-17 1139327 23-AUG-17
1 111 1139327 23-AUG-17 1139367 23-AUG-17
1 112 1139367 23-AUG-17 1139418 23-AUG-17
1 113 1139418 23-AUG-17 1139469 23-AUG-17
1 114 1139469 23-AUG-17 1139520 23-AUG-17
1 115 1139520 23-AUG-17 1139577 23-AUG-17
1 116 1139577 23-AUG-17 1139634 23-AUG-17
1 117 1139634 23-AUG-17 1139688 23-AUG-17
1 118 1139688 23-AUG-17 1139754 23-AUG-17
1 119 1139754 23-AUG-17 1139823 23-AUG-17
1 120 1139823 23-AUG-17 1139882 23-AUG-17
1 121 1139882 23-AUG-17 1139936 23-AUG-17
1 122 1139936 23-AUG-17 1139996 23-AUG-17
1 123 1139996 23-AUG-17 1140050 23-AUG-17
1 124 1140050 23-AUG-17 1140112 23-AUG-17
1 125 1140112 23-AUG-17 1140176 23-AUG-17
1 126 1140176 23-AUG-17 1140230 23-AUG-17
1 127 1140230 23-AUG-17 1140294 23-AUG-17
1 128 1140294 23-AUG-17 1140354 23-AUG-17
1 129 1140354 23-AUG-17 1140408 23-AUG-17
1 130 1140408 23-AUG-17 1140458 23-AUG-17
1 131 1140458 23-AUG-17 1140497 23-AUG-17
1 132 1140497 23-AUG-17 1140531 23-AUG-17
1 133 1140531 23-AUG-17 1141417 23-AUG-17
1 134 1141417 23-AUG-17 1141420 23-AUG-17
1 135 1141420 23-AUG-17 1141423 23-AUG-17
1 136 1141423 23-AUG-17 1141426 23-AUG-17
1 137 1141426 23-AUG-17 1141618 23-AUG-17

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
15 1.98M DISK 00:00:00 23-AUG-17
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20170823T153545
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_23/o1_mf_annnn_TAG20170823T153545_dstnvt2f_.bkp

List of Archived Logs in backup set 15
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 138 1141618 23-AUG-17 1142178 23-AUG-17

#######===========================Now Started new backup===========================#######
RMAN> run
{
allocate channel mychannel24 device type disk;
backup incremental level 0 database;
}2> 3> 4> 5>

allocated channel: mychannel24
channel mychannel24: SID=47 device type=DISK

Starting backup at 24-AUG-17
channel mychannel24: starting incremental level 0 datafile backup set
channel mychannel24: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
channel mychannel24: starting piece 1 at 24-AUG-17
channel mychannel24: finished piece 1 at 24-AUG-17
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_24/o1_mf_nnnd0_TAG20170824T172804_dsxhtfm6_.bkp tag=TAG20170824T172804 comment=NONE
channel mychannel24: backup set complete, elapsed time: 00:04:57
channel mychannel24: starting incremental level 0 datafile backup set
channel mychannel24: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel mychannel24: starting piece 1 at 24-AUG-17
channel mychannel24: finished piece 1 at 24-AUG-17
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_24/o1_mf_ncsn0_TAG20170824T172804_dsxj3tkc_.bkp tag=TAG20170824T172804 comment=NONE
channel mychannel24: backup set complete, elapsed time: 00:00:01
Finished backup at 24-AUG-17
released channel: mychannel24

RMAN> exit


Recovery Manager complete.
[ORACLE@localhost ~]$

#######===========check archive logs backed up by rman after successfull level 0 backup===============#######



Recovery Manager complete.
[ORACLE@localhost ~]$ date
Thu Aug 24 17:38:59 IST 2017
[ORACLE@localhost ~]$ rman target /;

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Aug 24 17:39:02 2017

Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1479754737)

RMAN> list backup of archivelog all;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
12 1.16G DISK 00:01:42 23-AUG-17
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20170823T152749
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_23/o1_mf_annnn_TAG20170823T152749_dstndykq_.bkp

List of Archived Logs in backup set 12
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 108 1137321 23-AUG-17 1139121 23-AUG-17
1 109 1139121 23-AUG-17 1139254 23-AUG-17
1 110 1139254 23-AUG-17 1139327 23-AUG-17
1 111 1139327 23-AUG-17 1139367 23-AUG-17
1 112 1139367 23-AUG-17 1139418 23-AUG-17
1 113 1139418 23-AUG-17 1139469 23-AUG-17
1 114 1139469 23-AUG-17 1139520 23-AUG-17
1 115 1139520 23-AUG-17 1139577 23-AUG-17
1 116 1139577 23-AUG-17 1139634 23-AUG-17
1 117 1139634 23-AUG-17 1139688 23-AUG-17
1 118 1139688 23-AUG-17 1139754 23-AUG-17
1 119 1139754 23-AUG-17 1139823 23-AUG-17
1 120 1139823 23-AUG-17 1139882 23-AUG-17
1 121 1139882 23-AUG-17 1139936 23-AUG-17
1 122 1139936 23-AUG-17 1139996 23-AUG-17
1 123 1139996 23-AUG-17 1140050 23-AUG-17
1 124 1140050 23-AUG-17 1140112 23-AUG-17
1 125 1140112 23-AUG-17 1140176 23-AUG-17
1 126 1140176 23-AUG-17 1140230 23-AUG-17
1 127 1140230 23-AUG-17 1140294 23-AUG-17
1 128 1140294 23-AUG-17 1140354 23-AUG-17
1 129 1140354 23-AUG-17 1140408 23-AUG-17
1 130 1140408 23-AUG-17 1140458 23-AUG-17
1 131 1140458 23-AUG-17 1140497 23-AUG-17
1 132 1140497 23-AUG-17 1140531 23-AUG-17
1 133 1140531 23-AUG-17 1141417 23-AUG-17
1 134 1141417 23-AUG-17 1141420 23-AUG-17
1 135 1141420 23-AUG-17 1141423 23-AUG-17
1 136 1141423 23-AUG-17 1141426 23-AUG-17
1 137 1141426 23-AUG-17 1141618 23-AUG-17

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
15 1.98M DISK 00:00:00 23-AUG-17
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20170823T153545
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_23/o1_mf_annnn_TAG20170823T153545_dstnvt2f_.bkp

List of Archived Logs in backup set 15
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 138 1141618 23-AUG-17 1142178 23-AUG-17

RMAN> exit

############===================Now Checking again for all backedup archive logs after backup====================################

17:33:33 SQL> set time on
17:33:48 SQL> select recid, stamp, sequence#, name from v$archived_log;

RECID STAMP SEQUENCE# NAME
---------- ---------- ---------- ----------------------------------------------------------------------------------------------------
1 952781904 58
2 952781910 59
3 952781918 60
4 952781925 61
5 952781931 62
6 952781936 63
7 952781942 64
8 952781946 65
9 952781952 66
10 952781959 67
11 952781965 68
12 952781972 69
13 952781978 70
14 952781984 71
15 952781990 72
16 952781996 73
17 952782007 74
18 952782015 75
19 952782024 76
20 952782032 77
21 952782040 78
22 952782045 79
23 952782061 80
24 952782067 81
25 952783055 82
26 952783102 83
27 952783788 84
28 952783801 85
29 952783818 86
30 952783831 87
31 952783845 88
32 952783859 89
33 952783874 90
34 952783901 91
35 952783916 92
36 952783928 93
37 952783938 94
38 952783949 95
39 952783971 96
40 952783991 97
41 952784010 98
42 952784026 99
43 952784046 100
44 952784059 101
45 952784082 102
46 952784100 103
47 952784133 104
48 952784149 105
49 952784168 106
50 952784190 107
51 952786681 108
52 952786683 109
53 952786693 110
54 952786699 111
55 952786715 112
56 952786723 113
57 952786733 114
58 952786740 115
59 952786749 116
60 952786763 117
61 952786780 118
62 952786794 119
63 952786807 120
64 952786820 121
65 952786839 122
66 952786852 123
67 952786870 124
68 952786890 125
69 952786913 126
70 952786925 127
71 952786938 128
72 952786951 129
73 952786960 130
74 952786970 131
75 952786989 132
76 952788148 133
77 952788148 134
78 952788151 135
79 952788152 136
80 952788469 137
81 952788945 138
82 952881451 139 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2017_08_24/o1_mf_1_139_dsxh6m1s_.arc
83 952881817 140 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2017_08_24/o1_mf_1_140_dsxhl1c1_.arc
84 952881853 141 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2017_08_24/o1_mf_1_141_dsxhm59x_.arc

84 rows selected.



$$$$$$$$$$$$$$$$$$$$$$ MORAL -from logs above it seems that rman will only backup archive logs if asked to do so explicitly .



Go to the top of the page
 
+Quote Post
Pankaj Sharma fu...
post Aug 25 2017, 05:42 AM
Post #4


Newbie
*

Group: Members
Posts: 3
Joined: 29-May 14
From: India,New Delhi
Member No.: 49,661



QUOTE (burleson @ Aug 23 2017, 12:33 PM) *
Hi Pankaj, and welcome to the forum!

RMAN will backup redo logs under many circumstances!

Please read:

http://www.dba-oracle.com/t_rman_32_backup...o_log_files.htm

Good luck!


Hi Donald ,

Thanks a lot for prompt reply,

Your post helped me dive deep into investigation. :-)

I know that it is standard/good practice to specify rman to take backup of archive logs explicitly(by rman commnad backup ....PLUS ARCHIVELOG)But I just want to know will rman take backup of archive logs if not asked explicitly to do so .


Donald ,I just want to know if not specified explicitly in rman command will rman backup archive logs (say command is "Backup incremental level 0 database;" or "Backup incremental level 1 database;")

Please check some logs below
---------------------------------




#######===========================Checking for all archive logs Before backup===========================#######


17:31:36 SQL> select recid, stamp, sequence#, name from v$archived_log;

RECID STAMP SEQUENCE# NAME
---------- ---------- ---------- ----------------------------------------------------------------------------------------------------
1 952781904 58
2 952781910 59
3 952781918 60
4 952781925 61
5 952781931 62
6 952781936 63
7 952781942 64
8 952781946 65
9 952781952 66
10 952781959 67
11 952781965 68
12 952781972 69
13 952781978 70
14 952781984 71
15 952781990 72
16 952781996 73
17 952782007 74
18 952782015 75
19 952782024 76
20 952782032 77
21 952782040 78
22 952782045 79
23 952782061 80
24 952782067 81
25 952783055 82
26 952783102 83
27 952783788 84
28 952783801 85
29 952783818 86
30 952783831 87
31 952783845 88
32 952783859 89
33 952783874 90
34 952783901 91
35 952783916 92
36 952783928 93
37 952783938 94
38 952783949 95
39 952783971 96
40 952783991 97
41 952784010 98
42 952784026 99
43 952784046 100
44 952784059 101
45 952784082 102
46 952784100 103
47 952784133 104
48 952784149 105
49 952784168 106
50 952784190 107
51 952786681 108
52 952786683 109
53 952786693 110
54 952786699 111
55 952786715 112
56 952786723 113
57 952786733 114
58 952786740 115
59 952786749 116
60 952786763 117
61 952786780 118
62 952786794 119
63 952786807 120
64 952786820 121
65 952786839 122
66 952786852 123
67 952786870 124
68 952786890 125
69 952786913 126
70 952786925 127
71 952786938 128
72 952786951 129
73 952786960 130
74 952786970 131
75 952786989 132
76 952788148 133
77 952788148 134
78 952788151 135
79 952788152 136
80 952788469 137
81 952788945 138
82 952881451 139 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2017_08_24/o1_mf_1_139_dsxh6m1s_.arc
83 952881817 140 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2017_08_24/o1_mf_1_140_dsxhl1c1_.arc
84 952881853 141 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2017_08_24/o1_mf_1_141_dsxhm59x_.arc

84 rows selected.


#######===========================Now checking in Rman what all archive logs were backed up===========================#######


RMAN> list backup of archivelog all;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
12 1.16G DISK 00:01:42 23-AUG-17
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20170823T152749
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_23/o1_mf_annnn_TAG20170823T152749_dstndykq_.bkp

List of Archived Logs in backup set 12
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 108 1137321 23-AUG-17 1139121 23-AUG-17
1 109 1139121 23-AUG-17 1139254 23-AUG-17
1 110 1139254 23-AUG-17 1139327 23-AUG-17
1 111 1139327 23-AUG-17 1139367 23-AUG-17
1 112 1139367 23-AUG-17 1139418 23-AUG-17
1 113 1139418 23-AUG-17 1139469 23-AUG-17
1 114 1139469 23-AUG-17 1139520 23-AUG-17
1 115 1139520 23-AUG-17 1139577 23-AUG-17
1 116 1139577 23-AUG-17 1139634 23-AUG-17
1 117 1139634 23-AUG-17 1139688 23-AUG-17
1 118 1139688 23-AUG-17 1139754 23-AUG-17
1 119 1139754 23-AUG-17 1139823 23-AUG-17
1 120 1139823 23-AUG-17 1139882 23-AUG-17
1 121 1139882 23-AUG-17 1139936 23-AUG-17
1 122 1139936 23-AUG-17 1139996 23-AUG-17
1 123 1139996 23-AUG-17 1140050 23-AUG-17
1 124 1140050 23-AUG-17 1140112 23-AUG-17
1 125 1140112 23-AUG-17 1140176 23-AUG-17
1 126 1140176 23-AUG-17 1140230 23-AUG-17
1 127 1140230 23-AUG-17 1140294 23-AUG-17
1 128 1140294 23-AUG-17 1140354 23-AUG-17
1 129 1140354 23-AUG-17 1140408 23-AUG-17
1 130 1140408 23-AUG-17 1140458 23-AUG-17
1 131 1140458 23-AUG-17 1140497 23-AUG-17
1 132 1140497 23-AUG-17 1140531 23-AUG-17
1 133 1140531 23-AUG-17 1141417 23-AUG-17
1 134 1141417 23-AUG-17 1141420 23-AUG-17
1 135 1141420 23-AUG-17 1141423 23-AUG-17
1 136 1141423 23-AUG-17 1141426 23-AUG-17
1 137 1141426 23-AUG-17 1141618 23-AUG-17

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
15 1.98M DISK 00:00:00 23-AUG-17
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20170823T153545
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_23/o1_mf_annnn_TAG20170823T153545_dstnvt2f_.bkp

List of Archived Logs in backup set 15
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 138 1141618 23-AUG-17 1142178 23-AUG-17

#######===========================Now Started new backup===========================#######
RMAN> run
{
allocate channel mychannel24 device type disk;
backup incremental level 0 database;
}2> 3> 4> 5>

allocated channel: mychannel24
channel mychannel24: SID=47 device type=DISK

Starting backup at 24-AUG-17
channel mychannel24: starting incremental level 0 datafile backup set
channel mychannel24: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
channel mychannel24: starting piece 1 at 24-AUG-17
channel mychannel24: finished piece 1 at 24-AUG-17
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_24/o1_mf_nnnd0_TAG20170824T172804_dsxhtfm6_.bkp tag=TAG20170824T172804 comment=NONE
channel mychannel24: backup set complete, elapsed time: 00:04:57
channel mychannel24: starting incremental level 0 datafile backup set
channel mychannel24: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel mychannel24: starting piece 1 at 24-AUG-17
channel mychannel24: finished piece 1 at 24-AUG-17
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_24/o1_mf_ncsn0_TAG20170824T172804_dsxj3tkc_.bkp tag=TAG20170824T172804 comment=NONE
channel mychannel24: backup set complete, elapsed time: 00:00:01
Finished backup at 24-AUG-17
released channel: mychannel24

RMAN> exit


Recovery Manager complete.
[ORACLE@localhost ~]$

#######===========check archive logs backed up by rman after successfull level 0 backup===============#######



Recovery Manager complete.
[ORACLE@localhost ~]$ date
Thu Aug 24 17:38:59 IST 2017
[ORACLE@localhost ~]$ rman target /;

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Aug 24 17:39:02 2017

Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1479754737)

RMAN> list backup of archivelog all;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
12 1.16G DISK 00:01:42 23-AUG-17
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20170823T152749
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_23/o1_mf_annnn_TAG20170823T152749_dstndykq_.bkp

List of Archived Logs in backup set 12
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 108 1137321 23-AUG-17 1139121 23-AUG-17
1 109 1139121 23-AUG-17 1139254 23-AUG-17
1 110 1139254 23-AUG-17 1139327 23-AUG-17
1 111 1139327 23-AUG-17 1139367 23-AUG-17
1 112 1139367 23-AUG-17 1139418 23-AUG-17
1 113 1139418 23-AUG-17 1139469 23-AUG-17
1 114 1139469 23-AUG-17 1139520 23-AUG-17
1 115 1139520 23-AUG-17 1139577 23-AUG-17
1 116 1139577 23-AUG-17 1139634 23-AUG-17
1 117 1139634 23-AUG-17 1139688 23-AUG-17
1 118 1139688 23-AUG-17 1139754 23-AUG-17
1 119 1139754 23-AUG-17 1139823 23-AUG-17
1 120 1139823 23-AUG-17 1139882 23-AUG-17
1 121 1139882 23-AUG-17 1139936 23-AUG-17
1 122 1139936 23-AUG-17 1139996 23-AUG-17
1 123 1139996 23-AUG-17 1140050 23-AUG-17
1 124 1140050 23-AUG-17 1140112 23-AUG-17
1 125 1140112 23-AUG-17 1140176 23-AUG-17
1 126 1140176 23-AUG-17 1140230 23-AUG-17
1 127 1140230 23-AUG-17 1140294 23-AUG-17
1 128 1140294 23-AUG-17 1140354 23-AUG-17
1 129 1140354 23-AUG-17 1140408 23-AUG-17
1 130 1140408 23-AUG-17 1140458 23-AUG-17
1 131 1140458 23-AUG-17 1140497 23-AUG-17
1 132 1140497 23-AUG-17 1140531 23-AUG-17
1 133 1140531 23-AUG-17 1141417 23-AUG-17
1 134 1141417 23-AUG-17 1141420 23-AUG-17
1 135 1141420 23-AUG-17 1141423 23-AUG-17
1 136 1141423 23-AUG-17 1141426 23-AUG-17
1 137 1141426 23-AUG-17 1141618 23-AUG-17

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
15 1.98M DISK 00:00:00 23-AUG-17
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20170823T153545
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2017_08_23/o1_mf_annnn_TAG20170823T153545_dstnvt2f_.bkp

List of Archived Logs in backup set 15
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 138 1141618 23-AUG-17 1142178 23-AUG-17

RMAN> exit

############===================Now Checking again for all backedup archive logs after backup====================################

17:33:33 SQL> set time on
17:33:48 SQL> select recid, stamp, sequence#, name from v$archived_log;

RECID STAMP SEQUENCE# NAME
---------- ---------- ---------- ----------------------------------------------------------------------------------------------------
1 952781904 58
2 952781910 59
3 952781918 60
4 952781925 61
5 952781931 62
6 952781936 63
7 952781942 64
8 952781946 65
9 952781952 66
10 952781959 67
11 952781965 68
12 952781972 69
13 952781978 70
14 952781984 71
15 952781990 72
16 952781996 73
17 952782007 74
18 952782015 75
19 952782024 76
20 952782032 77
21 952782040 78
22 952782045 79
23 952782061 80
24 952782067 81
25 952783055 82
26 952783102 83
27 952783788 84
28 952783801 85
29 952783818 86
30 952783831 87
31 952783845 88
32 952783859 89
33 952783874 90
34 952783901 91
35 952783916 92
36 952783928 93
37 952783938 94
38 952783949 95
39 952783971 96
40 952783991 97
41 952784010 98
42 952784026 99
43 952784046 100
44 952784059 101
45 952784082 102
46 952784100 103
47 952784133 104
48 952784149 105
49 952784168 106
50 952784190 107
51 952786681 108
52 952786683 109
53 952786693 110
54 952786699 111
55 952786715 112
56 952786723 113
57 952786733 114
58 952786740 115
59 952786749 116
60 952786763 117
61 952786780 118
62 952786794 119
63 952786807 120
64 952786820 121
65 952786839 122
66 952786852 123
67 952786870 124
68 952786890 125
69 952786913 126
70 952786925 127
71 952786938 128
72 952786951 129
73 952786960 130
74 952786970 131
75 952786989 132
76 952788148 133
77 952788148 134
78 952788151 135
79 952788152 136
80 952788469 137
81 952788945 138
82 952881451 139 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2017_08_24/o1_mf_1_139_dsxh6m1s_.arc
83 952881817 140 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2017_08_24/o1_mf_1_140_dsxhl1c1_.arc
84 952881853 141 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2017_08_24/o1_mf_1_141_dsxhm59x_.arc

84 rows selected.



$$$$$$$$$$$$$$$$$$$$$$ MORAL -from logs above it seems that rman will only backup archive logs if asked to do so explicitly .



Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd September 2017 - 10:15 PM