Home » RDBMS Server » Server Administration » how to aletr an '_' parameter  () 1 Vote
how to aletr an '_' parameter [message #193984] Wed, 20 September 2006 05:16 Go to next message
alanm
Messages: 282
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

Re: how to aletr an '_' parameter [message #194109 is a reply to message #193984] Wed, 20 September 2006 16:54 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
use "_log_deletion_policy"='all'
Re: how to aletr an '_' parameter [message #202700 is a reply to message #194109] Sat, 11 November 2006 02:58 Go to previous messageGo to next message
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
Re: how to aletr an '_' parameter [message #202701 is a reply to message #202700] Sat, 11 November 2006 03:03 Go to previous messageGo to next message
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
Re: how to aletr an '_' parameter [message #202705 is a reply to message #202701] Sat, 11 November 2006 03:47 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI
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.
Re: how to aletr an '_' parameter [message #203140 is a reply to message #202725] Tue, 14 November 2006 01:18 Go to previous messageGo to next message
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
Re: how to aletr an '_' parameter [message #203187 is a reply to message #203140] Tue, 14 November 2006 03:58 Go to previous messageGo to next message
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?

Re: how to aletr an '_' parameter [message #203209 is a reply to message #193984] Tue, 14 November 2006 06:01 Go to previous message
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
Previous Topic: Unable to connect as Sys User
Next Topic: 10g RAC implementation
Goto Forum:
  


Current Time: Fri Dec 09 04:11:23 CST 2016

Total time taken to generate the page: 0.09621 seconds