Backup of Oracle 9i

Joshua:

Try with this rman script

run {
allocate channel t1 type 'SBT_TAPE' parms 'NSR_ENV=(NSR_SERVER=backup.mydomain.com, NSR_CLIENT=oracle.mydomain.com,NSR_DATA_VOLUME_POOL=DEFAULT));
backup full (database format '/FULL_%d_%u);
sql "alter system switch logfile";
sql "alter system archive log current";
change archivelog all validate;
backup (archivelog all delete input);
backup current controlfile;
release channel t1;
}

Is possible to send error??

Joshua:

Please send errors to evaluate problem. You defined nsrnmo script in Legato Bin directory?

Backup is with Catalog or nocatalog?

Regards

Joshua:

Sorry, the script have a fail.

This is correct script

run {
allocate channel t1 type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=mq500,NSR_CLIENT=coihue_t,NSR_DATA_VOLUME_POOL=Default,NSR_SAVESET_EXPIRATION=2days))';
backup full
(database format '/FULL_%d_%u/');
sql "alter system switch logfile";
sql "alter system archive log current";
resync catalog;
change archivelog all validate;
backup (archivelog all delete input);
backup current controlfile;
release channel t1;
}

This is from the client not even trying it with the nsrnmo.bat script yet. Not sure about the catalog question if you point me in the direction I will find that out if needed.

Thanks.

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN> run {
2> allocate channel t1 type 'SBT_TAPE' parms 'NSR_ENV=(NSR_SERVER=fileserv2.cirl
aw.com,
3>
4> NSR_CLIENT=dbaseserv2.cirlaw.com,NSR_DATA_VOLUME_POOL=DEFAULT));
5> backup full (database format '/FULL_%d_%u); sql "alter system switch logfile"
; sql "alter system archive log

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signalled during parse
RMAN-02001: unrecognized punctuation symbol "/"

RMAN>

RMAN> current"; change archivelog all validate; backup (archivelog all delete in
put); backup current controlfile;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "current": expecting one of: "allocate, alter, b
ackup, beginline, blockrecover, catalog, change, connect, copy, create, crossche
ck, configure, duplicate, debug, delete, drop, exit, endinline, host, {, library
, list, mount, open, print, quit, recover, register, release, replace, report, r
enormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, spoo
l, startup, shutdown, send, show, test, upgrade, validate"
RMAN-01007: at line 2 column 1 file: standard input

RMAN>

RMAN> release channel t1; }

Here is what I have:


connected to target database: ORCL (DBID=1099560418)
using target database controlfile instead of recovery catalog

RMAN> run {
2> allocate channel t1 type 'SBT_TAPE'
3> parms
4>
5> 'ENV=(NSR_SERVER=fileserv2.cirlaw.com,NSR_CLIENT=dbaseserv.cirlaw.com,NSR_DAT
A_VOLUME_POOL=Default,NSR_SAV
6> ESET_EXPIRATION=14days))';
7> backup full
8> (database format '/FULL_%d_%u/');
9> sql "alter system switch logfile";
10> sql "alter system archive log current";
11> resync catalog;
12> change archivelog all validate;
13> backup (archivelog all delete input);
14> backup current controlfile;
15> release channel t1;
16> }

allocated channel: t1
channel t1: sid=34 devtype=SBT_TAPE
channel t1: MMS Version 0.0.0.0

Starting backup at 02-MAY-06
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00011 name=K:\CDS\CDSACT.DAT
input datafile fno=00012 name=K:\CDS\CDSACT.IDX
input datafile fno=00013 name=K:\CDS\CDSARC.DAT
input datafile fno=00014 name=K:\CDS\CDSARC.IDX
input datafile fno=00002 name=K:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
input datafile fno=00001 name=K:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
input datafile fno=00015 name=K:\CDS\CDSRMT.DAT
input datafile fno=00004 name=K:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF
input datafile fno=00016 name=K:\CDS\CDSRMT.IDX
input datafile fno=00017 name=K:\CDS\CDSMSC.DAT
input datafile fno=00018 name=K:\CDS\CDSMSC.IDX
input datafile fno=00009 name=K:\ORACLE\ORADATA\ORCL\XDB01.DBF
input datafile fno=00005 name=K:\ORACLE\ORADATA\ORCL\INDX01.DBF
input datafile fno=00008 name=K:\ORACLE\ORADATA\ORCL\USERS01.DBF
input datafile fno=00003 name=K:\ORACLE\ORADATA\ORCL\DRSYS01.DBF
input datafile fno=00006 name=K:\ORACLE\ORADATA\ORCL\ODM01.DBF
input datafile fno=00010 name=K:\ORACLE\ORADATA\ORCL\CWMLITE01.DBF
input datafile fno=00007 name=K:\ORACLE\ORADATA\ORCL\TOOLS01.DBF
channel t1: starting piece 1 at 02-MAY-06
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 05/02/2006 17:05:15
ORA-19506: failed to create sequential file, name="/FULL_ORCL_05hi2tu9/", parms=
""
ORA-27007: failed to open file
ORA-19511: Error received from media manager layer, error text:
SBT error = 7009, errno = 116154132, sbtopen: can't connect with media manage
r

RMAN>

Joshua:

NMO is already install?

Shutdown Oracle instances and copy orasbt.dll for $ORACLE_HOME/bin, Startup oracle instances and try again with script.

Is a problem in rman with not loaded SBT_TAPE how a valid type.

Joshua:

With svrmgrl or sqlplus steps are:

1. svrmgrl
2. shutdown immediate;
3. Copy orasbt.dll to $ORACLE_HOME/bin
4. startup

Regards

Thank you for helping with this. I am not familiar with Oracle but will assume that by taking the instance offline this is a services shutdown.

What are the steps I need to take to safely perform this so that I can get this database backed up? Thanks.

Just to be clear before moving forward.

I can go the the Enterprise Manager and Shutdown the Database, copy the orasbt.dll file that is located in c:\program files\legato\nsr\bin to the c:\ora92\bin folder, then in the console again startup the database. From this point I will re-run my RMAN script from the Oracle server.

Having never worked with Oracle I am trying to tread as lightly as I can before moving forward just to be safe.

Many thanks for all your help with this.