Tell me about the obsolete in Rman.

Source: Internet
Author: User

Rman> report obsolete;

RMAN retention policy would be applied to the command
RMAN retention policy is set to redundancy 1
No obsolete backups found

rman> backup DataFile 1;

Starting backup at 29-may-14
Using channel Ora_disk_1
Channel ora_disk_1:starting full datafile backupset
Channel ora_disk_1:specifying DataFile (s) in Backupset
Input datafile fno=00001 name=/u01/app/oracle/oradata/prod/system01.dbf
Channel ora_disk_1:starting piece 1 at 29-may-14
Channel ora_disk_1:finished piece 1 at 29-may-14
Piece Handle=/u01/app/oracle/product/10.2.0/db_1/dbs/amp9g8sf_1_1 tag=tag20140529t102934 Comment=NONE
Channel Ora_disk_1:backup set complete, elapsed time:00:00:25
Finished backup at 29-may-14

Starting Control File and SPFILE autobackup at 29-may-14
Piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-00 Comment=none
Finished Control File and SPFILE autobackup at 29-may-14

Rman> list Backup of datafile 1;


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

BS Key type LV Size Device Type Elapsed Time Completion time
------- ---- -- ---------- ----------- ------------ ---------------
504 Full 391.63M DISK 00:00:23 29-may-14
BP key:504 status:available Compressed:no tag:tag20140529t102934
Piece Name:/u01/app/oracle/product/10.2.0/db_1/dbs/amp9g8sf_1_1
List of datafiles in backup set 504
File LV Type Ckp SCN Ckp time Name
---- -- ---- ---------- --------- ----
1 Full 1588933 29-may-14/u01/app/oracle/oradata/prod/system01.dbf

rman> backup DataFile 1;

Starting backup at 29-may-14
Using channel Ora_disk_1
Channel ora_disk_1:starting full datafile backupset
Channel ora_disk_1:specifying DataFile (s) in Backupset
Input datafile fno=00001 name=/u01/app/oracle/oradata/prod/system01.dbf
Channel ora_disk_1:starting piece 1 at 29-may-14
Channel ora_disk_1:finished piece 1 at 29-may-14
Piece Handle=/u01/app/oracle/product/10.2.0/db_1/dbs/aop9g8u0_1_1 tag=tag20140529t103024 Comment=NONE
Channel Ora_disk_1:backup set complete, elapsed time:00:00:35
Finished backup at 29-may-14

Starting Control File and SPFILE autobackup at 29-may-14
Piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-01 Comment=none
Finished Control File and SPFILE autobackup at 29-may-14

Rman> list Backup of datafile 1;


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

BS Key type LV Size Device Type Elapsed Time Completion time
------- ---- -- ---------- ----------- ------------ ---------------
504 Full 391.63M DISK 00:00:23 29-may-14
BP key:504 status:available Compressed:no tag:tag20140529t102934
Piece Name:/u01/app/oracle/product/10.2.0/db_1/dbs/amp9g8sf_1_1
List of datafiles in backup set 504
File LV Type Ckp SCN Ckp time Name
---- -- ---- ---------- --------- ----
1 Full 1588933 29-may-14/u01/app/oracle/oradata/prod/system01.dbf

BS Key type LV Size Device Type Elapsed Time Completion time
------- ---- -- ---------- ----------- ------------ ---------------
506 Full 391.63M DISK 00:00:27 29-may-14
BP key:506 status:available Compressed:no tag:tag20140529t103024
Piece Name:/u01/app/oracle/product/10.2.0/db_1/dbs/aop9g8u0_1_1
List of Datafiles in backup set 506
File LV Type Ckp SCN Ckp time Name
---- -- ---- ---------- --------- ----
1 Full 1588970 29-may-14/u01/app/oracle/oradata/prod/system01.dbf

Rman> report obsolete;

RMAN retention policy would 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
-------------------- ------ ------------------ --------------------
Backup Set 503 17-mar-14
Backup Piece 503 17-mar-14/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140317-0b
Backup Set 504 29-may-14
Backup Piece 504 29-may-14/u01/app/oracle/product/10.2.0/db_1/dbs/amp9g8sf_1_1
Backup Set 505 29-may-14
Backup Piece 505 29-may-14/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-00

rman> backup DataFile 1;

Starting backup at 29-may-14
Using channel Ora_disk_1
Channel ora_disk_1:starting full datafile backupset
Channel ora_disk_1:specifying DataFile (s) in Backupset
Input datafile fno=00001 name=/u01/app/oracle/oradata/prod/system01.dbf
Channel ora_disk_1:starting piece 1 at 29-may-14
Channel ora_disk_1:finished piece 1 at 29-may-14
Piece Handle=/u01/app/oracle/product/10.2.0/db_1/dbs/aqp9g90p_1_1 tag=tag20140529t103153 Comment=NONE
Channel Ora_disk_1:backup set complete, elapsed time:00:00:26
Finished backup at 29-may-14

Starting Control File and SPFILE autobackup at 29-may-14
Piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-02 Comment=none
Finished Control File and SPFILE autobackup at 29-may-14

Rman> report obsolete;

RMAN retention policy would 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
-------------------- ------ ------------------ --------------------
Backup Set 503 17-mar-14
Backup Piece 503 17-mar-14/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140317-0b
Backup Set 504 29-may-14
Backup Piece 504 29-may-14/u01/app/oracle/product/10.2.0/db_1/dbs/amp9g8sf_1_1
Backup Set 505 29-may-14
Backup Piece 505 29-may-14/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-00
Backup Set 506 29-may-14
Backup Piece 506 29-may-14/u01/app/oracle/product/10.2.0/db_1/dbs/aop9g8u0_1_1
Backup Set 507 29-may-14
Backup Piece 507 29-may-14/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-01

Tell me about the obsolete in Rman.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.