Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RAC, ASM, and SQL-BackTrack.....

Re: RAC, ASM, and SQL-BackTrack.....

From: oracle_man <oracle_man_at_yahoo.com>
Date: 5 Dec 2006 22:02:10 -0800
Message-ID: <1165384930.168437.163580@l12g2000cwl.googlegroups.com>

hpuxrac wrote:
> oracle_man wrote:
> > DA Morgan wrote:
> > > oracle_man wrote:
> > > > Anyone out there using RAC, ASM SQL-BackTrack on AIX? I have tried to
> > > > configure, and worked with BMC support, and they say they can't backup
> > > > archived redo's that reside in ASM recovery area. Anyone else come
> > > > across this?
> > > >
> > > > replies appreciated either in this thread or send to oracle_man(don't
> > > > spam me) @yahoo.com
> > > >
> > > > remove (don't spam me)
> > > >
> > > > Rich
> > >
> > > To back up ASM ... use RMAN.
> > > --
> > > Daniel A. Morgan
> > > University of Washington
> > > damorgan_at_x.washington.edu
> > > (replace x with u to respond)
> > > Puget Sound Oracle Users Group
> > > www.psoug.org
> >
> > Thanks Daniel, I need to get it to tape. Here is the latest script I
> > cooked up:
> >
> > run {
> > allocate channel oem_disk_backup device type disk;
> > recover copy of database with tag 'ORA$OEM_LEVEL_0';
> > backup incremental level 1 cumulative copies=1 for recover of copy with
> > tag
> > 'ORA$OEM_LEVEL_0' database;
> > release channel oem_disk_backup;
> > allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U'
> > parms
> > 'SBT_LIBRARY=/u02/bmc/obacktrack-6.1.00-64-o10lib/lib10/libobk.so,
> > ENV=(NSR_SERVER=chestnut,
> > NSR_CLIENT=${THE_CLIENT} NSR_GROUP=tape),
> > NSR_DATA_VOLUME_POOL=mango_full';
> > backup archivelog all not backed up;
> > backup copy of database from tag='ORA$OEM_LEVEL_0';
> > delete noprompt obsolete recovery window of 31 days device type
> > 'SBT_TAPE';
> > }
> >
> >
> > I'm still getting the following:
> >
> >
> > RMAN> run {
> > 2> allocate channel oem_disk_backup device type disk;
> > 3> recover copy of database with tag 'ORA$OEM_LEVEL_0';
> > 4> backup incremental level 1 cumulative copies=1 for recover of copy
> > with tag
> > 5> 'ORA$OEM_LEVEL_0' database;
> > 6> release channel oem_disk_backup;
> > 7> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U'
> > 8> parms
> > 'SBT_LIBRARY=/u02/bmc/obacktrack-6.1.00-64-o10lib/lib10/libobk.so,
> > 9> ENV=(NSR_SERVER=chestnut,
> > 10> NSR_CLIENT=${THE_CLIENT} NSR_GROUP=tape),
> > 11> NSR_DATA_VOLUME_POOL=mango_full';
> > 12> backup archivelog all not backed up;
> > 13> backup copy of database from tag='ORA$OEM_LEVEL_0';
> > 14> delete noprompt obsolete recovery window of 31 days device type
> > 'SBT_TAPE';
> > 15> }
> >
> > released channel: ORA_DISK_1
> > allocated channel: oem_disk_backup
> > channel oem_disk_backup: sid=370 instance=pocprd1 devtype=DISK
> >
> > Starting recover at 05-DEC-06
> > no copy of datafile 1 found to recover
> > no copy of datafile 2 found to recover
> > no copy of datafile 3 found to recover
> > no copy of datafile 4 found to recover
> > no copy of datafile 5 found to recover
> > no copy of datafile 9 found to recover
> > Finished recover at 05-DEC-06
> >
> > Starting backup at 05-DEC-06
> > channel oem_disk_backup: starting incremental level 1 datafile
> > backupset
> > channel oem_disk_backup: specifying datafile(s) in backupset
> > input datafile fno=00005
> > name=+DG_01/pocprd/datafile/users.264.607098261
> > input datafile fno=00003
> > name=+DG_01/pocprd/datafile/sysaux.261.607098253
> > input datafile fno=00001
> > name=+DG_01/pocprd/datafile/system.259.607098243
> > input datafile fno=00004
> > name=+DG_01/pocprd/datafile/undotbs2.263.607098259
> > input datafile fno=00002
> > name=+DG_01/pocprd/datafile/undotbs1.260.607098251
> > input datafile fno=00009
> > name=+DG_01/pocprd/datafile/poctst_data.289.607421897
> > channel oem_disk_backup: starting piece 1 at 05-DEC-06
> > channel oem_disk_backup: finished piece 1 at 05-DEC-06
> > piece
> > handle=+BK_01/pocprd/backupset/2006_12_05/nnndn1_tag20061205t074808_0.315.608370489
> > tag=TAG20061205T074808 comment=NONE
> > channel oem_disk_backup: backup set complete, elapsed time: 00:00:55
> > channel oem_disk_backup: starting incremental level 1 datafile
> > backupset
> > channel oem_disk_backup: specifying datafile(s) in backupset
> > including current control file in backupset
> > including current SPFILE in backupset
> > channel oem_disk_backup: starting piece 1 at 05-DEC-06
> > channel oem_disk_backup: finished piece 1 at 05-DEC-06
> > piece
> > handle=+BK_01/pocprd/backupset/2006_12_05/ncsnn1_tag20061205t074808_0.314.608370545
> > tag=TAG20061205T074808 comment=NONE
> > channel oem_disk_backup: backup set complete, elapsed time: 00:00:03
> > Finished backup at 05-DEC-06
> >
> > released channel: oem_disk_backup
> >
> > RMAN-00571: ===========================================================
> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> > RMAN-00571: ===========================================================
> > RMAN-03009: failure of allocate command on oem_sbt_backup1 channel at
> > 12/05/2006 07:49:07
> > ORA-19554: error allocating device, device type: SBT_TAPE, device name:
> > ORA-27209: syntax error in device PARMS - unknown keyword or missing =
> >
> > RMAN>

>

> Looks like you should keep working with BMC.
>

> There's something wrong with how you have your tape mml configuration
> specified?
>

> The BMC product should have a manual that includes details of what
> parms to specify and how to code them. Do a standalone backup of
> "almost anything" ( copy controlfile maybe ) to tape until you get the
> product parameters setup against your mml.

BMC doesn't support archived redo logs in ASM recovery area. It will backup the data files, but not the archived redo's. It just pukes. So, I tried an NFS mount for archived redo log location, and only to find out that Oracle STANDARD EDITITION doesn't suppor NFS.

I'm running out of options. Received on Wed Dec 06 2006 - 00:02:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US