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!

Guaranteed restore point and storage size

AJOct 4 2012 — edited Oct 4 2012

RHEL5 (RDBMS 11.2.0.3.0 - nonrac)

Hi,

I've created a couple of guaranteed restore points in my database and upon quering the information about them I get the following output:

select name, time, storage_size/1024/1024 "MB", guarantee_flashback_database from v$restore_point order by time

NAME                           TIME                                        MB GUA
------------------------------ ----------------------------------- ---------- ---
PRE_TAS4279_20120927           27-SEP-12 07.00.01.000000000 PM           3072 YES
PRE_TAS4279_20120928           28-SEP-12 07.00.02.000000000 PM          10752 YES
PRE_TAS4279_20121001           01-OCT-12 07.00.01.000000000 PM          19968 YES
RP_PRE_BUKVILKAR               02-OCT-12 04.00.09.000000000 PM              0 YES
PRE_TAS4279_20121002           02-OCT-12 07.00.01.000000000 PM          11264 YES
PRE_TAS4279_20121003           03-OCT-12 07.00.01.000000000 PM           4096 YES

As you can see one of the restore points have 0 bytes in storage size - even though the restore point is guaranteed.
Isn't this a bit strange or am I missing something ?? Is it useless?

Please shed some expert light.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 1 2012

Added on Oct 4 2012

#performance-availability, #recovery-manager-rman

7 comments

5,806 views