Re: FYI the last command I issued was :-alter database recover managed standby

From: Pratheep <n.pratheep_at_gmail.com>
Date: Mon, 29 Nov 2010 02:09:15 GMT
Message-ID: <201011282192usenet_at_eggheadcafe.com>

Hi,

I have got the same situation in one of my new manual standby database (log transfer & apply using scripts), v$recover_file query showing all datafiles. But in alert log and traces no errors reported.

Are you try to activate the mentioned standby database. Please update the status.

Thank you
Pratheep

> On Friday, February 05, 2010 12:11 PM Johne_uk wrote:

> Hi
> 
> I have created a traditional physical standby instance from a hot
> backup using a standby controlfile etc. from the primary db
> (10.2.0.4). Not using dataguard but there were no issues during
> creation.
> 
> In standby mode if I querry v$recover file I receive the following.
> 
> FILE#	ONLINE	ONLINE_STATUS	ERROR	CHANGE#	TIME
> 1	ONLINE	ONLINE		8185278196312	05/02/2010 14:11:55
> 2	ONLINE	ONLINE		8185278196312	05/02/2010 14:11:55
> 3	ONLINE	ONLINE		8185278196312	05/02/2010 14:11:55
> 4	ONLINE	ONLINE		8185278196312	05/02/2010 14:11:55
> 5	ONLINE	ONLINE		8185278196312	05/02/2010 14:11:55
> 6	ONLINE	ONLINE		8185278196312	05/02/2010 14:11:55
> 7	ONLINE	ONLINE		8185278196312	05/02/2010 14:11:55
> 8	ONLINE	ONLINE		8185278196312	05/02/2010 14:11:55
> 9	ONLINE	ONLINE		8185278196312	05/02/2010 14:11:55
> 
> If I bring up the instance in read-only mode executing the same query
> returns nothing and there are no datafiles etc offline.
> 
> Is it normal to receive this output from v$recover_file when an
> instance is running in standby mode. I need to have confidence that it
> can be activated in the event of a primary instance failure.
> 
> I am wondering if its because I used a standby controlfile and applied
> about 40-50 archive logs that were generated after it was created from
> primary.
> 
> There is no archive gap either.
> 
> Thanks in advance
> 
> John

>> On Saturday, February 06, 2010 1:38 AM vsevolod afanassiev wrote:

>> If standby database opened in read inly mode then select from v
>> $recoverf_file will return no rows as there is nothing to recover -
>> all files are consistent.
>> 
>> What exactly is 'standby mode' - managed recovery mode?
>> 
>> Check V$DATABASE, you should gave
>> 
>> OPEN_MODE = 'MOUNTED'
>> DATABASE_ROLE = 'PHYSICAL STANDBY'
>> 
>> Are you able to test activation?

>>> On Monday, February 08, 2010 9:51 AM Johne_uk wrote:

>>> wrote:
>>>
>>> Hi,
>>>
>>> It is a physical standby instance running in managed receovery mode as
>>> you suggest above.
>>>
>>> I have scripts that copy the generated archive logs to the remote
>>> standby location and applied manually.
>>>
>>> i.e. alter database register physical logfile xxxxxxxx;
>>>
>>> As well as the issue above, I have just realised something else is
>>> incorrect (this is the first time I have created a standby database).
>>>
>>> The archives logs are being registered but not applied. The sql below
>>> returned all archive logs I had registed since the instance was
>>> created from primary.
>>>
>>> select sequence#, applied from v$archived_log
>>> where applied <> 'YES'
>>>
>>> I automatically purge archive logs files older than 3 days on the
>>> standby server so as they have not actually been applied then it
>>> cannot be activated (no logs to recover from). I am aware the Dataguard
>>> looks after this process but in this scenario I cannot use Dataguard.
>>>
>>> So I obviously have missed something that will apply the logs after
>>> they have been registered.
>>>
>>> I am wondering if I need to issue the following command periodically to
>>> apply logs:-
>>>
>>> alter database recover managed standby database cancel;
>>> alter database recover standby database until cancel;
>>> alter database recover managed standby database disconnect from
>>> session;
>>>
>>> Would this then apply all the logs that had been registered ?
>>>
>>> Many thanks

>>>> On Monday, February 08, 2010 10:15 AM Johne_uk wrote:

>>>> FYI the last command I issued was :-
>>>> 
>>>> alter database recover managed standby database disconnect from
>>>> session;
>>>> 
>>>> (then I start registering logs via cron jobs)
>>>> 
>>>> cheers


>>>> Submitted via EggHeadCafe 

>>>> Using DataList to List Category/Subcategory with expand - collapse facility via javascript >>>> http://www.eggheadcafe.com/tutorials/aspnet/6b6d6022-60f6-4d05-beaf-7737a1f26987/using-datalist-to-list-categorysubcategory-with-expand--collapse-facility-via-javascript.aspx Received on Sun Nov 28 2010 - 20:09:15 CST