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

From: oracle_man <oracle_man_at_yahoo.com>
Date: 5 Dec 2006 07:59:35 -0800
Message-ID: <1165334375.472805.89510@80g2000cwy.googlegroups.com>

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> Received on Tue Dec 05 2006 - 09:59:35 CST