how to duplex archive logs in RAC DB?
G777Mar 20 2012 — edited Mar 21 2012Hi
I need to set up alternative, local disk location for archive logs for both RAC nodes, outside ASM.
The reason behind it is to transfer the logs (along with full backups) to remote location to ensure security of data.
I have mapped same remote directory as R: drive on both nodes.
11.2.0.2 RAC Standard 2-nodes database
Windows 2008 R2 Standard
+DATA ASM Storage
SYS@proton2x1> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1750
Next log sequence to archive 1752
Current log sequence 1752
SYS@proton2x1> show parameter recov
NAME TYPE VALUE
db_recovery_file_dest string +DATA
----
The problem is when I set duplex location:
SQL> alter system set log_archive_duplex_dest='LOCATION=R:' SCOPE=spfile;
restart nodes and switch online logs 3 times it hangs and no archiive logs are written in R:\ directory.
alert log says:
LGWR: Error 16017 validating archivelog destination information
I played in similar way with other parameters:
alter system set log_archive_dest_1='LOCATION=+DATA MANDATORY' SCOPE=spfile;
alter system set log_archive_dest_2='LOCATION=R: OPTIONAL' SCOPE=spfile;
with same issue.
The question is, how to set up second location for archivelogs, outside ASM storage?
or maybe someone has another idea how to transfer/copy archivelogs to a remote storage?
I though about 'cp' command on asmcmd tool but it would be hard to sync source and target locations.