Skip to Main Content

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!

Rman does not see the previous backups

ferhat bakanFeb 22 2017 — edited Feb 22 2017

Hello,

Although I have two backupsets, when I check available backups via 'RESTORE DATABASE PREVIEW SUMMARY' I can see the latest one. Can you please assist me to make RMAN remember old backups as alternatives for database restore?

-- This is the content of backup folder;

[ntdbadm@ESCmaster backupset]$ ls -alrt

total 16

drwxrwx--- 5 ntdbsw ntdbadm 4096 Jan 18 15:02 ..

drwxrwx--- 4 ntdbsw ntdbadm 4096 Feb 22 09:13 .

drwxrwx--- 2 ntdbsw ntdbgrp 4096 Feb 22 09:15 2017_02_21

drwxrwx--- 2 ntdbsw ntdbgrp 4096 Feb 22 09:15 2017_02_22

-- This is the output of restore summary command;

RMAN> RESTORE  DATABASE PREVIEW SUMMARY;

Starting restore at 22-FEB-17

using channel ORA_DISK_1

List of Backups

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

Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

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

104     B  F  A DISK        22-FEB-17       1       1       NO         TAG20170222T091359

List of Archived Log Copies for database with db_unique_name MCPDB

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

Key     Thrd Seq     S Low Time

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

101     1    4       A 22-FEB-17

        Name: /var/mcp/db/data/flash_recovery_area/MCPDB/archivelog/2017_02_22/o1_mf_1_4_dbtgn5v0_.arc

Media recovery start SCN is 19807198

Recovery must be done beyond SCN 19807198 to clear datafile fuzziness

Finished restore at 22-FEB-17

RMAN>

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2017
Added on Feb 22 2017
12 comments
1,536 views