cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle policy is triggering application streams from a different policy

ajiwww
Level 4

The Oracle policy is configured as below. It got one Automatic & multiple application schedule. But the automatic schedule is triggering application streams for a different policy. 

 

Policy details below; the policy name is TEST_ORA_RAC_EBP. But the application streams are getting triggerd with another policy name TEST_ORA_RAC_EB9. The client is a member of that policy as well.

 

The script does not have any oracle parameters configured in it.

 

 

bash-3.2$ sudo /usr/openv/netbackup/bin/admincmd/bppllist TEST_ORA_RAC_EBP -L
 
Policy Name:       TEST_ORA_RAC_EBP
Options:           0x0
template:          FALSE
audit_reason:         ?
Names:             (none)
Policy Type:       Oracle (4)
Active:            yes
Effective date:    10/09/2012 10:36:07
Block Incremental: no
Mult. Data Stream: no
Perform Snapshot Backup:   no
Snapshot Method:           (none)
Snapshot Method Arguments: (none)
Perform Offhost Backup:    no
Backup Copy:               0
Use Data Mover:            no
Data Mover Type:           2
Use Alternate Client:      no
Alternate Client Name:     (none)
Use Virtual Machine:      0
Hyper-V Server Name:     (none)
Enable Instant Recovery:   no
Policy Priority:   0
Max Jobs/Policy:   15
Disaster Recovery: 0
Collect BMR Info:  no
Keyword:           (none specified)
Data Classification:       -
Residence is Storage Lifecycle Policy:    yes
Client Encrypt:    no
Checkpoint:        no
Residence:         HNZ_Sun02_PT_DD640_2_LTO-5_Daily_REPL
Volume Pool:       NetBackup
Server Group:      *ANY*
Granular Restore Info:  no
Exchange Source attributes:              no
Exchange 2010 Preferred Server: (none defined)
Application Discovery:      no
Discovery Lifetime:      0 seconds
ASC Application and attributes: (none defined)
Generation:      4
Ignore Client Direct:  no
Enable Metadata Indexing:  no
Index server name:  NULL
Use Accelerator:  no
Client/HW/OS/Pri/DMI:  sappt058 HP-UX-IA64 HP-UX11.31 0 1 0 0 ?
Client/HW/OS/Pri/DMI:  sappt059 HP-UX-IA64 HP-UX11.31 0 0 0 0 ?
Client/HW/OS/Pri/DMI:  sappt060 HP-UX-IA64 HP-UX11.31 0 0 0 0 ?
Include:           /oracle/EBP/sapscript/hot_database_backup_ebp.sh
Schedule:              Default-Application-Backup
  Type:                UBAK Obak (2)
  Frequency:           7 day(s) (604800 seconds)
  Maximum MPX:         1
  Synthetic:           0
  Checksum Change Detection: 0
  PFI Recovery:        0
  Retention Level:     9 (infinity)
  u-wind/o/d:          0 0
  Incr Type:           DELTA (0)
  Alt Read Host:       (none defined)
  Max Frag Size:       0 MB
  Number Copies:       1
  Fail on Error:       0
  Residence:           (specific storage unit not required)
  Volume Pool:         (same as policy volume pool)
  Server Group:        (same as specified for policy)
  Residence is Storage Lifecycle Policy:         0
  Schedule indexing:     0
  Daily Windows:
   Day         Open       Close       W-Open     W-Close
   Sunday      000:00:00  024:00:00   000:00:00  024:00:00
   Monday      000:00:00  024:00:00   024:00:00  048:00:00
   Tuesday     000:00:00  024:00:00   048:00:00  072:00:00
   Wednesday   000:00:00  024:00:00   072:00:00  096:00:00
   Thursday    000:00:00  024:00:00   096:00:00  120:00:00
   Friday      000:00:00  024:00:00   120:00:00  144:00:00
   Saturday    000:00:00  024:00:00   144:00:00  168:00:00
Schedule:              Test_Full
  Type:                FULL SObk (0)
  Frequency:           0+ day(s) (28800 seconds)
  Maximum MPX:         24
  Synthetic:           0
  Checksum Change Detection: 0
  PFI Recovery:        0
  Retention Level:     0 (1 week)
  u-wind/o/d:          0 0
  Incr Type:           DELTA (0)
  Alt Read Host:       (none defined)
  Max Frag Size:       0 MB
  Number Copies:       1
  Fail on Error:       0
  Residence:           HNZ_Sun02_PT_DD640_2_LTO-5_Weekly_REPL
  Volume Pool:         (same as policy volume pool)
  Server Group:        (same as specified for policy)
  Residence is Storage Lifecycle Policy:         1
  Schedule indexing:     0
  Daily Windows:
   Day         Open       Close       W-Open     W-Close
   Sunday      000:00:00  000:00:00
   Monday      000:00:00  000:00:00
   Tuesday     000:00:00  000:00:00
   Wednesday   000:00:00  000:00:00
   Thursday    000:00:00  000:00:00
   Friday      000:00:00  000:00:00
   Saturday    000:00:00  000:00:00
Schedule:              full_test
  Type:                FULL SObk (0)
  Frequency:           7 day(s) (604800 seconds)
  Maximum MPX:         1
  Synthetic:           0
  Checksum Change Detection: 0
  PFI Recovery:        0
  Retention Level:     0 (1 week)
  u-wind/o/d:          0 0
  Incr Type:           DELTA (0)
  Alt Read Host:       (none defined)
  Max Frag Size:       0 MB
  Number Copies:       1
  Fail on Error:       0
  Residence:           (specific storage unit not required)
  Volume Pool:         (same as policy volume pool)
  Server Group:        (same as specified for policy)
  Residence is Storage Lifecycle Policy:         0
  Schedule indexing:     0
  Daily Windows:
   Day         Open       Close       W-Open     W-Close
   Sunday      000:00:00  000:00:00
   Monday      000:00:00  000:00:00
   Tuesday     000:00:00  000:00:00
   Wednesday   000:00:00  000:00:00
   Thursday    000:00:00  000:00:00
   Friday      000:00:00  000:00:00
   Saturday    000:00:00  000:00:00
Schedule:              Daily_Application-Backup
  Type:                UBAK Obak (2)
  Frequency:           7 day(s) (604800 seconds)
  Maximum MPX:         24
  Synthetic:           0
  Checksum Change Detection: 0
  PFI Recovery:        0
  Retention Level:     0 (1 week)
  u-wind/o/d:          0 0
  Incr Type:           DELTA (0)
  Alt Read Host:       (none defined)
  Max Frag Size:       0 MB
  Number Copies:       1
  Fail on Error:       0
  Residence:           HNZ_Sun02_PT_DD640_2_LTO-5_Daily_REPL
  Volume Pool:         (same as policy volume pool)
  Server Group:        (same as specified for policy)
  Residence is Storage Lifecycle Policy:         1
  Schedule indexing:     0
  Daily Windows:
   Day         Open       Close       W-Open     W-Close
   Sunday      000:00:00  024:00:00   000:00:00  024:00:00
   Monday      000:00:00  024:00:00   024:00:00  048:00:00
   Tuesday     000:00:00  024:00:00   048:00:00  072:00:00
   Wednesday   000:00:00  024:00:00   072:00:00  096:00:00
   Thursday    000:00:00  024:00:00   096:00:00  120:00:00
   Friday      000:00:00  024:00:00   120:00:00  144:00:00
   Saturday    000:00:00  024:00:00   144:00:00  168:00:00
Schedule:              Monthly_Application-Backup
  Type:                UBAK Obak (2)
  Frequency:           7 day(s) (604800 seconds)
  Maximum MPX:         24
  Synthetic:           0
  Checksum Change Detection: 0
  PFI Recovery:        0
  Retention Level:     0 (1 week)
  u-wind/o/d:          0 0
  Incr Type:           DELTA (0)
  Alt Read Host:       (none defined)
  Max Frag Size:       0 MB
  Number Copies:       1
  Fail on Error:       0
  Residence:           HNZ_Sun02_PT_DD640_2_LTO-5_Monthly_REPL
  Volume Pool:         (same as policy volume pool)
  Server Group:        (same as specified for policy)
  Residence is Storage Lifecycle Policy:         1
  Schedule indexing:     0
  Daily Windows:
   Day         Open       Close       W-Open     W-Close
   Sunday      000:00:00  024:00:00   000:00:00  024:00:00
   Monday      000:00:00  024:00:00   024:00:00  048:00:00
   Tuesday     000:00:00  024:00:00   048:00:00  072:00:00
   Wednesday   000:00:00  024:00:00   072:00:00  096:00:00
   Thursday    000:00:00  024:00:00   096:00:00  120:00:00
   Friday      000:00:00  024:00:00   120:00:00  144:00:00
   Saturday    000:00:00  024:00:00   144:00:00  168:00:00
Schedule:              Weekly_Application-Backup
  Type:                UBAK Obak (2)
  Frequency:           7 day(s) (604800 seconds)
  Maximum MPX:         24
  Synthetic:           0
  Checksum Change Detection: 0
  PFI Recovery:        0
  Retention Level:     0 (1 week)
  u-wind/o/d:          0 0
  Incr Type:           DELTA (0)
  Alt Read Host:       (none defined)
  Max Frag Size:       0 MB
  Number Copies:       1
  Fail on Error:       0
  Residence:           HNZ_Sun02_PT_DD640_2_LTO-5_Weekly_REPL
  Volume Pool:         (same as policy volume pool)
  Server Group:        (same as specified for policy)
  Residence is Storage Lifecycle Policy:         1
  Schedule indexing:     0
  Daily Windows:
   Day         Open       Close       W-Open     W-Close
   Sunday      000:00:00  024:00:00   000:00:00  024:00:00
   Monday      000:00:00  024:00:00   024:00:00  048:00:00
   Tuesday     000:00:00  024:00:00   048:00:00  072:00:00
   Wednesday   000:00:00  024:00:00   072:00:00  096:00:00
   Thursday    000:00:00  024:00:00   096:00:00  120:00:00
   Friday      000:00:00  024:00:00   120:00:00  144:00:00
   Saturday    000:00:00  024:00:00   144:00:00  168:00:00
Schedule:              Yearly_Application-Backup
  Type:                UBAK Obak (2)
  Frequency:           7 day(s) (604800 seconds)
  Maximum MPX:         24
  Synthetic:           0
  Checksum Change Detection: 0
  PFI Recovery:        0
  Retention Level:     0 (1 week)
  u-wind/o/d:          0 0
  Incr Type:           DELTA (0)
  Alt Read Host:       (none defined)
  Max Frag Size:       0 MB
  Number Copies:       1
  Fail on Error:       0
  Residence:           HNZ_Sun02_PT_DD640_2_LTO-5_Yearly_REPL
  Volume Pool:         (same as policy volume pool)
  Server Group:        (same as specified for policy)
  Residence is Storage Lifecycle Policy:         1
  Schedule indexing:     0
  Daily Windows:
   Day         Open       Close       W-Open     W-Close
   Sunday      000:00:00  024:00:00   000:00:00  024:00:00
   Monday      000:00:00  024:00:00   024:00:00  048:00:00
   Tuesday     000:00:00  024:00:00   048:00:00  072:00:00
   Wednesday   000:00:00  024:00:00   072:00:00  096:00:00
   Thursday    000:00:00  024:00:00   096:00:00  120:00:00
   Friday      000:00:00  024:00:00   120:00:00  144:00:00
   Saturday    000:00:00  024:00:00   144:00:00  168:00:00
 
1 ACCEPTED SOLUTION

Accepted Solutions

Will_Restore
Level 6

Update the RMAN script to include

 

NB_ORA_POLICY=your_policy_name

 

in the SEND statement, i.e.

 

SEND 'NB_ORA_POLICY=TEST_ORA_RAC_EBP';

View solution in original post

3 REPLIES 3

Will_Restore
Level 6

Update the RMAN script to include

 

NB_ORA_POLICY=your_policy_name

 

in the SEND statement, i.e.

 

SEND 'NB_ORA_POLICY=TEST_ORA_RAC_EBP';

ajiwww
Level 4

Yes, that should work. But is there any other option other than this ? because we will be using a common script without any NB parameters in the script.

Marianne
Level 6
Partner    VIP    Accredited Certified

This has been a known issue for as long as I've known NBU.

Hard-coding the policy name in the script is the only way.

See http://www.symantec.com/docs/TECH31742