| Creating Archivelog in Network drive [message #517938] |
Fri, 29 July 2011 10:17  |
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 #518499 is a reply to message #517946] |
Thu, 04 August 2011 03:27  |
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 #519733 is a reply to message #518499] |
Tue, 16 August 2011 10:29 |
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 #519746 is a reply to message #519738] |
Tue, 16 August 2011 11:08 |
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 #519851 is a reply to message #519754] |
Wed, 17 August 2011 04:32 |
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 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
