Skip to Main Content

Oracle Database Discussions

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!

restore database preview 12.1.0.2

SGUJun 7 2020 — edited Jun 8 2020

Dear Experts,

We have taken cold backup and ran restore database preview,but error is reported as below.Can we ignore this error?

We are on 12.1.0.2 database

[dummy@test u05]$ rman target /

RMAN> restore database preview summary from tag 'DBI_BACKUP';

Starting restore at 06-JUN-20

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=207 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=407 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=601 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=7 device type=DISK

List of Backups

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

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

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

7       B  0  A DISK        06-JUN-20       1       1       YES        DBI_BACKUP

9       B  0  A DISK        06-JUN-20       1       1       YES        DBI_BACKUP

8       B  0  A DISK        06-JUN-20       1       1       YES        DBI_BACKUP

6       B  0  A DISK        06-JUN-20       1       1       YES        DBI_BACKUP

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

archived logs generated after SCN 5976350033540 not found in repository

RMAN-05119: recovery can not be done to a consistent state.--------------->Error

Media recovery start SCN is 5976350033540

Recovery must be done beyond SCN 5976350035650 to clear datafile fuzziness

Finished restore at 06-JUN-20

dummy@test]$ rman target /

RMAN>

2> ;

using target database control file instead of recovery catalog

List of Backups

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

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

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

2       B  A  A DISK        06-JUN-20       1       1       YES        DBI_BACKUP

3       B  A  A DISK        06-JUN-20       1       1       YES        DBI_BACKUP

4       B  A  A DISK        06-JUN-20       1       1       YES        DBI_BACKUP

5       B  A  A DISK        06-JUN-20       1       1       YES        DBI_BACKUP

6       B  0  A DISK        06-JUN-20       1       1       YES        DBI_BACKUP

7       B  0  A DISK        06-JUN-20       1       1       YES        DBI_BACKUP

8       B  0  A DISK        06-JUN-20       1       1       YES        DBI_BACKUP

9       B  0  A DISK        06-JUN-20       1       1       YES        DBI_BACKUP

10      B  F  A DISK        06-JUN-20       1       1       NO         DBI_BACKUP

11      B  F  A DISK        06-JUN-20       1       1       NO         DBI_BACKUP

Thank You

Comments
Post Details
Added on Jun 7 2020
2 comments
441 views