Re: Large pages
From: <hhkrohn_at_gmail.com>
Date: Thu, 22 Nov 2012 12:59:45 -0800 (PST)
Message-ID: <e3b290ed-07d4-4ad4-8480-c0b33ce586e9_at_googlegroups.com>
Den torsdag den 22. november 2012 01.02.45 UTC+1 skrev Noons:
> On Nov 20, 10:01 pm, hhkr..._at_gmail.com wrote:
>
>
>
> > That's interesting... My reason for requesting the cio mount option for some AIX jfs2 filesystems (which BTW don't contain anything but Oracle .dbf files) is that otherwise any attempt at accessing the .dbf files from "outside" - cp or TSM ARCHIVE - fails with "Invalid argument" because the Oracle instance has the file open with the cio option due to filesystemio_options = SETALL, but the utility attempts to open the file without cio.
>
> >
>
> > My need for this is caused by some .dbf files for a READ ONLY tablespace, which I want to archive on tape, preferably without first taking the tablespace OFFLINE, which is the only workaround I have found. I'm on AIX 5.3.
>
>
>
>
>
> Upgrade to Aix 7.1. Just confirmed this morning: database files in
>
> jfs2 fs not mounted in cio mode and opened by Oracle in cio mode can
>
> certainly be concurrently read by CP and moved somewhere else. That
>
> is what you were trying to do with the readonly ts datafile, is it not?
Date: Thu, 22 Nov 2012 12:59:45 -0800 (PST)
Message-ID: <e3b290ed-07d4-4ad4-8480-c0b33ce586e9_at_googlegroups.com>
Den torsdag den 22. november 2012 01.02.45 UTC+1 skrev Noons:
> On Nov 20, 10:01 pm, hhkr..._at_gmail.com wrote:
>
>
>
> > That's interesting... My reason for requesting the cio mount option for some AIX jfs2 filesystems (which BTW don't contain anything but Oracle .dbf files) is that otherwise any attempt at accessing the .dbf files from "outside" - cp or TSM ARCHIVE - fails with "Invalid argument" because the Oracle instance has the file open with the cio option due to filesystemio_options = SETALL, but the utility attempts to open the file without cio.
>
> >
>
> > My need for this is caused by some .dbf files for a READ ONLY tablespace, which I want to archive on tape, preferably without first taking the tablespace OFFLINE, which is the only workaround I have found. I'm on AIX 5.3.
>
>
>
>
>
> Upgrade to Aix 7.1. Just confirmed this morning: database files in
>
> jfs2 fs not mounted in cio mode and opened by Oracle in cio mode can
>
> certainly be concurrently read by CP and moved somewhere else. That
>
> is what you were trying to do with the readonly ts datafile, is it not?
Yep, that's what I was trying to achieve. Thanks for testing this, I'll be sure to remember this if we ever get to upgrade AIX - as of now we're on AIX 5.3 ML08, so I cannot even get to play with 11gR2.
( I say *if* we ever get to upgrade: These AIX boxes also host some Oracle 8.1.7.4 databases (don't laugh), which we cannot upgrade because an application based on Webdb 2.2 - stop that laughter, I said! )
BTW I have only made small attempts at looking into large pages on AIX, but your old blog entry on dbasrus.blogspot.dk about how to do it is bookmarked for when I finally get the time! Received on Thu Nov 22 2012 - 21:59:45 CET