Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

list backup shows only autobackup indormation!

DBA092012Jun 13 2017 — edited Jun 13 2017

Hello everyone i'm in the middle of configuring our backup procedure.

We use 11.2.0.4 with the latest psu installed.

RDBMS works on top of CENTOS.

I'm a little bit confused with the output of the list backup command which is shows only the autobackup indormation!

Here are some listings i took from the server:

$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Tue Jun 13 11:10:59 2017

connected to target database: ASOMP (DBID=468265783)

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name ASOMP are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;

CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

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_ASOMP.f'; # default

$ cat backup_asomp.rman

run{

allocate channel ch0 device type disk;

allocate channel ch1 device type disk;

crosscheck backup;

crosscheck copy;

crosscheck archivelog all;

delete noprompt obsolete;

DELETE noprompt EXPIRED ARCHIVELOG ALL;

DELETE noprompt EXPIRED BACKUP;

DELETE noprompt EXPIRED copy device type disk;

RECOVER COPY OF DATABASE WITH TAG 'ASOMP' until time 'SYSDATE-8';

BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'ASOMP' DATABASE;

BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;

restore validate database;

report unrecoverable;

release channel ch0;

release channel ch1;

}

rman target / cmdfile=backup_asomp.rman log=backup_asomp.log trace=backup_asomp.trc debug &

Recovery Manager: Release 11.2.0.4.0 - Production on Tue Jun 13 11:16:00 2017

RMAN-06005: connected to target database: ASOMP (DBID=468265783)

RMAN> run{

2> allocate channel ch0 device type disk;

3> allocate channel ch1 device type disk;

4> crosscheck backup;

5> crosscheck copy;

6> crosscheck archivelog all;

7> delete noprompt obsolete;

8> DELETE noprompt EXPIRED ARCHIVELOG ALL;

9> DELETE noprompt EXPIRED BACKUP;

10> DELETE noprompt EXPIRED copy device type disk;

11> RECOVER COPY OF DATABASE WITH TAG 'ASOMP' until time 'SYSDATE-8';

12> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'ASOMP' DATABASE;

13> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;

14> restore validate database;

15> report unrecoverable;

16> release channel ch0;

17> release channel ch1;

18> }

19>

RMAN-06009: using target database control file instead of recovery catalog

RMAN-08030: allocated channel: ch0

RMAN-08500: channel ch0: SID=248 device type=DISK

RMAN-08030: allocated channel: ch1

RMAN-08500: channel ch1: SID=365 device type=DISK

RMAN-06812: specification does not match any backup in the repository

RMAN-06810: specification does not match any datafile copy in the repository

RMAN-06811: specification does not match any control file copy in the repository

RMAN-06158: validation succeeded for archived log

RMAN-08514: archived log file name=/fra/ASOMP/archivelog/2017_06_12/o1_mf_1_187_dmxs6z71_.arc RECID=1 STAMP=946504849

RMAN-06158: validation succeeded for archived log

RMAN-08514: archived log file name=/fra/ASOMP/archivelog/2017_06_13/o1_mf_1_188_dmycd11m_.arc RECID=2 STAMP=946523441

RMAN-06158: validation succeeded for archived log

RMAN-08514: archived log file name=/fra/ASOMP/archivelog/2017_06_13/o1_mf_1_189_dmyg9hds_.arc RECID=3 STAMP=946526431

RMAN-06206: Crosschecked 3 objects

RMAN-06158: validation succeeded for archived log

RMAN-08514: archived log file name=/fra/ASOMP/archivelog/2017_06_12/o1_mf_1_187_dmxs6z71_.arc RECID=1 STAMP=946504849

RMAN-06158: validation succeeded for archived log

RMAN-08514: archived log file name=/fra/ASOMP/archivelog/2017_06_13/o1_mf_1_188_dmycd11m_.arc RECID=2 STAMP=946523441

RMAN-06158: validation succeeded for archived log

RMAN-08514: archived log file name=/fra/ASOMP/archivelog/2017_06_13/o1_mf_1_189_dmyg9hds_.arc RECID=3 STAMP=946526431

RMAN-06206: Crosschecked 3 objects

RMAN-06524: RMAN retention policy will be applied to the command

RMAN-06510: RMAN retention policy is set to recovery window of 7 days

RMAN-06147: no obsolete backups found

RMAN-20242: specification does not match any archived log in the repository

RMAN-06812: specification does not match any backup in the repository

RMAN-06810: specification does not match any datafile copy in the repository

RMAN-06811: specification does not match any control file copy in the repository

RMAN-20242: specification does not match any archived log in the repository

RMAN-03090: Starting recover at 13-JUN-17

RMAN-05017: no copy of datafile 1 found to recover

RMAN-05017: no copy of datafile 2 found to recover

RMAN-05017: no copy of datafile 3 found to recover

RMAN-05017: no copy of datafile 4 found to recover

RMAN-05017: no copy of datafile 5 found to recover

RMAN-05017: no copy of datafile 6 found to recover

RMAN-05017: no copy of datafile 8 found to recover

RMAN-03091: Finished recover at 13-JUN-17

RMAN-03090: Starting backup at 13-JUN-17

RMAN-06052: no parent backup or copy of datafile 4 found

RMAN-06052: no parent backup or copy of datafile 1 found

RMAN-06052: no parent backup or copy of datafile 2 found

RMAN-06052: no parent backup or copy of datafile 8 found

RMAN-06052: no parent backup or copy of datafile 3 found

RMAN-06052: no parent backup or copy of datafile 5 found

RMAN-06052: no parent backup or copy of datafile 6 found

RMAN-08580: channel ch0: starting datafile copy

RMAN-08522: input datafile file number=00004 name=/data/ASOMP/datafile/o1_mf_users_dldz4x7b_.dbf

RMAN-08580: channel ch1: starting datafile copy

RMAN-08522: input datafile file number=00001 name=/data/ASOMP/datafile/o1_mf_system_dldz4x4b_.dbf

RMAN-08586: output file name=/fra/ASOMP/datafile/o1_mf_system_dmz7t8gk_.dbf tag=ASOMP RECID=15 STAMP=946552627

RMAN-08581: channel ch1: datafile copy complete, elapsed time: 00:01:06

RMAN-08580: channel ch1: starting datafile copy

RMAN-08522: input datafile file number=00002 name=/data/ASOMP/datafile/o1_mf_sysaux_dldz4x5s_.dbf

RMAN-08586: output file name=/fra/ASOMP/datafile/o1_mf_sysaux_dmz7wbgp_.dbf tag=ASOMP RECID=16 STAMP=946552670

RMAN-08581: channel ch1: datafile copy complete, elapsed time: 00:00:46

RMAN-08580: channel ch1: starting datafile copy

RMAN-08522: input datafile file number=00008 name=/data/ASOMP/datafile/o1_mf_ts_ird_m_dlf5wzx0_.dbf

RMAN-08586: output file name=/fra/ASOMP/datafile/o1_mf_ts_ird_m_dmz7y5y1_.dbf tag=ASOMP RECID=17 STAMP=946552723

RMAN-08581: channel ch1: datafile copy complete, elapsed time: 00:00:46

RMAN-08580: channel ch1: starting datafile copy

RMAN-08522: input datafile file number=00003 name=/data/ASOMP/datafile/o1_mf_undotbs1_dldz4x61_.dbf

RMAN-08586: output file name=/fra/ASOMP/datafile/o1_mf_undotbs1_dmz7z9h4_.dbf tag=ASOMP RECID=18 STAMP=946552737

RMAN-08581: channel ch1: datafile copy complete, elapsed time: 00:00:23

RMAN-08580: channel ch1: starting datafile copy

RMAN-08522: input datafile file number=00005 name=/data/ASOMP/datafile/o1_mf_indx_dlf5wk1f_.dbf

RMAN-08586: output file name=/fra/ASOMP/datafile/o1_mf_indx_dmz80184_.dbf tag=ASOMP RECID=19 STAMP=946552759

RMAN-08581: channel ch1: datafile copy complete, elapsed time: 00:00:16

RMAN-08580: channel ch1: starting datafile copy

RMAN-08522: input datafile file number=00006 name=/data/ASOMP/datafile/o1_mf_mpv_dlf5wn7b_.dbf

RMAN-08586: output file name=/fra/ASOMP/datafile/o1_mf_mpv_dmz80mxp_.dbf tag=ASOMP RECID=20 STAMP=946552777

RMAN-08581: channel ch1: datafile copy complete, elapsed time: 00:00:20

RMAN-08586: output file name=/fra/ASOMP/datafile/o1_mf_users_dmz7t7lw_.dbf tag=ASOMP RECID=21 STAMP=946552808

RMAN-08581: channel ch0: datafile copy complete, elapsed time: 00:04:02

RMAN-03091: Finished backup at 13-JUN-17

RMAN-03090: Starting Control File and SPFILE Autobackup at 13-JUN-17

RMAN-08503: piece handle=/fra/ASOMP/autobackup/2017_06_13/o1_mf_s_946552809_dmz81t6z_.bkp comment=NONE

RMAN-03091: Finished Control File and SPFILE Autobackup at 13-JUN-17

RMAN-03090: Starting backup at 13-JUN-17

RMAN-08008: channel ch0: starting full datafile backup set

RMAN-08010: channel ch0: specifying datafile(s) in backup set

RMAN-08522: input datafile file number=00004 name=/data/ASOMP/datafile/o1_mf_users_dldz4x7b_.dbf

RMAN-08522: input datafile file number=00005 name=/data/ASOMP/datafile/o1_mf_indx_dlf5wk1f_.dbf

RMAN-08522: input datafile file number=00006 name=/data/ASOMP/datafile/o1_mf_mpv_dlf5wn7b_.dbf

RMAN-08008: channel ch1: starting full datafile backup set

RMAN-08010: channel ch1: specifying datafile(s) in backup set

RMAN-08522: input datafile file number=00001 name=/data/ASOMP/datafile/o1_mf_system_dldz4x4b_.dbf

RMAN-08522: input datafile file number=00002 name=/data/ASOMP/datafile/o1_mf_sysaux_dldz4x5s_.dbf

RMAN-08522: input datafile file number=00008 name=/data/ASOMP/datafile/o1_mf_ts_ird_m_dlf5wzx0_.dbf

RMAN-08522: input datafile file number=00003 name=/data/ASOMP/datafile/o1_mf_undotbs1_dldz4x61_.dbf

RMAN-08540: channel ch1: backup set complete, elapsed time: 00:00:45

RMAN-07225: List of Datafiles

RMAN-07226: =================

RMAN-07227: File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

RMAN-07228: ---- ------ -------------- ------------ --------------- ----------

RMAN-07247: 1 OK 0 13754 98566 31339029213

RMAN-07511: File Name: /data/ASOMP/datafile/o1_mf_system_dldz4x4b_.dbf

RMAN-07230: Block Type Blocks Failing Blocks Processed

RMAN-07231: ---------- -------------- ----------------

RMAN-07232: Data 0 66689

RMAN-07233: Index	0	14251
RMAN-07234: Other	0	3866

RMAN-07227: File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

RMAN-07228: ---- ------ -------------- ------------ --------------- ----------

RMAN-07247: 2

20862

88330

31339028988

RMAN-07511: File Name: /data/ASOMP/datafile/o1_mf_sysaux_dldz4x5s_.dbf

RMAN-07230: Block Type Blocks Failing Blocks Processed

RMAN-07231: ---------- -------------- ----------------

RMAN-07232: Data	0	21119
RMAN-07233: Index	0	17990
RMAN-07234: Other	0	28349

RMAN-07227: File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

RMAN-07228: ---- ------ -------------- ------------ --------------- ----------

RMAN-07247: 3

28160

31339029213

RMAN-07511: File Name: /data/ASOMP/datafile/o1_mf_undotbs1_dldz4x61_.dbf

RMAN-07230: Block Type Blocks Failing Blocks Processed

RMAN-07231: ---------- -------------- ----------------

RMAN-07232: Data	0	0
RMAN-07233: Index	0	0
RMAN-07234: Other	0	28094

RMAN-07227: File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

RMAN-07228: ---- ------ -------------- ------------ --------------- ----------

RMAN-07247: 8

9433

76800

1182846

RMAN-07511: File Name: /data/ASOMP/datafile/o1_mf_ts_ird_m_dlf5wzx0_.dbf

RMAN-07230: Block Type Blocks Failing Blocks Processed

RMAN-07231: ---------- -------------- ----------------

RMAN-07232: Data	0	31684
RMAN-07233: Index	0	33740
RMAN-07234: Other	0	1943

RMAN-08009: channel ch1: starting archived log backup set

RMAN-08014: channel ch1: specifying archived log(s) in backup set

RMAN-08504: input archived log thread=1 sequence=187 RECID=1 STAMP=946504849

RMAN-08504: input archived log thread=1 sequence=188 RECID=2 STAMP=946523441

RMAN-08540: channel ch1: backup set complete, elapsed time: 00:00:03

RMAN-07236: List of Archived Logs

RMAN-07237: =====================

RMAN-07238: Thrd Seq Status Blocks Failing Blocks Examined Name

RMAN-07239: ---- ------- ------ -------------- --------------- ---------------

RMAN-07240: 1 187 OK 0 61094 /fra/ASOMP/archivelog/2017_06_12/o1_mf_1_187_dmxs6z71_.arc

RMAN-07240: 1 188 OK 0 57485 /fra/ASOMP/archivelog/2017_06_13/o1_mf_1_188_dmycd11m_.arc

RMAN-08009: channel ch1: starting archived log backup set

RMAN-08014: channel ch1: specifying archived log(s) in backup set

RMAN-08504: input archived log thread=1 sequence=189 RECID=3 STAMP=946526431

RMAN-08540: channel ch1: backup set complete, elapsed time: 00:00:01

RMAN-07236: List of Archived Logs

RMAN-07237: =====================

RMAN-07238: Thrd Seq Status Blocks Failing Blocks Examined Name

RMAN-07239: ---- ------- ------ -------------- --------------- ---------------

RMAN-07240: 1 189 OK 0 55901 /fra/ASOMP/archivelog/2017_06_13/o1_mf_1_189_dmyg9hds_.arc

RMAN-08008: channel ch1: starting full datafile backup set

RMAN-08010: channel ch1: specifying datafile(s) in backup set

RMAN-08011: including current control file in backup set

RMAN-08540: channel ch1: backup set complete, elapsed time: 00:00:02

RMAN-07241: List of Control File and SPFILE

RMAN-07242: ===============================

RMAN-07243: File Type Status Blocks Failing Blocks Examined

RMAN-07244: ------------ ------ -------------- ---------------

RMAN-07245: Control File OK 0 614

RMAN-08008: channel ch1: starting full datafile backup set

RMAN-08010: channel ch1: specifying datafile(s) in backup set

RMAN-08113: including current SPFILE in backup set

RMAN-08540: channel ch1: backup set complete, elapsed time: 00:00:00

RMAN-07241: List of Control File and SPFILE

RMAN-07242: ===============================

RMAN-07243: File Type Status Blocks Failing Blocks Examined

RMAN-07244: ------------ ------ -------------- ---------------

RMAN-07246: SPFILE OK 0 2

RMAN-08540: channel ch0: backup set complete, elapsed time: 00:01:48

RMAN-07225: List of Datafiles

RMAN-07226: =================

RMAN-07227: File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

RMAN-07228: ---- ------ -------------- ------------ --------------- ----------

RMAN-07247: 4

38224

803040

31338618487

RMAN-07511: File Name: /data/ASOMP/datafile/o1_mf_users_dldz4x7b_.dbf

RMAN-07230: Block Type Blocks Failing Blocks Processed

RMAN-07231: ---------- -------------- ----------------

RMAN-07232: Data	0	123922
RMAN-07233: Index	0	34967
RMAN-07234: Other	0	605927

RMAN-07227: File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

RMAN-07228: ---- ------ -------------- ------------ --------------- ----------

RMAN-07247: 5

10380

12800

31286563401

RMAN-07511: File Name: /data/ASOMP/datafile/o1_mf_indx_dlf5wk1f_.dbf

RMAN-07230: Block Type Blocks Failing Blocks Processed

RMAN-07231: ---------- -------------- ----------------

RMAN-07232: Data	0	0
RMAN-07233: Index	0	2010
RMAN-07234: Other	0	410

RMAN-07227: File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

RMAN-07228: ---- ------ -------------- ------------ --------------- ----------

RMAN-07247: 6

10152

12800

1188189

RMAN-07511: File Name: /data/ASOMP/datafile/o1_mf_mpv_dlf5wn7b_.dbf

RMAN-07230: Block Type Blocks Failing Blocks Processed

RMAN-07231: ---------- -------------- ----------------

RMAN-07232: Data	0	0
RMAN-07233: Index	0	2473
RMAN-07234: Other	0	175

RMAN-03091: Finished backup at 13-JUN-17

RMAN-03090: Starting restore at 13-JUN-17

RMAN-08519: channel ch0: scanning datafile copy /fra/ASOMP/datafile/o1_mf_system_dmz7t8gk_.dbf

RMAN-08519: channel ch1: scanning datafile copy /fra/ASOMP/datafile/o1_mf_sysaux_dmz7wbgp_.dbf

RMAN-08519: channel ch0: scanning datafile copy /fra/ASOMP/datafile/o1_mf_undotbs1_dmz7z9h4_.dbf

RMAN-08519: channel ch1: scanning datafile copy /fra/ASOMP/datafile/o1_mf_users_dmz7t7lw_.dbf

RMAN-08519: channel ch0: scanning datafile copy /fra/ASOMP/datafile/o1_mf_indx_dmz80184_.dbf

RMAN-08519: channel ch0: scanning datafile copy /fra/ASOMP/datafile/o1_mf_mpv_dmz80mxp_.dbf

RMAN-08519: channel ch0: scanning datafile copy /fra/ASOMP/datafile/o1_mf_ts_ird_m_dmz7y5y1_.dbf

RMAN-03091: Finished restore at 13-JUN-17

RMAN-06250: Report of files that need backup due to unrecoverable operations

RMAN-06251: File Type of Backup Required Name

RMAN-06252: ---- ----------------------- -----------------------------------

RMAN-08031: released channel: ch0

RMAN-08031: released channel: ch1

Recovery Manager complete.

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

6 Full 9.67M DISK 00:00:01 13-JUN-17

BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20170613T112009

Piece Name: /fra/ASOMP/autobackup/2017_06_13/o1_mf_s_946552809_dmz81t6z_.bkp

SPFILE Included: Modification time: 12-JUN-17

SPFILE db_unique_name: ASOMP

Control File Included: Ckp SCN: 31339029298 Ckp time: 13-JUN-17

RMAN> list incarnation;

List of Database Incarnations

DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

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

1 1 ASOMP 468265783 CURRENT 925702 25-MAY-17

Please afvise in the matter

This post has been answered by Hemant K Chitale on Jun 13 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2017

Added on Jun 13 2017

#performance-availability, #recovery-manager-rman

7 comments

1,369 views

Database Software

list backup shows only autobackup indormation!

Comments

Post Details