Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sbt media library failure

User_4YDQ6Oct 6 2015 — edited Oct 6 2015

Any suggestions would be greatly appreciated.

Had something working, don't know how this has stuffed up the media library. I've checked there is a link

cd $ORACLE_HOME/lib

bash-3.2$ ls -la |grep obk

lrwxrwxrwx   1 root     root          21 Nov 12  2012 libobk.so -> /usr/lib/libnsrora.so

(solaris 10 with legato)

RMAN> run {

2> set command id to 'b12';

3> allocate channel t1 type 'SBT_TAPE' ;

4> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=Full)';

5> backup archivelog all delete  input;

6> release channel t1;

7> }

executing command: SET COMMAND ID

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of allocate command on t1 channel at 10/06/2015 11:50:13

ORA-19554: error allocating device, device type: SBT_TAPE, device name:

ORA-27211: Failed to load Media Management Library

Additional information: 2

Effects all db's !!

This did work yesterday, changing the destination directory seems to have stuffed it??!!! seems very odd...

RMAN> RUN

2> {

3> set command id to 'b12';

4> allocate channel t1 type sbt_tape ;

5> SET ARCHIVELOG DESTINATION TO '/oradata9/PFIN1_backup_Oct15';

6> RESTORE ARCHIVELOG from logseq=420132 until logseq=420143;

7> }

executing command: SET COMMAND ID

allocated channel: t1

channel t1: SID=510 device type=SBT_TAPE

channel t1: NMDA Oracle v1.2.0

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 05-OCT-2015 22:14:33

channel t1: starting archived log restore to user-specified destination

archived log destination=/oradata9/PFIN1_backup_Oct15

channel t1: restoring archived log

archived log thread=1 sequence=420132

...

archived log thread=1 sequence=420143

channel t1: reading from backup piece dgqiistl_1_1

channel t1: piece handle=dgqiistl_1_1 tag=TAG20151001T003043

channel t1: restored backup piece 1

channel t1: restore complete, elapsed time: 00:03:25

Finished restore at 05-OCT-2015 22:18:02

released channel: t1

[everything is ok]

RMAN> RUN

2> {

3> set command id to 'b12';

4> allocate channel t1 type sbt_tape ;

5> SET ARCHIVELOG DESTINATION TO '/orarecov50/REFbkpPFINbf/arc_Oct15';

6> RESTORE ARCHIVELOG from logseq=420132 until logseq=420143;

7> }

executing command: SET COMMAND ID

allocated channel: t1

channel t1: SID=510 device type=SBT_TAPE

channel t1: NMDA Oracle v1.2.0

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 05-OCT-2015 22:34:43

archived log for thread 1 with sequence 420132 is already on disk as file /oradata9/PFIN1_backup_Oct15/1_420132_617719654.dbf

archived log for thread 1 with sequence 420133 is already on disk as file /oradata9/PFIN1_backup_Oct15/1_420133_617719654.dbf

....

archived log for thread 1 with sequence 420143 is already on disk as file /oradata9/PFIN1_backup_Oct15/1_420143_617719654.dbf

restore not done; all files read only, offline, or already restored

Finished restore at 05-OCT-2015 22:34:44

released channel: t1

[everything still seems ok]

Now I get the above error

FYI

RMAN> show all;

RMAN configuration parameters for database with db_unique_name PFIN1 are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 180 DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/orarecov50/REFbkpPFINbf/cf%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oradata27/product/11.2.0/dbs/snapcf_PFIN1.f'; # default

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 3 2015
Added on Oct 6 2015
1 comment
693 views