I had executed RMAN scripts to take complete backup into another disk, successfully. When I try to take backup even a single tabespace into the tape, it shows proper messages but finally hangs. The script is this:-
allocate channel t1 type 'SBT_TAPE';
backup tablespace "USERS"
The output message generated is :-
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=14 devtype=SBT_TAPE
RMAN-08526: channel t1: MMS Version 18.104.22.168
RMAN-03022: compiling command: backup
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting full datafile backupset
RMAN-08502: set_count=20 set_stamp=457527712 creation_time=26-MAR-02
RMAN-08010: channel t1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00005 name=/oradata/oradata/mapsmts/users01.dbf
After getting this message it is neither completeting the execution nor putting anything into the tape
Can anyone point out the reason for this improper functioning of this script.
Thanks in Advance
What does your backup software say?
i'm not sure what exactly your error is but u can try this thing -
first instead of taking backup on SBT_TAPE use DISK and take a backup on the hardisk wherever ur catalog is there. if it work sucessfully , may take sometime, then there is no problem with the RMAN. there might be some problem in TAPE itself. or wait for some more time as it will take some more time that the disk backup and see.
8i OCP DBA
Click Here to Expand Forum to Full Width