Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with ORACLE backup

Status
Not open for further replies.

skif1977

IS-IT--Management
Jul 27, 2005
9
UA
I am sorry because I am beginer in NETWORKER, butI have a problem with oracle backup
I want to backup online oracle database to remote networker server (one side - winwows 2000 pro+client+NMO Oracle module, server-side - windows 2000 server+networker server)
1. Can I do oracle backup from client side to server side?
2. If I can do it, why I have trouble with. I create script -
--------------------------------
run
{
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=utcbwsrv.tci.ukrtelecom.net,
NSR_DATA_VOLUME_POOL=Full)';

backup full filesperset 4 (database);

release channel t1;
release channel t2;
}------------------------------------
where utcbwsrv.tci.ukrtelecom.net - remote neworker server
------------------------------------
after running I have error message like this
------------------------------------
g:\>rman target sys/sys@symon rcvcat rman/rman@song cmdfile g:\rmscr.txt_beg.txt


Recovery Manager: Release 8.1.7.0.0 - Production

RMAN-06005: connected to target database: SYMON (DBID=1501931370)
RMAN-06008: connected to recovery catalog database

RMAN> run
2> {
3> allocate channel t1 type 'SBT_TAPE';
4> allocate channel t2 type 'SBT_TAPE';
5> send 'NSR_ENV=(NSR_SERVER=utcbwsrv.tci.ukrtelecom.net, NSR_DATA_VOLUME_POOL=F
ull)';
6>
7> backup full filesperset 4 (database);
8>
9> release channel t1;
10> release channel t2;
11> }
12>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=13 devtype=SBT_TAPE
RMAN-08526: channel t1: NMO v4.1.0.0

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t2
RMAN-08500: channel t2: sid=8 devtype=SBT_TAPE
RMAN-08526: channel t2: NMO v4.1.0.0

RMAN-03022: compiling command: send
RMAN-06421: sent command to channel: t1
RMAN-06421: sent command to channel: t2

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting full datafile backupset
RMAN-08502: set_count=52 set_stamp=564755438 creation_time=27-JUL-05
RMAN-08010: channel t1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00004 name=G:\ORACLE\ORADATA\SYMON\DATA_O1.DBF
RMAN-08522: input datafile fno=00003 name=G:\ORACLE\ORADATA\SYMON\ROLLBACK.ORA
RMAN-08522: input datafile fno=00002 name=G:\ORACLE\ORADATA\SYMON\TEMP_01.DBF
RMAN-08008: channel t2: starting full datafile backupset
RMAN-08502: set_count=53 set_stamp=564755438 creation_time=27-JUL-05
RMAN-08010: channel t2: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00001 name=G:\ORACLE\ORADATA\SYMON\SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00006 name=G:\ORACLE\ORADATA\SYMON\INDX_01.DBF
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19506: failed to create sequential file
, name="1kgqiuve_1_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: SBT error 7501 in function sbtbackup - sbterror did not return error
message
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECRE
ATE

Recovery Manager complete.
-------------------------------------
If I do backup any files through, by way of "NETWORKER USER" - all right backuped.
Where my mistake or error?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top