Re: Q: restore point and SCN + standby database , strange behavior
- From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
- To: agonenil@xxxxxxxxx
- Date: Thu, 10 Jul 2014 08:26:59 -0700
Hi
1. Can you print any underscore parameters in the standby database?
2. Also, output of the following script (I know, I know, I should stop
using x$ fixed tables, however, in this case, not all attributes are
visible through gv$ views).
----
col minscn format 999999999999999
col maxscn format 999999999999999
select 'MIN ', min(fhscn) minscn from x$kcvfh;
select 'MAX ', greatest(max(fhscn), max(fhafs)) maxscn from x$kcvfh;
---
Cheers
Riyaj Shamsudeen
Principal DBA,
Ora!nternals - http://www.orainternals.com - Specialists in Performance,
RAC and EBS
Blog: http://orainternals.wordpress.com/
Oracle ACE Director and OakTable member <http://www.oaktable.com/>
Co-author of the books: Expert Oracle Practices
<http://tinyurl.com/book-expert-oracle-practices/>, Pro Oracle SQL,
<http://tinyurl.com/ahpvms8> <http://tinyurl.com/ahpvms8>Expert RAC
Practices 12c. <http://tinyurl.com/expert-rac-12c> Expert PL/SQL practices
<http://tinyurl.com/book-expert-plsql-practices>
<http://tinyurl.com/book-expert-plsql-practices>
On Thu, Jul 10, 2014 at 7:58 AM, amihay gonen <agonenil@xxxxxxxxx> wrote:
> Hi all,
> I'm trying to understand how oracle is managing restore points.
>
> AFAIK , restore point is actually giving a name to a point in time (or
> more precisely SCN).
>
> I've a standby database which doesn't receives new data from the primary
> .
>
> the current scn is :
> SQL> select CURRENT_SCN from v$database;
>
> CURRENT_SCN
> -----------
> 6891768
>
> when I'm creating restore point :
> SQL> CREATE RESTORE POINT new ;
>
> Restore point created.
>
> i get:
> SQL> select * from v$restore_point where name='NEW';
>
> SCN DATABASE_INCARNATION# GUA STORAGE_SIZE
> ---------- --------------------- --- ------------
> TIME
> ---------------------------------------------------------------------------
> RESTORE_POINT_TIME
> PRE
> ---------------------------------------------------------------------------
> ---
> NAME
>
> --------------------------------------------------------------------------------
> 6861969 2 NO 0
> 10-JUL-14 05.44.09.000000000 PM
>
> NO
> NEW
>
>
> Please note that the restore point was created with SCN *6861969
> *which is lower than the current SCN (6891768)
>
> 1. I wander if anyone have an idea why this is different and what is the
> meaning of that ?
>
> 2. how can tell if this restore point will covers all the current
> changes in the database ?
> ( i'm asking this since the current scn is higher the scn which
> was recorded in the restore point )
>
>
>
>
> thanks
>
>
>
>
>
Other related posts:
