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!

Restore multiple non-sequential archivelogs

user1151048May 10 2021

Hello community,
I am standing up a Data Guard copy of a database and found that there are a few dozen missing archivelogs, spread across a range of sequence numbers. I am looking for an efficient way to restore those, like a comma-delimited list or something similar. Right now I am performing individual restore commands on each log. Is there a way to restore many non-sequential logs in one command?

Thanks,
John

This post has been answered by Luís Gustavo Lira on May 10 2021
Jump to Answer

Comments

Thanos A

Hi there,

Have you confirm that the NumDecimalPlaces of the stat account is not zero but it is more than 1? Only if you have a NumDecimalPlaces value, HFM will not round the number during the input.

Regards,

Thanos

One Truth about...: ...Apps 13, London

Dakku

Would this be in the metadata?

Thanos A

Hi again,

Yes, you should confirm that the stat account that you have created has as a NumDecimalPlaces attribute the value 1. Based on that you will be able to input data with one decimal.

Regards,

Thanos

One Truth about...: ...Apps 13, London

AmarnathK

Yes. You can have a look at the Account properties. Same place where you would see isCalculated, isConsolidated properties

Regards

Amarnath

http://amarnath-essbase-blog.blogspot.com

1 - 4

Post Details

Added on May 10 2021
2 comments
31 views