Help

Start a discussion

Can2

updated

15 years ago

Solved!

Go to Solution
C

Can2

1 Rookie

•

100 Posts

0

3260

January 13th, 2012 01:00

nmda rman backup log problem

Hi,

  We have upgraded our oracle backup modules from nmo 5 to nmda 1.1. We were setting below parameters for specific logging for rman backup. When we set below parameters with nmda below logs are not generated and it causes log examine problems. Also nmda rman_arguments log does not specifies time like nmo, it shows only date as you can see at below. Have you got any experience about that issue ?

Thanks.

LOG_TIME=`date +%Y%m%d_%H%M`
LOG_FILE=/backup/scripts/central_backup/logs/INIS1A_ARCH_backup_${LOG_TIME}.log
NSR_RMAN_ARGUMENTS="log '${LOG_FILE}' append"

nmo log

Starting backup at 11-JAN-2012 04:01:38

allocated channel: ORA_SBT_TAPE_1

channel ORA_SBT_TAPE_1: sid=2046 instance=INAN1B2 devtype=SBT_TAPE

channel ORA_SBT_TAPE_1: NMO v5.0.0.0

sent command to channel: ORA_SBT_TAPE_1

channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:08

Finished backup at 11-JAN-2012 04:53:29

Starting Control File and SPFILE Autobackup at 11-JAN-2012 04:53:29

piece handle=c-3906235798-20120111-00 comment=API Version 2.0,MMS Version 5.0.0.0

Finished Control File and SPFILE Autobackup at 11-JAN-2012 04:53:50

nmda log

Starting backup at 09-JAN-12

allocated channel: ORA_SBT_TAPE_1

piece handle=INOX2_FULL.nqn0casb_1_1 tag=TAG20120109T230031 comment=API Version 2.0,MMS Version 1.1.0.0

channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:15

Finished backup at 09-JAN-12

Starting Control File and SPFILE Autobackup at 09-JAN-12

piece handle=c-1621838728-20120109-04 comment=API Version 2.0,MMS Version 1.1.0.0

Finished Control File and SPFILE Autobackup at 09-JAN-12

piece handle=INOX2_ARCH.o0n0cavp_1_1 tag=TAG20120109T235249 comment=API Version 2.0,MMS Version 1.1.0.0

channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:08

Finished backup at 09-JAN-12

  • V

    vermad1

    36 Posts

    1288

    0

    Posted January 13th, 2012 09:00

    The output you are talking about is generated by rman and not by NMO/NMDA. Thus date format is controlled by a env variable NLS_DATE_FORMAT. Please check the below link for more information, specially the last post.
    [http://www.dbasupport.com/forums/showthread.php?t=42556 | http://www.dbasupport.com/forums/showthread.php?t=42556]
    and

    [https://forums.oracle.com/forums/thread.jspa?threadID=1121864 | https://forums.oracle.com/forums/thread.jspa?threadID=1121864]
    and
    [http://docs.oracle.com/cd/B10500_01/server.920/a96566/rcmconfg.htm | http://docs.oracle.com/cd/B10500_01/server.920/a96566/rcmconfg.htm]

  • V

    vermad1

    36 Posts

    1288

    0

    Posted January 13th, 2012 05:00

    I have checked it on my Linux server
    NMO
    allocated channel: t1
    channel t1: sid=143 devtype=SBT_TAPE
    channel t1: NMO v5.0.0.0
    sent command to channel: t1

    sent command to channel: t1


    Starting backup at 27-SEP-11
    current log archived
    channel t1: starting archive log backupset
    channel t1: specifying archive log(s) in backup set
    input archive log thread=1 sequence=150 recid=81 stamp=762758269
    input archive log thread=1 sequence=151 recid=82 stamp=762758354
    input archive log thread=1 sequence=152 recid=83 stamp=762758423
    input archive log thread=1 sequence=153 recid=84 stamp=762760042
    input archive log thread=1 sequence=154 recid=85 stamp=762814419
    input archive log thread=1 sequence=155 recid=86 stamp=762869659
    input archive log thread=1 sequence=156 recid=87 stamp=762869681
    input archive log thread=1 sequence=157 recid=88 stamp=762870392
    input archive log thread=1 sequence=158 recid=89 stamp=762870634
    input archive log thread=1 sequence=159 recid=90 stamp=762872956
    input archive log thread=1 sequence=160 recid=91 stamp=762873356
    input archive log thread=1 sequence=161 recid=92 stamp=762873735
    input archive log thread=1 sequence=162 recid=93 stamp=762873928
    input archive log thread=1 sequence=163 recid=94 stamp=762899498
    input archive log thread=1 sequence=164 recid=95 stamp=762899899
    input archive log thread=1 sequence=165 recid=96 stamp=762901507
    input archive log thread=1 sequence=166 recid=97 stamp=762912047
    input archive log thread=1 sequence=167 recid=98 stamp=762969461
    channel t1: starting piece 1 at 27-SEP-11
    channel t1: finished piece 1 at 27-SEP-11
    piece handle=ORCLSOUR_39_1.bak tag=TAG20110927T155741 comment=API Version 2.0,MMS Version 5.0.0.0
    channel t1: backup set complete, elapsed time: 00:00:57
    Finished backup at 27-SEP-11

    Starting backup at 27-SEP-11
    channel t1: starting full datafile backupset
    channel t1: specifying datafile(s) in backupset
    input datafile fno=00001 name=/u01/oracle/product/10.2.0/oradata/orclsour/system01.dbf
    input datafile fno=00003 name=/u01/oracle/product/10.2.0/oradata/orclsour/sysaux01.dbf
    input datafile fno=00005 name=/u01/oracle/product/10.2.0/oradata/orclsour/example01.dbf
    input datafile fno=00002 name=/u01/oracle/product/10.2.0/oradata/orclsour/undotbs01.dbf
    input datafile fno=00004 name=/u01/oracle/product/10.2.0/oradata/orclsour/users01.dbf
    channel t1: starting piece 1 at 27-SEP-11
    channel t1: finished piece 1 at 27-SEP-11
    piece handle=ORCLSOUR_40_1.bak tag=TAG20110927T155839 comment=API Version 2.0,MMS Version 5.0.0.0
    channel t1: backup set complete, elapsed time: 00:01:35
    Finished backup at 27-SEP-11

    Starting backup at 27-SEP-11
    current log archived
    channel t1: starting archive log backupset
    channel t1: specifying archive log(s) in backup set
    input archive log thread=1 sequence=168 recid=99 stamp=762969615
    channel t1: starting piece 1 at 27-SEP-11
    channel t1: finished piece 1 at 27-SEP-11
    piece handle=ORCLSOUR_41_1.bak tag=TAG20110927T160015 comment=API Version 2.0,MMS Version 5.0.0.0
    channel t1: backup set complete, elapsed time: 00:00:04
    Finished backup at 27-SEP-11

    NMDA:

    allocated channel: t1
    channel t1: sid=142 devtype=SBT_TAPE
    channel t1: NMDA Oracle v1.2.0
    sent command to channel: t1

    sent command to channel: t1


    Starting backup at 13-JAN-12
    current log archived
    channel t1: starting archive log backupset
    channel t1: specifying archive log(s) in backup set
    input archive log thread=1 sequence=150 recid=81 stamp=762758269
    input archive log thread=1 sequence=151 recid=82 stamp=762758354
    input archive log thread=1 sequence=152 recid=83 stamp=762758423
    input archive log thread=1 sequence=153 recid=84 stamp=762760042
    input archive log thread=1 sequence=154 recid=85 stamp=762814419
    input archive log thread=1 sequence=155 recid=86 stamp=762869659
    input archive log thread=1 sequence=156 recid=87 stamp=762869681
    input archive log thread=1 sequence=157 recid=88 stamp=762870392
    input archive log thread=1 sequence=158 recid=89 stamp=762870634
    input archive log thread=1 sequence=159 recid=90 stamp=762872956
    input archive log thread=1 sequence=160 recid=91 stamp=762873356
    input archive log thread=1 sequence=161 recid=92 stamp=762873735
    input archive log thread=1 sequence=162 recid=93 stamp=762873928
    input archive log thread=1 sequence=163 recid=94 stamp=762899498
    input archive log thread=1 sequence=164 recid=95 stamp=762899899
    input archive log thread=1 sequence=165 recid=96 stamp=762901507
    input archive log thread=1 sequence=166 recid=97 stamp=762912047
    input archive log thread=1 sequence=167 recid=98 stamp=762969461
    input archive log thread=1 sequence=168 recid=99 stamp=762969615
    input archive log thread=1 sequence=169 recid=100 stamp=763021827
    input archive log thread=1 sequence=170 recid=101 stamp=769200984
    input archive log thread=1 sequence=171 recid=102 stamp=769833052
    input archive log thread=1 sequence=172 recid=103 stamp=769930239
    input archive log thread=1 sequence=173 recid=104 stamp=772481947
    input archive log thread=1 sequence=174 recid=105 stamp=772482626
    input archive log thread=1 sequence=175 recid=106 stamp=772482931
    channel t1: starting piece 1 at 13-JAN-12
    channel t1: finished piece 1 at 13-JAN-12
    piece handle=ORCLSOUR_43_1.bak tag=TAG20120113T183531 comment=API Version 2.0,MMS Version 1.2.0.0
    channel t1: backup set complete, elapsed time: 00:01:57
    Finished backup at 13-JAN-12input archive log thread=1 sequence=166 recid=97 stamp=762912047
    input archive log thread=1 sequence=167 recid=98 stamp=762969461
    input archive log thread=1 sequence=168 recid=99 stamp=762969615
    input archive log thread=1 sequence=169 recid=100 stamp=763021827
    input archive log thread=1 sequence=170 recid=101 stamp=769200984
    input archive log thread=1 sequence=171 recid=102 stamp=769833052
    input archive log thread=1 sequence=172 recid=103 stamp=769930239
    input archive log thread=1 sequence=173 recid=104 stamp=772481947
    input archive log thread=1 sequence=174 recid=105 stamp=772482626
    input archive log thread=1 sequence=175 recid=106 stamp=772482931
    channel t1: starting piece 1 at 13-JAN-12
    channel t1: finished piece 1 at 13-JAN-12
    piece handle=ORCLSOUR_43_1.bak tag=TAG20120113T183531 comment=API Version 2.0,MMS Version 1.2.0.0
    channel t1: backup set complete, elapsed time: 00:01:57
    Finished backup at 13-JAN-12

    Both outputs do not have time stamp.

    Could you let me know the source for nmo output?

  • C

    Can2

    1 Rookie

    •

    100 Posts

    1288

    0

    Posted January 13th, 2012 05:00

    Both clients are Solaris 10 Sparc

  • V

    vermad1

    36 Posts

    1288

    1

    Posted January 13th, 2012 05:00

    NMDA does not use a shell script like NMO uses. NMDA uses cfg files. You cannot use script command in cfg file. A RFE can be raised in case you need time stamp with NMDA backups. I will check and raise a RFE.

  • C

    Can2

    1 Rookie

    •

    100 Posts

    1288

    0

    Posted January 13th, 2012 05:00

    Hi Vermad,

      Thank you, I am waiting for your reply.

    Thanks.

  • C

    Can2

    1 Rookie

    •

    100 Posts

    1288

    0

    Posted January 16th, 2012 08:00

    Hi Vermad,

      I haved forwarded your suggestions to dba, seems that you are right.

    Thanks.

Dell Support Resources

Latest Solutions

View More