Home » RDBMS Server » Enterprise Manager » log_archive_dest vs. db_recovery_file_dest (Oracle 10g R2, Solaris 10 )
log_archive_dest vs. db_recovery_file_dest [message #504714] Wed, 27 April 2011 08:09 Go to next message
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...
Re: log_archive_dest vs. db_recovery_file_dest [message #504729 is a reply to message #504714] Wed, 27 April 2011 08:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: log_archive_dest vs. db_recovery_file_dest [message #504739 is a reply to message #504714] Wed, 27 April 2011 09:16 Go to previous messageGo to next message
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.





Re: log_archive_dest vs. db_recovery_file_dest [message #504750 is a reply to message #504739] Wed, 27 April 2011 10:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: log_archive_dest vs. db_recovery_file_dest [message #504831 is a reply to message #504750] Wed, 27 April 2011 20:19 Go to previous messageGo to next message
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.


Re: log_archive_dest vs. db_recovery_file_dest [message #506241 is a reply to message #504831] Sat, 07 May 2011 05:01 Go to previous messageGo to next message
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
Re: log_archive_dest vs. db_recovery_file_dest [message #506244 is a reply to message #506241] Sat, 07 May 2011 06:10 Go to previous message
John Watson
Messages: 8922
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.

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


Current Time: Thu Mar 28 10:18:11 CDT 2024