HP 418800-B21 HP StorageWorks Replication Solutions Manager 4.0.1 job command - Page 73

Replicate Oracle tablespaces template

Get HP 418800-B21 - StorageWorks Modular Smart Array 70 Storage Enclosure PDF manuals and user guides
UPC - 882780564640
View all HP 418800-B21 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 73 highlights

Replicate Oracle tablespaces (template) Template summary A. Create a repository that contains the desired database components. B. Quiesce the Oracle database by putting it in 'hot backup' mode. C. Replicate the tablespace(s). D. Put the database back into normal operating mode. E. Pause. F. Delete the storage volume(s). G. Delete the repository. Template options • Use snapclone instead of snapshot. Generates a template that uses snapclone replication. • Include e-mail notification. Adds a command for e-mail notification of the job instance status. See SetNotificationPolicy. • Keep replicas. Generates a template that does not include a pause and rollback section for deleting the replicas. Example This template was generated to replicate Oracle tablespaces, with no template options selected. Line Task 1 // Replicate Oracle tablespace(s). 2 // 3 // Assign some variables that will be used in this job. 4 $source_database_unc = SetVariable(%source_database_unc%) 5 // 6 // Create a repository of the desired components. 7 $repository = CreateOracleRepository ($source_database_unc) onerror pauseat E1: 8 // Add the desired tablespaces. 9 AddOracleTablespacesToRepository($repository, %unc_tablespace_names%) onerror pauseat E2: 10 // 11 // Put the database in 'hot backup' mode. 12 SetOracleModeUsingRepository ($repository, TSBACKUP) onerror pauseat E2: 13 // 14 DO { 15 // Replicate the items in the repository. 16 SnapshotOracleUsingRepository ($repository, FULLY_ALLOCATED, SAME, ORACLE_TABLESPACE, NOWAIT) onerror pauseat E2: 17 // 18 } ALWAYS { 19 // Put the database back into normal mode. HP StorageWorks Replication Solutions Manager 4.0.1 73

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
Replicate Oracle tablespaces (template)
Template summary
A.
Create a repository that contains the desired database components.
B.
Quiesce the Oracle database by putting it in ‘hot backup’ mode.
C.
Replicate the tablespace(s).
D.
Put the database back into normal operating mode.
E.
Pause.
F.
Delete the storage volume(s).
G.
Delete the repository.
Template options
•
Use snapclone instead of snapshot
.
Generates a template that uses snapclone replication.
•
Include e-mail noti
fi
cation
.
Adds a command for e-mail noti
fi
cation of the job instance status.
See
SetNoti
fi
cationPolicy
.
•
Keep replicas
.
Generates a template that does not include a pause and rollback section for
deleting the replicas.
Example
This template was generated to replicate Oracle tablespaces, with no template options selected.
Line
Task
1
// Replicate Oracle tablespace(s).
2
//
3
// Assign some variables that will be used in this job.
4
$source_database_unc = SetVariable(%source_database_unc%)
5
//
6
// Create a repository of the desired components.
7
$repository = CreateOracleRepository ($source_database_unc) onerror pauseat E1:
8
// Add the desired tablespaces.
9
AddOracleTablespacesToRepository($repository, %unc_tablespace_names%) onerror pauseat E2:
10
//
11
// Put the database in ’hot backup’ mode.
12
SetOracleModeUsingRepository ($repository, TSBACKUP) onerror pauseat E2:
13
//
14
DO {
15
// Replicate the items in the repository.
16
SnapshotOracleUsingRepository ($repository, FULLY_ALLOCATED, SAME, ORACLE_TABLESPACE,
NOWAIT) onerror pauseat E2:
17
//
18
} ALWAYS {
19
// Put the database back into normal mode.
HP StorageWorks Replication Solutions Manager 4.0.1
73