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

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. Received on Tue Dec 05 2006 - 10:29:35 CST