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 backup-restore

Beauty_and_dBestSep 18 2019 — edited Oct 9 2019

11gR2

Hi ALL,

We have weekly full RMAN backup. (using command > backup database plus archivelogs)

I understand "plus achivelogs" made a complete recovery set for the database.

Previously, I already tested restoring our backup many times, using these weekly backups, and I was able to open resetlogs the database without applying a single archive logs.

But now, I tried to do it again for this Month for week 1 and week 2, but both failed to open resetlogs Even when I applied four archivelogs already.

pastedImage_2.png

I also encountered :

ERROR at line 1:

ORA-01552: cannot use system rollback segment for non-system tablespace

'APPS_TS_SEED'

ORA-06512: at "APPS.FND_CONC_CLONE", line 360

ORA-06512: at line 2

Does above error, a result of incomplete archivelogs recovery?

Please help....

Thanks a lot,

jc

This post has been answered by Adityanath Dewoolkar on Sep 19 2019
Jump to Answer
Comments
Post Details
Added on Sep 18 2019
34 comments
1,257 views