Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
• ORA 12540: TNS:internal limit restriction exceeded
• ORA 12838 please : Is possible to append two times to the same table befo
• ORA 12838 please : Is possible to append two times to the same table before
• ora 04031
• ora 12500 on windows
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ora 12500 on windows
• ORA 01650, one idea
• ORA 01650
• ORA 4030
• ORA 12838 please : Is possible to append two times to thesametable before do
• ORA 12838 please : Is possible to append two times to thesame table before d
• ORA 01536
• ORA 03113 end of file on communication channel
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 00600:
• ORA 00020: maximum number of processes (%s) exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 01650, one idea
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650
• ORA 01650
• ORA 01031
• ORA 4030
• ORA 4030
• ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
• ORA 01722 invalid number
 
AW: [suse-oracle] RAC - archived logs on NFS

AW: [suse-oracle] RAC - archived logs on NFS

2007-02-27       - By Frank Westheider

 Back
Hi !

You have to cross-mount the NFS-Filesystems for archlogs on the 2 machines
in different dir-names.

Example:

Machine1, Instance PROD1:
/u01/PROD/prod1_logs (local Filesystem)
/u01/PROD/prod2_logs (NFS-Filesystem from machine2)

Machine2, Instance PROD2:
/u01/PROD/prod2_logs (local Filesystem)
/u01/PROD/prod1_logs (NFS-Filesystem from machine1)

You have the 2 locations for archlogs in the spfile-configration per SID:
PROD1.log_archive_dest1='LOCATION=/u01/PROD/prod1_logs'
PROD2.log_archive_dest1='LOCATION=/u01/PROD/prod2_logs'

Then RMAN can ran on either node and can access all archivelogs from the 2
instances on every machine...

Works fine for me, if both instances are up.
Otherwise you have to fiddle with the NFS-Mounts...but normally both
instances are up.

Bye
  Frank

-- --Urspr?ngliche Nachricht-- --
Von: Pinault, Damien [mailto:DPinault@(protected)]
Gesendet: Montag, 26. Februar 2007 17:47
An: suse-oracle@(protected)
Betreff: [suse-oracle] RAC - archived logs on NFS

Hi list,

I am having difficulties backing up archived logs with RMAN in a RAC
environment ( 2 nodes ).
Logs from "other" node are accessible through NFS :

NODE1:~ # more /etc/exports
/u01/oradata/VFAFACP1/logs
*(ro,root_squash,async,anonuidY,anongidT)

NODE2:~ # mount -o soft,intr,rsize?92,wsize?92
172.16.225.66:/u01/oradata/VFAFACP1/logs /u01/oradata/VFAFACP1/logs

Archived logs from NODE2 are in: /u01/oradata/VFAFACP2/logs

I can see the logs on the OS under user oracle.
But RMAN cannot :
===============================================================================
==================archived log /u01/oradata/VFAFACP1/logs/2_4_609519877.dbf not
found or
out of sync with catalog
RMAN-06061 (See http://MAN-06061.ora-code.com): WARNING: skipping archivelog compromises recoverability
===============================================================================
==================Any idea why ?

Tks in advance,

D>
__ ____ ____ ____ ____ ____ ____ ____ ______
Damien Pinault
VFA, Inc.            http://www.vfa.com
__ ____ ____ ____ ____ ____ ____ ____ ______





--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting