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

Replicate Oracle tablespaces, mount to a host 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 74 highlights

20 SetOracleModeUsingRepository ($repository, TSONLINE) 21 } 22 // 23 // NOTE: Please remove the archive log file Switch, Add, and Snap commands below if this job is not backing up archive log files 24 // 25 // Force a log switch to get the most current archive logs. 26 SwitchOracleArchiveLogFilesUsingRepository ( $repository ) onerror pauseat E3: 27 // OPTION: Add the archive logs 28 AddOracleArchiveLogFilesToRepository($repository) onerror pauseat E3: 29 // Replicate the items in the repository. 30 SnapshotOracleUsingRepository ($repository, FULLY_ALLOCATED, SAME, ORACLE_ARCHIVE_LOG_FILE, NOWAIT) onerror pauseat E3: 31 // 32 // Wait for user to initiate rollback. 33 Pause () 34 // 35 // Rollback. 36 E3: DeleteStorageVolumesUsingRepository ($repository, REPLICATED) onerror pauseat E3: 37 // 38 // Delete the repository. 39 E2: DeleteOracleRepository ($repository) onerror pauseat E2: 40 // 41 Exit (SUCCESS) 42 // 43 // Failure exit - no rollback needed. 44 E1: Exit (FAILURE) Replicate Oracle tablespaces, mount to a host (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. Mount the host volume(s) on a host. F. Pause. G. Delete the mounted host volume(s). H. Delete the storage volume(s). I. Delete the repository. 74 Job concepts, templates and commands

  • 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
20
SetOracleModeUsingRepository ($repository, TSONLINE)
21
}
22
//
23
// NOTE: Please remove the archive log
fi
le Switch, Add, and Snap commands below if this job is not
backing up archive log
fi
les
24
//
25
// Force a log switch to get the most current archive logs.
26
SwitchOracleArchiveLogFilesUsingRepository ( $repository ) onerror pauseat E3:
27
// OPTION: Add the archive logs
28
AddOracleArchiveLogFilesToRepository($repository) onerror pauseat E3:
29
// Replicate the items in the repository.
30
SnapshotOracleUsingRepository ($repository, FULLY_ALLOCATED, SAME, ORA-
CLE_ARCHIVE_LOG_FILE, NOWAIT) onerror pauseat E3:
31
//
32
// Wait for user to initiate rollback.
33
Pause ()
34
//
35
// Rollback.
36
E3: DeleteStorageVolumesUsingRepository ($repository, REPLICATED) onerror pauseat E3:
37
//
38
// Delete the repository.
39
E2: DeleteOracleRepository ($repository) onerror pauseat E2:
40
//
41
Exit (SUCCESS)
42
//
43
// Failure exit - no rollback needed.
44
E1: Exit (FAILURE)
Replicate Oracle tablespaces, mount to a host (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.
Mount the host volume(s) on a host.
F.
Pause.
G.
Delete the mounted host volume(s).
H.
Delete the storage volume(s).
I.
Delete the repository.
74
Job concepts, templates and commands