Home » RDBMS Server » Backup & Recovery » Creating Archivelog in Network drive (Oracle 11g 11.1.0.7 Standard Edition on windows 2008 server 64 bit)
Creating Archivelog in Network drive [message #517938] Fri, 29 July 2011 10:17 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
My boss has asked me to create Oracle archived log to network drive instead of Local drive.

Is there anyway that i can get my archive log created on network drive instead of local drive.

As we want to save our storage space and want to keep archivelog on network.

Is there a way that if Archive log creation on Network drives falis, Oracle create Archivelog on Local drive.

We are running Data warehouse and on daily basis we have 22 to 25 Gig of Archive log created

[Updated on: Fri, 29 July 2011 10:24]

Report message to a moderator

Re: Creating Archivelog in Network drive [message #517946 is a reply to message #517938] Fri, 29 July 2011 11:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there anyway that i can get my archive log created on network drive instead of local drive.

Not in Windows.

Quote:
Is there a way that if Archive log creation on Network drives falis, Oracle create Archivelog on Local drive

Generally speaking, there is a way to switch for a destination to another one.
See ALTERNATE and REOPEN options of LOG_ARCHIVE_DEST_n (follow the links).

Regards
Michel
Re: Creating Archivelog in Network drive [message #518499 is a reply to message #517946] Thu, 04 August 2011 03:27 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
I already have archive log created in Flash_recovery_area/ARCHIVELOG folder (Locally in Database),
so is it possible to add optional destination by using LOG_ARCHIVE_DEST_1=<network address>.

So that next time archivelog will be created on both places in Flash_recovery_area/ARCHIVELOG and in LOG_ARCHIVE_DEST_1=<network address>.

And after this if network drive is not accessable then, it will only create archivelog in Flash_recovery_area/ARCHIVELOG folder
and will not halt database operation
Re: Creating Archivelog in Network drive [message #518501 is a reply to message #518499] Thu, 04 August 2011 03:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I already answered this, read again my previous post.

Regards
Michel
Re: Creating Archivelog in Network drive [message #519733 is a reply to message #518499] Tue, 16 August 2011 10:29 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
I am running following command but there is an error
alter system set log_archive_dest_1='LOCATION=Z:\ ALTERNATE=LOG_ARCHIVE_DEST_10'


ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-09291: sksachk: invalid device specified for archive destination
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 3) The system cannot find the path specified.
Re: Creating Archivelog in Network drive [message #519734 is a reply to message #519733] Tue, 16 August 2011 10:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>O/S-Error: (OS 3) The system cannot find the path specified.
so fix this
Re: Creating Archivelog in Network drive [message #519736 is a reply to message #519734] Tue, 16 August 2011 10:35 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
z:\ is the network drive (SAN box) and i can access the drive from server
What can be the problem?

[Updated on: Tue, 16 August 2011 10:38]

Report message to a moderator

Re: Creating Archivelog in Network drive [message #519738 is a reply to message #519736] Tue, 16 August 2011 10:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>z:\ is the network drive (SAN box) and i can access the drive from server
>What can be the problem?


what is difference between "SAN box" and network drive?
Re: Creating Archivelog in Network drive [message #519744 is a reply to message #519736] Tue, 16 August 2011 11:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
MIFI wrote on Tue, 16 August 2011 17:35
z:\ is the network drive (SAN box) and i can access the drive from server
What can be the problem?


Oracle does not support nertwork drive (unless you cut down security).

Regards
Michel

Re: Creating Archivelog in Network drive [message #519746 is a reply to message #519738] Tue, 16 August 2011 11:08 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
i am trying to find out that the
LOCATION parameter is always works with Local drive
and Service works when destination has oracle installed then how Can we create archive log in network or SAN drive
Re: Creating Archivelog in Network drive [message #519749 is a reply to message #519746] Tue, 16 August 2011 11:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>how Can we create archive log in network or SAN drive
submit Service Request to obtain answer
Re: Creating Archivelog in Network drive [message #519750 is a reply to message #519749] Tue, 16 August 2011 11:23 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
How do i create service for SAN box, when there is no Listener running on SAN box
Re: Creating Archivelog in Network drive [message #519754 is a reply to message #519750] Tue, 16 August 2011 12:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: Creating Archivelog in Network drive [message #519851 is a reply to message #519754] Wed, 17 August 2011 04:32 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
So it means that i can not create archive log to the network drive,
Is there any way in Oracle to Copy archive log to network drive whenever it is created?
Because my boss is very confident that we can create archive log in SAN box.
I want clear this doubt

Re: Creating Archivelog in Network drive [message #519860 is a reply to message #519851] Wed, 17 August 2011 05:14 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any way in Oracle to Copy archive log to network drive whenever it is created?

Yes and no.
It is easy to create an AT command (or use Windows scheduler) to move them periodically (every 5 minutes for instance).
You can also do this with Oracle scheduler (see DBMS_SCHEDULER).

Regards
Michel
Previous Topic: unable to see tablespace name
Next Topic: restore archivelog
Goto Forum:
  


Current Time: Thu Mar 28 07:49:29 CDT 2024