RE: remote server for log_archive_dest

Fuad,  

So you have a dir (that is NFS mount)... and you use RMAN to "move" and NOT "copy", and NOT "backup"... and your ARCH LOGS in LOG_ARCHIVE_DEST_n can now be found on this (NFS) dir?  

Can you send example RMAN syntax?
Will the RMAN syntax fail if a log is missing (validation of each log) or does this just "move" what is found?
And this meets the two requirements identified by Mark Bole's email (below);

• copy a file...completely written and closed.
• copy only those files, which haven't already been copied

I'm very interested in this subject. I have home grown standby DB and I would like to improve or reduce my synchronization code/time/complexity and this might work.  

Thanks,
Chris Marquez
Oracle DBA    

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark Bole
Sent: Wednesday, August 24, 2005 12:02 PM Cc: oracle-l_at_freelists.org
Subject: Re: remote server for log_archive_dest  

For successful user-managed archived redo log backups, you must duplicate two key features of automated log transport:  

1. don't copy a file until it is completely written and closed.
2. copy those files, and only those files, which haven't already been copied (due to network outages, target system down, whatever).

For item 1, you can query the database (SELECT THREAD#,SEQUENCE#,NAME FROM V$ARCHIVED_LOG;) or, on most flavors of Unix, the "fuser" command can determine whether a process currently has a file open. (I am not aware of a "fuser" equivalent under Windows).  

For item 2, the rsync command works great, either using ssh to a remote server (as described below) or on any network-mounted filesystem. On Windows, the robocopy.exe utility duplicates most of rsync's functionality but only with a mounted filesystem, not a remote server.  

--
Mark Bole
http://www.bincomputing.com

 
 
 

________________________________

From: oracle-l-bounce_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fuad Arshad

Sent: Wednesday, August 24, 2005 9:58 AM
To: badauy_at_avaya.com; peterdixon001_at_hotmail.com; oracle-l_at_freelists.org
Subject: RE: remote server for log_archive_dest


The way we dod it is have a script that copies this to  a nfs mount .
we run it with have rman move so basically it checks  if the file is
already there  if it is it doesnt copy  if not  it copies it over. this
makes us  have archivelogs in non rman format since we have encountered
issues in the past with getting  rman formatted logs form tape.

"Badauy, Gustavo (Gustavo)" <badauy_at_avaya.com> wrote:

	I would create a script that runs every x minutes and ftp to the
	location and remove it afterward. What do you think about it?
	
	
	| Gustavo Badauy| Avaya Brasil |
	| Rua Lauro Muller 116, Sala 1201 | Rio de Janeiro, RJ | CEP
22290-160 |
	| Tel. +55 21 2125-7441 | Fax. +55 21 2125-7411 |
badauy_at_avaya.com | 
	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org
	[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter Dixon
	Sent: Wednesday, August 24, 2005 7:42 AM
	To: oracle-l_at_freelists.org
	Subject: remote server for log_archive_dest
	
	I am wanting to write my archive logs to a different server to
the one
	my 
	database runs on.
	
	This server will not be running Oracle therefore I can't send
the
	archive 
	job via NET8, i currently send the file via FTP but is there a
slicker 
	method
	
	Peter Dixon
	Database Te am Leader
	
	
	--
	http://www.freelists.org/webpage/oracle-l
	
	--
	http://www.freelists.org/webpage/oracle-l
	


--
http://www.freelists.org/webpage/oracle-l