OraFAQ Forum: Enterprise Manager » log_archive_dest vs. db_recovery_file

Home » RDBMS Server » Enterprise Manager » log_archive_dest vs. db_recovery_file_dest (Oracle 10g R2, Solaris 10 )

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

log_archive_dest vs. db_recovery_file_dest [message #504714]

Wed, 27 April 2011 08:09

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Good day!

I created a new database from multi-instance db server using DBCA.
I'm not that familiar using this tool since I'm more at ease
using scripts.

In DBCA, as default, the flash_recovery_area was set to this path: /appl1/home/oracle/flash_recovery_area and a size of 2Gb.
I've just realized that the said server had it's default log_archive_dest, re: /u1archive/<SID>/SIDarch/.

Would archived logs be written/saved to the log_archive_dest or in the db_recovery_file_dest?

Thanks in advance...

Report message to a moderator

Re: log_archive_dest vs. db_recovery_file_dest [message #504729 is a reply to message #504714]

Wed, 27 April 2011 08:39

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/setup005.htm#sthref247

Look into section 3.5.4.4

FRA takes over precedence

[Updated on: Wed, 27 April 2011 08:40]

Report message to a moderator

Re: log_archive_dest vs. db_recovery_file_dest [message #504734 is a reply to message #504714]

Wed, 27 April 2011 08:56

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I'm not that familiar using this tool since I'm more at easeusing scripts.

Using dbca is not mandatory, why don't you use scripts?

Regards
Michel

Report message to a moderator

Re: log_archive_dest vs. db_recovery_file_dest [message #504739 is a reply to message #504714]

Wed, 27 April 2011 09:16

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Thanks for your immediate reply with references.

If that's the case, will it be good enough of just leave the flash_recovery_area settings as is? And then set the archive_log_dest for my redo archive logs by this command:

ALTER SYSTEM SET log_archive_dest_1='/u1archive/<SID>/SIDarch' SCOPE=SPFILE;

I also didn't set the new dB to ARCHIVELOG MODE yet.

Thank you.

Report message to a moderator

Re: log_archive_dest vs. db_recovery_file_dest [message #504750 is a reply to message #504739]

Wed, 27 April 2011 10:19

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It depends on what you want to achieve.
Do you want to use RMAN to backup?
Do you want to let Oracle manage (delete) your archived logs?
Do you want to have another archive destination?
...?

Regards
Michel

Report message to a moderator

Re: log_archive_dest vs. db_recovery_file_dest [message #504831 is a reply to message #504750]

Wed, 27 April 2011 20:19

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Thanks for this.

But I would rather opted to use the archive log destination already setup in the said multi-instance db server.

Report message to a moderator

Re: log_archive_dest vs. db_recovery_file_dest [message #506241 is a reply to message #504831]

Sat, 07 May 2011 05:01

ashishs
Messages: 40
Registered: May 2011

Member

show parameter log_archive_dest_n;
thi'll shows list of destination parameter you can use this command to store archivelog file .
1>shutdown immediate;
2>startup mount;
3>alter system set log_archive_dest_2='location=/home/base/arc1_%t_%s_%r'.arc scope=spfile;
4>alter database open;
now your archivefile go on above location

Report message to a moderator

Re: log_archive_dest vs. db_recovery_file_dest [message #506244 is a reply to message #506241]

Sat, 07 May 2011 06:10

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Ashishs, you have made a couple of mistakes:

Steps 1 and 2 and 4: unnecessary, the parameter is dynamic.

Step 3: this is all wrong. First, the location must be a directory, not a file. Second, you can't use percent variables here. Third, your closing quote is in the wrong place. Fourth, the scope should be BOTH, not SPFILE.

Apart from that, fine!
Regards, John.

Report message to a moderator

Previous Topic:	JDK 1.6.0 SR6
Next Topic:	Enterprise manager installation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 05:04:39 CST 2024