Re: Steps/DOC for Physical Standby with Real-Time Apply -Creation with Rman Tool.

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Wed, 15 Feb 2012 13:37:06 +0000
Message-ID: <4F3BB502.9040601_at_dunbar-it.co.uk>

Afternoon,

On 15/02/12 12:27, Sheldon Quinny wrote:
> Hi All,
> Trying to execute this statement on a Oracle DB 10.2.4.0 Windows 2003R2
>
> It Gives me the Year as 2011 and month FEB ...Please can any one
> clarify , what I am missing out here.

All your data files were either created in February 2011 and those that were not were created more than 365 days ago.

I tried it and got :

2011 October 7808

Then I deleted the WHERE clause and got this:

2005 April 158623
2006 April 104694
2010 August 36868
2011 October 7808

Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 15 2012 - 07:37:06 CST

This message: [ Message body ]
Next message: Howard Latham: "RE: An unusual case of recovery asking for an archived log from long time a go."
Previous message: Paresh Yadav: "Re: An unusual case of recovery asking for an archived log from long time a go."
In reply to: Sheldon Quinny: "Re: Steps/DOC for Physical Standby with Real-Time Apply -Creation with Rman Tool."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message