OraFAQ Forum: Server Administration » how to aletr an '

Home » RDBMS Server » Server Administration » how to aletr an '_' parameter (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to aletr an '_' parameter [message #193984]

Wed, 20 September 2006 05:16

alanm
Messages: 284
Registered: March 2005

Senior Member

hello All,
How does one set a parameter such as

_log_deletion_policy='all'

the leading _ is an invalid character.

regards

Report message to a moderator

Re: how to aletr an '_' parameter [message #194109 is a reply to message #193984]

Wed, 20 September 2006 16:54

kimant
Messages: 201
Registered: August 2006
Location: Denmark

Senior Member

use "_log_deletion_policy"='all'

Report message to a moderator

Re: how to aletr an '_' parameter [message #202700 is a reply to message #194109]

Sat, 11 November 2006 02:58

amit_p_dixit
Messages: 31
Registered: November 2006
Location: Mumbai

Member

hi,
I have tried setting this parameter as u said. but its still showing me

SQL> alter system set "_log_deletion_policy"='all'
2 /
alter system set "_log_deletion_policy"='all'
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

What should i do.

pls help.

Amit Dixit

Report message to a moderator

Re: how to aletr an '_' parameter [message #202701 is a reply to message #202700]

Sat, 11 November 2006 03:03

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi
the above parameter is not modifiable parameter so. try this way

SQL> alter system set "_log_deletion_policy"=all scope=spfile;

System altered.

and bounce ur database ( shutdown to startup)

hope this helps
MTaj.

you want more ....
http://orafaq.com/parms/parm818.htm

Report message to a moderator

Re: how to aletr an '_' parameter [message #202705 is a reply to message #202701]

Sat, 11 November 2006 03:47

amit_p_dixit
Messages: 31
Registered: November 2006
Location: Mumbai

Member

thanx buddy

it worked..

i wanted to remove archive logs on the production database which have been applied on the standby database..so i was setting this parameter..after setting this parameter i shut down the database and restarted it. I am using RMAN...CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY..but now its giving me following error....
What should i do..is there some other way to do this without using RMAN... Pls help.

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

using target database controlfile instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters are successfully stored
RMAN-08591: WARNING: invalid archivelog deletion policy

Waiting 4 reply.

Amit Dixit

[Updated on: Sat, 11 November 2006 03:50]

Report message to a moderator

Re: how to aletr an '_' parameter [message #202725 is a reply to message #202705]

Sat, 11 November 2006 06:09

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

RMAN-08591: WARNING: invalid archivelog deletion policy 

Cause: An invalid ARCHIVELOG DELETION POLICY was supplied. The archivelog deletion policy was APPLIED [B]but there was no mandatory archivelog destinations. [/B]

Action: One of the following: 
1) Change archivelog deletion policy using CONFIGURE command 
2) [B]Make one or more of standby destination as MANDATORY.[/B]

hope this helps
Mohammad Taj.

Report message to a moderator

Re: how to aletr an '_' parameter [message #203140 is a reply to message #202725]

Tue, 14 November 2006 01:18

amit_p_dixit
Messages: 31
Registered: November 2006
Location: Mumbai

Member

The rman archive log deletion policy on the primary is set to "CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY".

Archive logs are not being deleted on the primary once they have been applied to the standby!

Is there something else I should be looking at???

pls help

Amit Dixit

Report message to a moderator

Re: how to aletr an '_' parameter [message #203187 is a reply to message #203140]

Tue, 14 November 2006 03:58

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Out of curiosity, did Support tell you to use this parameter, or did you just find out about it on the net?

Report message to a moderator

Re: how to aletr an '_' parameter [message #203209 is a reply to message #193984]

Tue, 14 November 2006 06:01

amit_p_dixit
Messages: 31
Registered: November 2006
Location: Mumbai

Member

hi,

I found it on Net. Actually i want to delete the archived logs on the production database which have been applied on the standby database. While going from the web page http://schemathings.com/ i came to know about this parameter.

Is this possible only by RMAN or there is some other way to solve this issiue.

Waiting 4 reply.

Regards,
Amit Dixit

Report message to a moderator

Previous Topic:	Unable to connect as Sys User
Next Topic:	10g RAC implementation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:33:07 CDT 2024