Standby_file_management = auto ; not working

[former_member199632]

Hello,

We have extended our PSAPSR3 tablespace by adding a datafile.

It added successfully in PRD DB; PSAPSR3 tablespace got extended.

In SB server standby_file_management is set to AUTO.

So normally when we add a Datafile it should automatically generate in standby database. (through log shipping)

But, it is not applied to SB server yet.

kindly let me know how to resolve this issue.

regards,

Zerandib

[former_member182034 · Accepted solution]

hi Zerandib,

first check settings of DB parameter STANDBY_FILE_MANAGEMENT on your standby db server (spfile)

whether it is AUTO or MANUAL and then following the manual from the link

http://download.oracle.com/docs/cd/B12037_01/server.101/b10823/manage_ps.htm#1010429

Regards,

[former_member199632 · Accepted solution]

hi

STANDBY_FILE_MANAGEMENT is AUTO

I have waited for long time. Seems like it will not going created in Standby Server.

So whats the best thing i can do?

May i add a data-file manually to the SB server .(after changing the STANDBY_FILE_MANAGEMENT to MANUAL)

kindly let me know, what are the other things to do in standby server, if im going to add that manually

thanks n Regards,

[Former Member · Accepted solution]

Did you created the destination folder? It has not been created automatically...

1) Check alert_SID.log at both primary and standby.

2) execute "tnsping" at the primary and standby site and check the result.

3) At the next step execute statements, at the primary system;

alter system set log_archive_dest_state_2=defer;
<wait 5 mins>
alter system set log_archive_dest_state_2=enable;

4) restart the standby

Best regards,

Orkun Gedik

[stefan_koehler · Accepted solution]

Hello Orkun,

Did you created the destination folder? It has not been created automatically...

That's just wrong. It depends on your oracle release (incl. patchset) and the platform. For example we are running Oracle 10.2.0.4 in a Data Guard environment on AIX and all data file folders are created automatically on standby site.

Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan,

We have same configuration but cannot create the folder at the standby site, automatically? How do you achieve this? It may be created by scripts, but is it supported by Oracle 10g without any script support?

Additionally, we are patched the Oracle 10g patch #44.

Best regards,

Orkun Gedik

Edited by: Orkun Gedik on Jul 5, 2011 3:24 PM

[stefan_koehler · Accepted solution]

Hello Orkun,

no it is not created by scripts .. it just works "out-of-the-box" by Oracle.

We are using Data Guard Broker for managing our environment.

Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan,

It is achieved by "Data Guard Broker"? We are not running on broker service. That's the good point. I didn't know this. I will test this solution, then. Thanks

By the way, "for this case" it is good to check the folder is created or not...

Best regards,

Orkun Gedik

[Former Member]

Hello,
> 
> We have extended our PSAPSR3 tablespace by adding a datafile.
> It added successfully in PRD DB;  PSAPSR3 tablespace got extended.
> 
> In SB server standby_file_management is set to AUTO.
> So normally when we add a Datafile it should automatically generate in standby database. (through log shipping)
> But, it is not applied to SB server yet.
> 
> kindly let me know how to resolve this issue.
> 
> regards,
> Zerandib

Hi Zerandib,

Did you created the datafile folder at the standby site, manually?

Best regards,

Orkun Gedik