ADSM-L

Re: ADSM Oracle agent for NT

1999-10-08 08:05:06
Subject: Re: ADSM Oracle agent for NT
From: Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US>
Date: Fri, 8 Oct 1999 08:05:06 -0400
Hi Herfried:
Thank you. I'll pass along the sample backup script to our ORACLE DBA's. I 
believe the client is set up correctly, but there is no content to the .cmd 
file for initiating the backup.
I do have another other question. I would expect the attemp at the backup to 
show as failed on the events log, but nothing displays at all. And checking the 
activity log it appears there is a license problem, but the node has been 
registered successfully with the server:

q node

ORACLARK                  WinNT    ORANT                  <1          2   No

adsm> q sched orant daily_orabkup

Domain       * Schedule Name    Action Start Date/Time      Duration Period Day
------------ - ---------------- ------ -------------------- -------- ------ ---
------ ---
ORANT          DAILY_ORABKUP    CMD    10/06/99   02:00:00     15 M    1 D 
ORANT          DAILY_ORABKUP    CMD    10/06/99   02:00:00     15 M    1 D  Any

Activity Log 
------------
Date and Time       Message                                                Date 
and Time       Message                                                          
                     
----------------------------------------------------------------------------------------------------------
-------------------------------
10/08/1999 02:02:43 ANR2841W Server is NOT IN COMPLIANCE with license 
10/08/1999 02:02:43 ANR2841W Server is NOT IN COMPLIANCE with license terms.    
                          
10/08/1999 02:02:43 ANR0406I Session 3806 started for node ORACLARK (WinNT) 
(Tcp/Ip 172.30.1.215(1827)).  
10/08/1999 02:02:44 ANR0403I Session 3806 ended for node ORACLARK (WinNT).      
                          
10/08/1999 02:02:44 ANR2841W Server is NOT IN COMPLIANCE with license terms.    
                          
10/08/1999 02:02:44 ANR0406I Session 3807 started for node ORACLARK (WinNT) 
(Tcp/Ip 172.30.1.215(1828)).  
10/08/1999 02:02:44 ANR0403I Session 3807 ended for node ORACLARK (WinNT).      
                          
10/08/1999 02:06:24 ANR2841W Server is NOT IN COMPLIANCE with license terms.   

Any suggestions as to why this message would issue?

Regards,
Larry Clark
NYS THRUWAY
                  





>>> Herfried Abel <HA7 AT DAIMLERCHRYSLER DOT COM> 10/08/99 02:34AM >>>
Hi Larry,
we use Oracle 8 on AIX, but as far as I know rman syntax is the same on all
plattforms. As I remember, this is the way how RMAN <> ORACLE Backup works:

1) You have to generate an RMAN - Oracle Database ( This will hold the
information of all backups/restores )
2) Generate the Recovery Catalog in the RMAN DB
3) Make the database you want to backup known to RMANs recovery catalog.
4) Set up ADSM Policies and everything you need in the ADSM zone to operate with
the backups ( e,g set up a new NODE )
5) Write RMAN scripts to do your backups ( This can eighter be "shell-scripts"
stored on file or stored within the Rman DB.
( For details pls have a look at the Oracle Manuals )

Here is a example how I do a full backup:

--------------------------------------------------------- SHELL SCRIPT (
COMMANDLINE)  BEGIN
COMMANDLINE)  BEGIN
------------------------------------------------------------------------
rman target internal/passwd@TARGET rcvcat rman/passwd@RMANDB cmdfile
rman target internal/passwd@TARGET rcvcat rman/passwd@RMANDB cmdfile
Filename_of_RMANSCRIPT

--------------------------------------------------------- SHELL SCRIPT END
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 RMAN SCRIPT ----------------------------------------------------------- RMAN 
SCRIPT BEGIN
BEGIN
------------------------------------------------------------------------
run
run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(DSMI_ORC_CONFIG=/usr/lpp/adsm/bin/dsm.opt, DSMO_AVG_SIZE=1024,
DSMO_NODE=EURO, DSMO_PSWDPATH=/usr/lpp/adsm/bin, DSMO_AVG_SIZE=5,
DSMO_FS=adsmeuro)';

sql 'alter system archive log current';

backup
     incremental level =0
     format 'full_%s_%p_%d_%t'
     (datafile 1,2,3,4,5 channel t1)
     (current controlfile);
release channel t1;

allocate channel t3 type 'sbt_tape' parms
'ENV=(DSMI_ORC_CONFIG=/usr/lpp/adsm/bin/dsm.opt, DSMO_AVG_SIZE=1024,
DSMO_NODE=EURO, DSMO_PSWDPATH=/usr/lpp/adsm/bin, DSMO_AVG_SIZE=5,
DSMO_FS=adsmeuro)';

backup
     format 'archlog_%s_%p_%d_%t'
     (archivelog all filesperset = 100 delete input);
release channel t3;
}
----------------------------------------------------------- RMAN SCRIPT END  
----------------------------------------------------------------------END  
------------------------------------------------------------------------
Hope this helps
Hope this helps

herfried





Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US> on 07.10.99 17:22:20

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



 To:      ADSM-L AT VM.MARIST DOT EDU 

 cc:



 Subject: ADSM Oracle agent for NT








Hi:
I'm finding the documentation for the ADSM ORACLE agent for NT confusing. After
completeing the install it does not explain how to initiate a backup and there
appears to be no GUI. Following on, the manual describes setting up a separate
instance of the schedular to initate backups via the schedular and a command
file that has ORACLE8 RMAN commands.

It also gives no examples of what these RMAN command scripts might be. I'm not a
database person and our ORACLE people are not acqauinted with RMAN. I've glanced
thru the enormous ORACLE backup manual for release 8 and it appears to require a
specific allocation of a target device, e.g., a tape or disk, and yet from the
ADSM install this should be transparant since the backup group is already
associated with a copypool. Does anyone have any experience with this Agent.
ADSM tech support seem to have no experience with it al all.

Larry Clark
NYS Thruway Authority
<Prev in Thread] Current Thread [Next in Thread>