Oracle 11g 053 课程 使用 RMAN 创建备份
MAN> CONFIGURE BACKUP OPTIMIZATION CLEAR;
old RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
RMAN configuration parameters are successfully reset to default value
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN> backup as backupset format '/home/oracle/users.bkp' tablespace users;
Starting backup at 22-OCT-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=36 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1016595405
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=/home/oracle/users.bkp tag=TAG20191022T085217 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
RMAN>
[[email protected] app]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Oct 22 08:55:26 2019
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1544376304)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN> backup tablespace users;
Starting backup at 22-OCT-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=36 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1016595405
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t085550_0.264.1022316951 tag=TAG20191022T085550 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
RMAN>
RMAN> backup as copy format '/home/oracle/userscp.bkp' tablespace users;
Starting backup at 22-OCT-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1016595405
output file name=/home/oracle/userscp.bkp tag=TAG20191022T085909 RECID=2 STAMP=1022317151
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
RMAN> backup spfile;
Starting backup at 22-OCT-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=68 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnsnf0_tag20191022t090229_0.265.1022317349 tag=TAG20191022T090229 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 22-OCT-19
RMAN> backup as copy tablespace users;
Starting backup at 22-OCT-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1016595405
output file name=+FRA/orcl/datafile/users.266.1022317457 tag=TAG20191022T090415 RECID=3 STAMP=1022317457
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
RMAN>
RMAN> backup current controlfile;
Starting backup at 22-OCT-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
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/ncnnf0_tag20191022t090641_0.267.1022317603 tag=TAG20191022T090641 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 22-OCT-19
Last login: Tue Oct 22 07:48:27 2019 from 192.168.142.1
[[email protected] ~]# su - oracle
[[email protected] ~]$ . oraenv
ORACLE_SID = [oracle] ? orcl
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[[email protected] ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Oct 22 16:35:33 2019
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1544376304)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN> backup datafile 4;
Starting backup at 22-OCT-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=45 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1016595405
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t163648_0.270.1022344609 tag=TAG20191022T163648 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 22-OCT-19
Starting Control File and SPFILE Autobackup at 22-OCT-19
piece handle=+FRA/orcl/autobackup/2019_10_22/s_1022344612.271.1022344615 comment=NONE
Finished Control File and SPFILE Autobackup at 22-OCT-19
RMAN>
RMAN> backup incremental level 0 datafile 1 ;
Starting backup at 22-OCT-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1016595403
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndn0_tag20191022t164317_0.272.1022344999 tag=TAG20191022T164317 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:47
Finished backup at 22-OCT-19
Starting Control File and SPFILE Autobackup at 22-OCT-19
piece handle=+FRA/orcl/autobackup/2019_10_22/s_1022345105.273.1022345107 comment=NONE
Finished Control File and SPFILE Autobackup at 22-OCT-19
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN> backup incremental level 1 datafile 1 ;
Starting backup at 22-OCT-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1016595403
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndn1_tag20191022t164608_0.274.1022345169 tag=TAG20191022T164608 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/ncsnn1_tag20191022t164608_0.275.1022345197 tag=TAG20191022T164608 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
RMAN>
RMAN> backup incremental level 1 cumulative datafile 1 ;
Starting backup at 22-OCT-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1016595403
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndn1_tag20191022t164826_0.276.1022345307 tag=TAG20191022T164826 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/ncsnn1_tag20191022t164826_0.277.1022345335 tag=TAG20191022T164826 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 22-OCT-19
RMAN>
-------------
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 3.34M DISK 00:00:05 21-OCT-19
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20191021T065357
Piece Name: +FRA/orcl/backupset/2019_10_21/nnndf0_tag20191021t065357_0.260.1022223239
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1173590 21-OCT-19 +DATA/orcl/datafile/users.259.1016595405
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 3.34M DISK 00:00:03 22-OCT-19
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20191022T075242
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t075242_0.261.1022313165
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1186550 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 9.36M DISK 00:00:15 22-OCT-19
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20191022T075247
Piece Name: +FRA/orcl/autobackup/2019_10_22/s_1022313167.262.1022313181
SPFILE Included: Modification time: 20-OCT-19
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1186564 Ckp time: 22-OCT-19
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 3.34M DISK 00:00:02 22-OCT-19
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20191022T081050
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t081050_0.263.1022314251
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1188112 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 3.34M DISK 00:00:01 22-OCT-19
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20191022T082019
Piece Name: /u01/app/user1.bkp
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1188673 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 3.34M DISK 00:00:02 22-OCT-19
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20191022T085217
Piece Name: /home/oracle/users.bkp
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1190335 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 3.34M DISK 00:00:02 22-OCT-19
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20191022T085550
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t085550_0.264.1022316951
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1190495 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 80.00K DISK 00:00:01 22-OCT-19
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20191022T090229
Piece Name: +FRA/orcl/backupset/2019_10_22/nnsnf0_tag20191022t090229_0.265.1022317349
SPFILE Included: Modification time: 20-OCT-19
SPFILE db_unique_name: ORCL
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9 Full 9.33M DISK 00:00:03 22-OCT-19
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20191022T090641
Piece Name: +FRA/orcl/backupset/2019_10_22/ncnnf0_tag20191022t090641_0.267.1022317603
Control File Included: Ckp SCN: 1191497 Ckp time: 22-OCT-19
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Full 3.34M DISK 00:00:02 22-OCT-19
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20191022T090730
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t090730_0.268.1022317651
List of Datafiles in backup set 10
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1191550 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11 Full 72.90M DISK 00:00:12 22-OCT-19
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20191022T091710
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t091710_0.269.1022318231
List of Datafiles in backup set 11
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1192182 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
5 Full 1192182 22-OCT-19 +DATA/orcl/datafile/example.265.1016595663
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12 Full 3.34M DISK 00:00:03 22-OCT-19
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20191022T163648
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t163648_0.270.1022344609
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1193373 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13 Full 9.36M DISK 00:00:05 22-OCT-19
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20191022T163652
Piece Name: +FRA/orcl/autobackup/2019_10_22/s_1022344612.271.1022344615
SPFILE Included: Modification time: 20-OCT-19
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1193379 Ckp time: 22-OCT-19
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14 Incr 0 596.05M DISK 00:01:37 22-OCT-19
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20191022T164317
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndn0_tag20191022t164317_0.272.1022344999
List of Datafiles in backup set 14
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 1193756 22-OCT-19 +DATA/orcl/datafile/system.256.1016595403
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15 Full 9.36M DISK 00:00:02 22-OCT-19
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20191022T164505
Piece Name: +FRA/orcl/autobackup/2019_10_22/s_1022345105.273.1022345107
SPFILE Included: Modification time: 20-OCT-19
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1193823 Ckp time: 22-OCT-19
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16 Incr 1 104.00K DISK 00:00:24 22-OCT-19
BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20191022T164608
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndn1_tag20191022t164608_0.274.1022345169
List of Datafiles in backup set 16
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 1 Incr 1194064 22-OCT-19 +DATA/orcl/datafile/system.256.1016595403
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17 Incr 1 9.36M DISK 00:00:05 22-OCT-19
BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20191022T164608
Piece Name: +FRA/orcl/backupset/2019_10_22/ncsnn1_tag20191022t164608_0.275.1022345197
SPFILE Included: Modification time: 20-OCT-19
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1194091 Ckp time: 22-OCT-19
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18 Incr 1 176.00K DISK 00:00:24 22-OCT-19
BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20191022T164826
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndn1_tag20191022t164826_0.276.1022345307
List of Datafiles in backup set 18
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 1 Incr 1194199 22-OCT-19 +DATA/orcl/datafile/system.256.1016595403
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19 Incr 1 9.36M DISK 00:00:06 22-OCT-19
BP Key: 19 Status: AVAILABLE Compressed: NO Tag: TAG20191022T164826
Piece Name: +FRA/orcl/backupset/2019_10_22/ncsnn1_tag20191022t164826_0.277.1022345335
SPFILE Included: Modification time: 20-OCT-19
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1194210 Ckp time: 22-OCT-19
RMAN>
RMAN> delete backupset
2> ;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1 1 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_21/nnndf0_tag20191021t065357_0.260.1022223239
2 2 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t075242_0.261.1022313165
3 3 1 1 AVAILABLE DISK +FRA/orcl/autobackup/2019_10_22/s_1022313167.262.1022313181
4 4 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t081050_0.263.1022314251
5 5 1 1 AVAILABLE DISK /u01/app/user1.bkp
6 6 1 1 AVAILABLE DISK /home/oracle/users.bkp
7 7 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t085550_0.264.1022316951
8 8 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_22/nnsnf0_tag20191022t090229_0.265.1022317349
9 9 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_22/ncnnf0_tag20191022t090641_0.267.1022317603
10 10 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t090730_0.268.1022317651
11 11 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t091710_0.269.1022318231
12 12 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t163648_0.270.1022344609
13 13 1 1 AVAILABLE DISK +FRA/orcl/autobackup/2019_10_22/s_1022344612.271.1022344615
14 14 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_22/nnndn0_tag20191022t164317_0.272.1022344999
15 15 1 1 AVAILABLE DISK +FRA/orcl/autobackup/2019_10_22/s_1022345105.273.1022345107
16 16 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_22/nnndn1_tag20191022t164608_0.274.1022345169
17 17 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_22/ncsnn1_tag20191022t164608_0.275.1022345197
18 18 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_22/nnndn1_tag20191022t164826_0.276.1022345307
19 19 1 1 AVAILABLE DISK +FRA/orcl/backupset/2019_10_22/ncsnn1_tag20191022t164826_0.277.1022345335
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_21/nnndf0_tag20191021t065357_0.260.1022223239 RECID=1 STAMP=1022223238
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t075242_0.261.1022313165 RECID=2 STAMP=1022313164
deleted backup piece
backup piece handle=+FRA/orcl/autobackup/2019_10_22/s_1022313167.262.1022313181 RECID=3 STAMP=1022313181
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t081050_0.263.1022314251 RECID=4 STAMP=1022314250
deleted backup piece
backup piece handle=/u01/app/user1.bkp RECID=5 STAMP=1022314820
deleted backup piece
backup piece handle=/home/oracle/users.bkp RECID=6 STAMP=1022316738
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t085550_0.264.1022316951 RECID=7 STAMP=1022316950
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnsnf0_tag20191022t090229_0.265.1022317349 RECID=8 STAMP=1022317349
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/ncnnf0_tag20191022t090641_0.267.1022317603 RECID=9 STAMP=1022317602
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t090730_0.268.1022317651 RECID=10 STAMP=1022317651
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t091710_0.269.1022318231 RECID=11 STAMP=1022318231
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t163648_0.270.1022344609 RECID=12 STAMP=1022344609
deleted backup piece
backup piece handle=+FRA/orcl/autobackup/2019_10_22/s_1022344612.271.1022344615 RECID=13 STAMP=1022344615
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndn0_tag20191022t164317_0.272.1022344999 RECID=14 STAMP=1022344998
deleted backup piece
backup piece handle=+FRA/orcl/autobackup/2019_10_22/s_1022345105.273.1022345107 RECID=15 STAMP=1022345106
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndn1_tag20191022t164608_0.274.1022345169 RECID=16 STAMP=1022345169
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/ncsnn1_tag20191022t164608_0.275.1022345197 RECID=17 STAMP=1022345197
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndn1_tag20191022t164826_0.276.1022345307 RECID=18 STAMP=1022345307
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/ncsnn1_tag20191022t164826_0.277.1022345335 RECID=19 STAMP=1022345335
Deleted 19 objects
RMAN> backup datafile 4;
Starting backup at 22-OCT-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=00004 name=+DATA/orcl/datafile/users.259.1016595405
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170458_0.277.1022346299 tag=TAG20191022T170458 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
RMAN> backup backupset all;
Starting backup at 22-OCT-19
using channel ORA_DISK_1
channel ORA_DISK_1: input backup set: count=24, stamp=1022346298, piece=1
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: backup piece +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170458_0.277.1022346299
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_0.276.1022346329 comment=NONE
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
RMAN>
RMAN>
RMAN>
RMAN> exit
Recovery Manager complete.
[[email protected] ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 22 17:08:31 2019
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> alter tablespace users read only;
Tablespace altered.
SQL> exit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[[email protected] ~]$
[[email protected] ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Oct 22 17:09:24 2019
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1544376304)
RMAN> backup tablespace users,example;
Starting backup at 22-OCT-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=60 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1016595663
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1016595405
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170949_0.275.1022346591 tag=TAG20191022T170949 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 22-OCT-19
RMAN>
RMAN> backup tablespace users,example skip readonly;
Starting backup at 22-OCT-19
using channel ORA_DISK_1
skipping read-only file 4
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1016595663
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171049_0.274.1022346651 tag=TAG20191022T171049 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 22-OCT-19
RMAN>
RMAN> exit
Recovery Manager complete.
rlwrap: error: read error on master pty: Input/output error
[[email protected] ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 22 17:16:21 2019
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL>
SQL>
SQL>
SQL> desc v$datafile;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
TS# NUMBER
RFILE# NUMBER
STATUS VARCHAR2(7)
ENABLED VARCHAR2(10)
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
UNRECOVERABLE_CHANGE# NUMBER
UNRECOVERABLE_TIME DATE
LAST_CHANGE# NUMBER
LAST_TIME DATE
OFFLINE_CHANGE# NUMBER
ONLINE_CHANGE# NUMBER
ONLINE_TIME DATE
BYTES NUMBER
BLOCKS NUMBER
CREATE_BYTES NUMBER
BLOCK_SIZE NUMBER
NAME VARCHAR2(513)
PLUGGED_IN NUMBER
BLOCK1_OFFSET NUMBER
AUX_NAME VARCHAR2(513)
FIRST_NONLOGGED_SCN NUMBER
FIRST_NONLOGGED_TIME DATE
FOREIGN_DBID NUMBER
FOREIGN_CREATION_CHANGE# NUMBER
FOREIGN_CREATION_TIME DATE
PLUGGED_READONLY VARCHAR2(3)
PLUGIN_CHANGE# NUMBER
PLUGIN_RESETLOGS_CHANGE# NUMBER
PLUGIN_RESETLOGS_TIME DATE
SQL> select name,file#,bytes/1024/1024 as MB from v$datafile;
NAME
--------------------------------------------------------------------------------
FILE# MB
---------- ----------
+DATA/orcl/datafile/system.256.1016595403
1 690
+DATA/orcl/datafile/sysaux.257.1016595403
2 590
+DATA/orcl/datafile/undotbs1.258.1016595403
3 100
NAME
--------------------------------------------------------------------------------
FILE# MB
---------- ----------
+DATA/orcl/datafile/users.259.1016595405
4 5
+DATA/orcl/datafile/example.265.1016595663
5 100
SQL> set linesize 300;
SQL> set pagesize 300;
SQL> col name format a50;
SQL> select name,file#,bytes/1024/1024 as MB from v$datafile;
NAME FILE# MB
-------------------------------------------------- ---------- ----------
+DATA/orcl/datafile/system.256.1016595403 1 690
+DATA/orcl/datafile/sysaux.257.1016595403 2 590
+DATA/orcl/datafile/undotbs1.258.1016595403 3 100
+DATA/orcl/datafile/users.259.1016595405 4 5
+DATA/orcl/datafile/example.265.1016595663 5 100
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[[email protected] ~]$
[[email protected] ~]$
[[email protected] ~]$
[[email protected] ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Oct 22 17:18:29 2019
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1544376304)
RMAN> backup datafile 1 section size=100M;
Starting backup at 22-OCT-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=62 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1016595403
backing up blocks 1 through 12800
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.273.1022347145 tag=TAG20191022T171903 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1016595403
backing up blocks 12801 through 25600
channel ORA_DISK_1: starting piece 2 at 22-OCT-19
channel ORA_DISK_1: finished piece 2 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.272.1022347169 tag=TAG20191022T171903 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1016595403
backing up blocks 25601 through 38400
channel ORA_DISK_1: starting piece 3 at 22-OCT-19
channel ORA_DISK_1: finished piece 3 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.271.1022347185 tag=TAG20191022T171903 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1016595403
backing up blocks 38401 through 51200
channel ORA_DISK_1: starting piece 4 at 22-OCT-19
channel ORA_DISK_1: finished piece 4 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.270.1022347201 tag=TAG20191022T171903 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1016595403
backing up blocks 51201 through 64000
channel ORA_DISK_1: starting piece 5 at 22-OCT-19
channel ORA_DISK_1: finished piece 5 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.269.1022347225 tag=TAG20191022T171903 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1016595403
backing up blocks 64001 through 76800
channel ORA_DISK_1: starting piece 6 at 22-OCT-19
channel ORA_DISK_1: finished piece 6 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.268.1022347241 tag=TAG20191022T171903 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1016595403
backing up blocks 76801 through 88320
channel ORA_DISK_1: starting piece 7 at 22-OCT-19
channel ORA_DISK_1: finished piece 7 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.267.1022347257 tag=TAG20191022T171903 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/ncsnf0_tag20191022t171903_0.265.1022347267 tag=TAG20191022T171903 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
RMAN>
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN>
RMAN>
RMAN> run{
2> allocate channel c1 device type disk;
3> allocate channel c2 device type disk;
4> backup
5> (datafile 1,3,5 channel c1)
6> (datafile 2,4 channel c2)
7> ;
8> }
released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=62 device type=DISK
allocated channel: c2
channel c2: SID=35 device type=DISK
Starting backup at 22-OCT-19
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1016595403
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.1016595403
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1016595663
channel c1: starting piece 1 at 22-OCT-19
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.1016595403
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1016595405
channel c2: starting piece 1 at 22-OCT-19
channel c2: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t172747_0.264.1022347671 tag=TAG20191022T172747 comment=NONE
channel c2: backup set complete, elapsed time: 00:02:49
channel c1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t172747_0.263.1022347671 tag=TAG20191022T172747 comment=NONE
channel c1: backup set complete, elapsed time: 00:03:01
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel c1: starting piece 1 at 22-OCT-19
channel c1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/ncsnf0_tag20191022t172747_0.262.1022347853 tag=TAG20191022T172747 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
released channel: c1
released channel: c2
RMAN>
RMAN>
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size
------- ---- -- ----------
20 Full 3.34M
List of Datafiles in backup set 20
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1195241 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
Backup Set Copy #1 of backup set 20
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:02 22-OCT-19 NO TAG20191022T170458
List of Backup Pieces for backup set 20 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
20 1 AVAILABLE +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170458_0.277.1022346299
Backup Set Copy #2 of backup set 20
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:02 22-OCT-19 NO TAG20191022T170458
List of Backup Pieces for backup set 20 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
21 1 AVAILABLE +FRA/orcl/backupset/2019_10_22/nnndf0_0.276.1022346329
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
21 Full 72.90M DISK 00:00:14 22-OCT-19
BP Key: 22 Status: AVAILABLE Compressed: NO Tag: TAG20191022T170949
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170949_0.275.1022346591
List of Datafiles in backup set 21
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1195481 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
5 Full 1195538 22-OCT-19 +DATA/orcl/datafile/example.265.1016595663
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22 Full 69.58M DISK 00:00:08 22-OCT-19
BP Key: 23 Status: AVAILABLE Compressed: NO Tag: TAG20191022T171049
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171049_0.274.1022346651
List of Datafiles in backup set 22
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 1195648 22-OCT-19 +DATA/orcl/datafile/example.265.1016595663
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
23 Full 596.29M DISK 00:02:00 22-OCT-19
List of Datafiles in backup set 23
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1196023 22-OCT-19 +DATA/orcl/datafile/system.256.1016595403
Backup Set Copy #1 of backup set 23
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:02:00 22-OCT-19 NO TAG20191022T171903
List of Backup Pieces for backup set 23 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
24 1 AVAILABLE +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.273.1022347145
25 2 AVAILABLE +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.272.1022347169
26 3 AVAILABLE +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.271.1022347185
27 4 AVAILABLE +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.270.1022347201
28 5 AVAILABLE +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.269.1022347225
29 6 AVAILABLE +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.268.1022347241
30 7 AVAILABLE +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.267.1022347257
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
24 Full 9.36M DISK 00:00:04 22-OCT-19
BP Key: 31 Status: AVAILABLE Compressed: NO Tag: TAG20191022T171903
Piece Name: +FRA/orcl/backupset/2019_10_22/ncsnf0_tag20191022t171903_0.265.1022347267
SPFILE Included: Modification time: 20-OCT-19
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1196154 Ckp time: 22-OCT-19
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
25 Full 455.79M DISK 00:02:42 22-OCT-19
BP Key: 32 Status: AVAILABLE Compressed: NO Tag: TAG20191022T172747
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t172747_0.264.1022347671
List of Datafiles in backup set 25
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1196512 22-OCT-19 +DATA/orcl/datafile/sysaux.257.1016595403
4 Full 1195481 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26 Full 669.87M DISK 00:02:56 22-OCT-19
BP Key: 33 Status: AVAILABLE Compressed: NO Tag: TAG20191022T172747
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t172747_0.263.1022347671
List of Datafiles in backup set 26
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1196509 22-OCT-19 +DATA/orcl/datafile/system.256.1016595403
3 Full 1196509 22-OCT-19 +DATA/orcl/datafile/undotbs1.258.1016595403
5 Full 1196509 22-OCT-19 +DATA/orcl/datafile/example.265.1016595663
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27 Full 9.36M DISK 00:00:04 22-OCT-19
BP Key: 34 Status: AVAILABLE Compressed: NO Tag: TAG20191022T172747
Piece Name: +FRA/orcl/backupset/2019_10_22/ncsnf0_tag20191022t172747_0.262.1022347853
SPFILE Included: Modification time: 20-OCT-19
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1196682 Ckp time: 22-OCT-19
RMAN> list backup of datafile 4;
List of Backup Sets
===================
BS Key Type LV Size
------- ---- -- ----------
20 Full 3.34M
List of Datafiles in backup set 20
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1195241 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
Backup Set Copy #1 of backup set 20
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:02 22-OCT-19 NO TAG20191022T170458
List of Backup Pieces for backup set 20 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
20 1 AVAILABLE +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170458_0.277.1022346299
Backup Set Copy #2 of backup set 20
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:02 22-OCT-19 NO TAG20191022T170458
List of Backup Pieces for backup set 20 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
21 1 AVAILABLE +FRA/orcl/backupset/2019_10_22/nnndf0_0.276.1022346329
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
21 Full 72.90M DISK 00:00:14 22-OCT-19
BP Key: 22 Status: AVAILABLE Compressed: NO Tag: TAG20191022T170949
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170949_0.275.1022346591
List of Datafiles in backup set 21
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1195481 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
25 Full 455.79M DISK 00:02:42 22-OCT-19
BP Key: 32 Status: AVAILABLE Compressed: NO Tag: TAG20191022T172747
Piece Name: +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t172747_0.264.1022347671
List of Datafiles in backup set 25
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1195481 22-OCT-19 +DATA/orcl/datafile/users.259.1016595405
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
24 Full 9.36M DISK 00:00:04 22-OCT-19
BP Key: 31 Status: AVAILABLE Compressed: NO Tag: TAG20191022T171903
Piece Name: +FRA/orcl/backupset/2019_10_22/ncsnf0_tag20191022t171903_0.265.1022347267
Control File Included: Ckp SCN: 1196154 Ckp time: 22-OCT-19
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27 Full 9.36M DISK 00:00:04 22-OCT-19
BP Key: 34 Status: AVAILABLE Compressed: NO Tag: TAG20191022T172747
Piece Name: +FRA/orcl/backupset/2019_10_22/ncsnf0_tag20191022t172747_0.262.1022347853
Control File Included: Ckp SCN: 1196682 Ckp time: 22-OCT-19
RMAN>
RMAN> list copy of datafile 4;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - --------------- ---------- ---------------
3 4 A 22-OCT-19 1191396 22-OCT-19
Name: +FRA/orcl/datafile/users.266.1022317457
Tag: TAG20191022T090415
2 4 A 22-OCT-19 1190640 22-OCT-19
Name: /home/oracle/userscp.bkp
Tag: TAG20191022T085909
RMAN>
RMAN>
RMAN> report need backup;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log 2 21-OCT-19 /u01/app/arch11_16_1016595577.dbf
Archive Log 1 21-OCT-19 /home/oracle/arch1_16_1016595577.dbf
Archive Log 4 22-OCT-19 /u01/app/arch11_17_1016595577.dbf
Archive Log 3 22-OCT-19 /home/oracle/arch1_17_1016595577.dbf
Datafile Copy 2 22-OCT-19 /home/oracle/userscp.bkp
Datafile Copy 3 22-OCT-19 +FRA/orcl/datafile/users.266.1022317457
Backup Set 20 22-OCT-19
Backup Piece 20 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170458_0.277.1022346299
Backup Set 20 22-OCT-19
Backup Piece 21 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_0.276.1022346329
Backup Set 21 22-OCT-19
Backup Piece 22 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170949_0.275.1022346591
Backup Set 22 22-OCT-19
Backup Piece 23 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171049_0.274.1022346651
Backup Set 23 22-OCT-19
Backup Piece 30 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.267.1022347257
Backup Set 23 22-OCT-19
Backup Piece 29 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.268.1022347241
Backup Set 23 22-OCT-19
Backup Piece 28 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.269.1022347225
Backup Set 23 22-OCT-19
Backup Piece 27 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.270.1022347201
Backup Set 23 22-OCT-19
Backup Piece 26 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.271.1022347185
Backup Set 23 22-OCT-19
Backup Piece 25 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.272.1022347169
Backup Set 23 22-OCT-19
Backup Piece 24 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.273.1022347145
Backup Set 24 22-OCT-19
Backup Piece 31 22-OCT-19 +FRA/orcl/backupset/2019_10_22/ncsnf0_tag20191022t171903_0.265.1022347267
RMAN>
RMAN>
RMAN>
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 5;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 5;
new RMAN configuration parameters are successfully stored
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 5
no obsolete backups found
RMAN> backup datafile 4;
Starting backup at 22-OCT-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=62 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1016595405
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174559_0.261.1022348759 tag=TAG20191022T174559 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
RMAN> backup datafile 4;
Starting backup at 22-OCT-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=00004 name=+DATA/orcl/datafile/users.259.1016595405
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174609_0.260.1022348771 tag=TAG20191022T174609 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 22-OCT-19
RMAN> backup datafile 4;
Starting backup at 22-OCT-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=00004 name=+DATA/orcl/datafile/users.259.1016595405
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174622_0.278.1022348783 tag=TAG20191022T174622 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
RMAN> backup datafile 4;
Starting backup at 22-OCT-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=00004 name=+DATA/orcl/datafile/users.259.1016595405
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174632_0.279.1022348793 tag=TAG20191022T174632 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
RMAN> backup datafile 4;
Starting backup at 22-OCT-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=00004 name=+DATA/orcl/datafile/users.259.1016595405
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174644_0.280.1022348805 tag=TAG20191022T174644 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
RMAN> backup datafile 4;
Starting backup at 22-OCT-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=00004 name=+DATA/orcl/datafile/users.259.1016595405
channel ORA_DISK_1: starting piece 1 at 22-OCT-19
channel ORA_DISK_1: finished piece 1 at 22-OCT-19
piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174702_0.281.1022348823 tag=TAG20191022T174702 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-OCT-19
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 5
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Datafile Copy 2 22-OCT-19 /home/oracle/userscp.bkp
Datafile Copy 3 22-OCT-19 +FRA/orcl/datafile/users.266.1022317457
Backup Set 20 22-OCT-19
Backup Piece 21 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_0.276.1022346329
Backup Set 20 22-OCT-19
Backup Piece 20 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170458_0.277.1022346299
Backup Set 28 22-OCT-19
Backup Piece 35 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174559_0.261.1022348759
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 5;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored
RMAN>
RMAN> exit
Recovery Manager complete.
[[email protected] ~]$
[[email protected] ~]$
[[email protected] ~]$
[[email protected] ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 22 17:50:16 2019
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> desc v$backup_set;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
SET_STAMP NUMBER
SET_COUNT NUMBER
BACKUP_TYPE VARCHAR2(1)
CONTROLFILE_INCLUDED VARCHAR2(3)
INCREMENTAL_LEVEL NUMBER
PIECES NUMBER
START_TIME DATE
COMPLETION_TIME DATE
ELAPSED_SECONDS NUMBER
BLOCK_SIZE NUMBER
INPUT_FILE_SCAN_ONLY VARCHAR2(3)
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(11)
MULTI_SECTION VARCHAR2(3)
SQL> desc v$backup_files;
Name Null? Type
----------------------------------------- -------- ----------------------------
PKEY NUMBER
BACKUP_TYPE VARCHAR2(32)
FILE_TYPE VARCHAR2(32)
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(13)
STATUS VARCHAR2(16)
FNAME VARCHAR2(1024)
TAG VARCHAR2(32)
MEDIA VARCHAR2(80)
RECID NUMBER
STAMP NUMBER
DEVICE_TYPE VARCHAR2(255)
BLOCK_SIZE NUMBER
COMPLETION_TIME DATE
COMPRESSED VARCHAR2(3)
OBSOLETE VARCHAR2(3)
BYTES NUMBER
BS_KEY NUMBER
BS_COUNT NUMBER
BS_STAMP NUMBER
BS_TYPE VARCHAR2(32)
BS_INCR_TYPE VARCHAR2(32)
BS_PIECES NUMBER
BS_COPIES NUMBER
BS_COMPLETION_TIME DATE
BS_STATUS VARCHAR2(16)
BS_BYTES NUMBER
BS_COMPRESSED VARCHAR2(3)
BS_TAG VARCHAR2(1024)
BS_DEVICE_TYPE VARCHAR2(255)
BP_PIECE# NUMBER
BP_COPY# NUMBER
DF_FILE# NUMBER
DF_TABLESPACE VARCHAR2(30)
DF_RESETLOGS_CHANGE# NUMBER
DF_CREATION_CHANGE# NUMBER
DF_CHECKPOINT_CHANGE# NUMBER
DF_CKP_MOD_TIME DATE
RL_THREAD# NUMBER
RL_SEQUENCE# NUMBER
RL_RESETLOGS_CHANGE# NUMBER
RL_FIRST_CHANGE# NUMBER
RL_FIRST_TIME DATE
RL_NEXT_CHANGE# NUMBER
RL_NEXT_TIME DATE
SQL>
[[email protected] ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Oct 22 17:54:12 2019
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1544376304)
RMAN> crosscheck backupset;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=60 device type=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170458_0.277.1022346299 RECID=20 STAMP=1022346298
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_0.276.1022346329 RECID=21 STAMP=1022346328
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170949_0.275.1022346591 RECID=22 STAMP=1022346590
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171049_0.274.1022346651 RECID=23 STAMP=1022346650
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.273.1022347145 RECID=24 STAMP=1022347143
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.272.1022347169 RECID=25 STAMP=1022347169
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.271.1022347185 RECID=26 STAMP=1022347184
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.270.1022347201 RECID=27 STAMP=1022347200
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.269.1022347225 RECID=28 STAMP=1022347225
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.268.1022347241 RECID=29 STAMP=1022347241
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t171903_0.267.1022347257 RECID=30 STAMP=1022347256
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/ncsnf0_tag20191022t171903_0.265.1022347267 RECID=31 STAMP=1022347267
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t172747_0.264.1022347671 RECID=32 STAMP=1022347671
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t172747_0.263.1022347671 RECID=33 STAMP=1022347671
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/ncsnf0_tag20191022t172747_0.262.1022347853 RECID=34 STAMP=1022347852
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174559_0.261.1022348759 RECID=35 STAMP=1022348759
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174609_0.260.1022348771 RECID=36 STAMP=1022348769
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174622_0.278.1022348783 RECID=37 STAMP=1022348782
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174632_0.279.1022348793 RECID=38 STAMP=1022348792
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174644_0.280.1022348805 RECID=39 STAMP=1022348804
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174702_0.281.1022348823 RECID=40 STAMP=1022348822
Crosschecked 21 objects
RMAN>
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Datafile Copy 2 22-OCT-19 /home/oracle/userscp.bkp
Datafile Copy 3 22-OCT-19 +FRA/orcl/datafile/users.266.1022317457
Backup Set 20 22-OCT-19
Backup Piece 21 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_0.276.1022346329
Backup Set 20 22-OCT-19
Backup Piece 20 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170458_0.277.1022346299
Backup Set 21 22-OCT-19
Backup Piece 22 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170949_0.275.1022346591
Backup Set 28 22-OCT-19
Backup Piece 35 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174559_0.261.1022348759
Backup Set 29 22-OCT-19
Backup Piece 36 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174609_0.260.1022348771
Backup Set 30 22-OCT-19
Backup Piece 37 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174622_0.278.1022348783
Backup Set 31 22-OCT-19
Backup Piece 38 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174632_0.279.1022348793
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Datafile Copy 2 22-OCT-19 /home/oracle/userscp.bkp
Datafile Copy 3 22-OCT-19 +FRA/orcl/datafile/users.266.1022317457
Backup Set 20 22-OCT-19
Backup Piece 21 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_0.276.1022346329
Backup Set 20 22-OCT-19
Backup Piece 20 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170458_0.277.1022346299
Backup Set 21 22-OCT-19
Backup Piece 22 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170949_0.275.1022346591
Backup Set 28 22-OCT-19
Backup Piece 35 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174559_0.261.1022348759
Backup Set 29 22-OCT-19
Backup Piece 36 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174609_0.260.1022348771
Backup Set 30 22-OCT-19
Backup Piece 37 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174622_0.278.1022348783
Backup Set 31 22-OCT-19
Backup Piece 38 22-OCT-19 +FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174632_0.279.1022348793
Do you really want to delete the above objects (enter YES or NO)? yes
deleted datafile copy
datafile copy file name=/home/oracle/userscp.bkp RECID=2 STAMP=1022317151
deleted datafile copy
datafile copy file name=+FRA/orcl/datafile/users.266.1022317457 RECID=3 STAMP=1022317457
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_0.276.1022346329 RECID=21 STAMP=1022346328
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170458_0.277.1022346299 RECID=20 STAMP=1022346298
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t170949_0.275.1022346591 RECID=22 STAMP=1022346590
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174559_0.261.1022348759 RECID=35 STAMP=1022348759
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174609_0.260.1022348771 RECID=36 STAMP=1022348769
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174622_0.278.1022348783 RECID=37 STAMP=1022348782
deleted backup piece
backup piece handle=+FRA/orcl/backupset/2019_10_22/nnndf0_tag20191022t174632_0.279.1022348793 RECID=38 STAMP=1022348792
Deleted 9 objects
RMAN>