This is a cryptographically signed message in MIME format.
--------------ms080902080002060808070802
Content-Type: multipart/alternative;
boundary="------------040700030903060100030405"
This is a multi-part message in MIME format.
--------------040700030903060100030405
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Yes, and no. Within the NBU example shell script, there is code that
connects to the target database, does a shutdown immediate, then a
startup mount. Once the cold backup has completed, we connect to the
target db again, and issue an alter database open command.
We've got a highly modified version of dbstart and dbshut, which is what
I use in my RMAN script generation program.
--Steve
Donaldson, Mark wrote:
> My DBA's tell me that the shutdown/startup commands are part of the
> RMAN command set.
>
> So, for an RMAN multistream cold you should be able to shutdown the
> DB, create a multi-channel backup job via RMAN which translates to a
> NB multistream backup, then startup the DB when complete. Call the
> RMAN script from cron on the client & it's one shutdown & one startup.
>
> -M
>
> -----Original Message-----
> *From:* Markham, Richard [mailto:RMarkham AT hafeleamericas DOT com]
> *Sent:* Friday, June 13, 2003 8:42 AM
> *To:* 'Donaldson, Mark'; List, VERITAS NBU
> *Subject:* RE: [Veritas-bu] NBU/RMAN Cold Backup question
>
> This thread struck a bit of curiousity in me. I haven't actually
> implemented
> "cold" backups through RMAN and NB. So the jobs themselves are
> sending
> startup/shutdown commands to the db as it sees fit? Or do I have
> this wrong?
> Are the multiple jobs running the same main scripts each time,
> which contain
> the startup/shutdown commands? Thanks for any heads up.
>
>
> -----Original Message-----
> From: Donaldson, Mark [mailto:Mark.Donaldson AT experianems DOT com]
> Sent: Wednesday, June 11, 2003 3:06 PM
> To: Steven L. Sesar; List, VERITAS NBU
> Subject: RE: [Veritas-bu] NBU/RMAN Cold Backup question
>
>
> The first job to complete will probably attempt to bring the DB
> back up,
> too.
>
> You have to write a stream-aware set of scripts for DB startup &
> shutdown.
>
> I do mine with a series of lock files & counters. The number of
> streams is
> an environment variable & so I have a lockfile. For startup, each
> stream
> checks for the lock file, creating it & starting the DB
> preparation if it is
> the first to start. The loser of the race starts to watch for a
> completion
> flag that the first stream will write when the DB is all the way
> down - then
> they stop waiting & end to allow the backup to proceed.
>
> The end-job is pretty much the same in reverse. The last stream
> to complete
> has to restart the DB.
>
> One quick way around this, since you've got RMAN is drop the
> Netbackup
> scheduling & run the job from cron on the DB client. It's all
> driven from
> RMAN script that way.
>
> HTH - Mark
>
> -----Original Message-----
> From: Steven L. Sesar [mailto:ssesar AT mitre DOT org]
> Sent: Wednesday, June 11, 2003 8:24 AM
> To: List, VERITAS NBU
> Subject: [Veritas-bu] NBU/RMAN Cold Backup question
>
>
> Hi,
>
> When I kick off a cold backup, NBU breaks the backup up into several
> jobs. The problem with this, is that each new job that starts,
> tries to
> shutdown/startup mount the SID that it is backing up.
>
> Has anyone else encountered this, and what have you done about it?
>
> NBU 4.5MP4, Solaris 8.
>
> --Steve
>
> _______________________________________________
> Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>
--
===================================
Steven L. Sesar
Senior Operating Systems Programmer/Analyst
UNIX Application Services R10A
The MITRE Corporation
202 Burlington Road - KS101
Bedford, MA 01730
tel: (781) 271-7702
fax: (781) 271-2600
mobile: (617) 893-9635
email: ssesar AT mitre DOT org
===================================
--------------040700030903060100030405
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body>
Yes, and no. Within the NBU example shell script, there is code that
connects to the target database, does a shutdown immediate, then a
startup mount. Once the cold backup has completed, we connect to the
target db again, and issue an alter database open command.<br>
<br>
We've got a highly modified version of dbstart and dbshut, which is
what I use in my RMAN script generation program.<br>
<br>
--Steve<br>
<br>
Donaldson, Mark wrote:<br>
<blockquote type="cite"
cite="mid6956D00165F4CB4583BB9CC33D77364F1D8119 AT denca00.corp.exactis DOT
com">
<meta http-equiv="Content-Type" content="text/html; ">
<title>RE: [Veritas-bu] NBU/RMAN Cold Backup question</title>
<meta content="MSHTML 5.50.4926.2500" name="GENERATOR">
<div><span class="325575515-13062003"><font face="Arial"
color="#0000ff" size="2">My DBA's tell me that the shutdown/startup
commands are part of the RMAN command set.</font></span></div>
<div><span class="325575515-13062003"></span> </div>
<div><span class="325575515-13062003"><font face="Arial"
color="#0000ff" size="2">So, for an RMAN multistream cold you should
be able to shutdown the DB, create a multi-channel backup job via RMAN
which translates to a NB multistream backup, then startup the DB when
complete. Call the RMAN script from cron on the client & it's one
shutdown & one startup.</font></span></div>
<div><span class="325575515-13062003"></span> </div>
<div><span class="325575515-13062003"><font face="Arial"
color="#0000ff" size="2">-M</font></span></div>
<blockquote dir="ltr" style="margin-right: 0px;">
<div class="OutlookMessageHeader" dir="ltr" align="left"><font
face="Tahoma" size="2">-----Original Message-----<br>
<b>From:</b> Markham, Richard [<a class="moz-txt-link-freetext"
href="mailto:RMarkham AT hafeleamericas DOT com">mailto:RMarkham AT
hafeleamericas DOT com</a>]<br>
<b>Sent:</b> Friday, June 13, 2003 8:42 AM<br>
<b>To:</b> 'Donaldson, Mark'; List, VERITAS NBU<br>
<b>Subject:</b> RE: [Veritas-bu] NBU/RMAN Cold Backup question<br>
<br>
</font></div>
<p><font size="2">This thread struck a bit of curiousity in me. I
haven't actually implemented </font><br>
<font size="2">"cold" backups through RMAN and NB. So the jobs
themselves are sending </font><br>
<font size="2">startup/shutdown commands to the db as it sees fit?
Or do I have this wrong?</font> <br>
<font size="2">Are the multiple jobs running the same main
scripts each time, which contain</font> <br>
<font size="2">the startup/shutdown commands? Thanks for any
heads up.</font> </p>
<br>
<p><font size="2">-----Original Message-----</font> <br>
<font size="2">From: Donaldson, Mark [<a
href="mailto:Mark.Donaldson AT experianems DOT com">mailto:Mark.Donaldson AT
experianems DOT com</a>]</font> <br>
<font size="2">Sent: Wednesday, June 11, 2003 3:06 PM</font> <br>
<font size="2">To: Steven L. Sesar; List, VERITAS NBU</font> <br>
<font size="2">Subject: RE: [Veritas-bu] NBU/RMAN Cold Backup
question</font> </p>
<br>
<p><font size="2">The first job to complete will probably attempt
to bring the DB back up,</font> <br>
<font size="2">too.</font> </p>
<p><font size="2">You have to write a stream-aware set of scripts
for DB startup & shutdown.</font> </p>
<p><font size="2">I do mine with a series of lock files &
counters. The number of streams is</font> <br>
<font size="2">an environment variable & so I have a
lockfile. For startup, each stream</font> <br>
<font size="2">checks for the lock file, creating it & starting
the DB preparation if it is</font> <br>
<font size="2">the first to start. The loser of the race starts
to watch for a completion</font> <br>
<font size="2">flag that the first stream will write when the DB
is all the way down - then</font> <br>
<font size="2">they stop waiting & end to allow the backup to
proceed.</font> </p>
<p><font size="2">The end-job is pretty much the same in reverse.
The last stream to complete</font> <br>
<font size="2">has to restart the DB.</font> </p>
<p><font size="2">One quick way around this, since you've got RMAN
is drop the Netbackup</font> <br>
<font size="2">scheduling & run the job from cron on the DB
client. It's all driven from</font> <br>
<font size="2">RMAN script that way.</font> </p>
<p><font size="2">HTH - Mark</font> </p>
<p><font size="2">-----Original Message-----</font> <br>
<font size="2">From: Steven L. Sesar [<a
href="mailto:ssesar AT mitre DOT org">mailto:ssesar AT mitre DOT
org</a>]</font> <br>
<font size="2">Sent: Wednesday, June 11, 2003 8:24 AM</font> <br>
<font size="2">To: List, VERITAS NBU</font> <br>
<font size="2">Subject: [Veritas-bu] NBU/RMAN Cold Backup
question</font> </p>
<br>
<p><font size="2">Hi,</font> </p>
<p><font size="2">When I kick off a cold backup, NBU breaks the
backup up into several </font><br>
<font size="2">jobs. The problem with this, is that each new job
that starts, tries to </font><br>
<font size="2">shutdown/startup mount the SID that it is backing
up.</font> <br>
<font size="2"> </font> <br>
<font size="2">Has anyone else encountered this, and what have you
done about it?</font> </p>
<p><font size="2">NBU 4.5MP4, Solaris 8.</font> </p>
<p><font size="2">--Steve</font> </p>
<p><font size="2">_______________________________________________</font>
<br>
<font size="2">Veritas-bu maillist -
<a class="moz-txt-link-abbreviated" href="mailto:Veritas-bu AT
mailman.eng.auburn DOT edu">Veritas-bu AT mailman.eng.auburn DOT edu</a></font>
<br>
<font size="2"><a target="_blank"
href="http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu">http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu</a></font>
</p>
</blockquote>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
===================================
Steven L. Sesar
Senior Operating Systems Programmer/Analyst
UNIX Application Services R10A
The MITRE Corporation
202 Burlington Road - KS101
Bedford, MA 01730
tel: (781) 271-7702
fax: (781) 271-2600
mobile: (617) 893-9635
email: <a class="moz-txt-link-abbreviated" href="mailto:ssesar AT mitre DOT
org">ssesar AT mitre DOT org</a>
===================================</pre>
</body>
</html>
--------------040700030903060100030405--
--------------ms080902080002060808070802
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature
MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIHCTCC
AkwwggG1oAMCAQICAhk0MA0GCSqGSIb3DQEBBAUAMEsxEjAQBgNVBAoTCW1pdHJlLm9yZzEe
MBwGA1UECxMVQ2VydGlmaWNhdGUgQXV0aG9yaXR5MRUwEwYDVQQDEwxjYS5taXRyZS5vcmcw
HhcNMDMwMzI3MTI1MTQ3WhcNMDQwOTE3MTI1MTQ3WjB4MRIwEAYDVQQKEwltaXRyZS5vcmcx
DzANBgNVBAsTBnBlb3BsZTEWMBQGCgmSJomT8ixkAQETBnNzZXNhcjEYMBYGA1UEAxMPU2Vz
YXIsU3RldmVuIEwuMR8wHQYJKoZIhvcNAQkBFhBzc2VzYXJAbWl0cmUub3JnMIGfMA0GCSqG
SIb3DQEBAQUAA4GNADCBiQKBgQCsMFG7P8BkusNRNWmoqH0y67h3ZrYit9OIJzHDuJHdQPCE
wMYZ9ij4QERUL4RJGwuBt+pj9tkswVi3R7qLKqodNMsiXhIBk25n9F9yO3KHyTlBR4PTW3dt
WARent/Gr5nWR9fnQVwbVEYeqbRSQkLrfRw9mOKfbR86TiV2CJX4dwIDAQABoxIwEDAOBgNV
HQ8BAf8EBAMCBeAwDQYJKoZIhvcNAQEEBQADgYEAR6PVaJjQRwG9Wrb/eEWlG1Ks9UJNv9UE
YYhEO4XXwgf41xe7SIZUQbb40ulX6nklZ9u9dTENFfGPamO9sN2C8Ys0dionUq7P7toCohXS
txBIbwgE7kg7UIzAmKbuG8pV7iUY5g64nXcgb4IvjJDU73TC9RnP8hN5LjnsP40fHJ0wggJM
MIIBtaADAgECAgIZNDANBgkqhkiG9w0BAQQFADBLMRIwEAYDVQQKEwltaXRyZS5vcmcxHjAc
BgNVBAsTFUNlcnRpZmljYXRlIEF1dGhvcml0eTEVMBMGA1UEAxMMY2EubWl0cmUub3JnMB4X
DTAzMDMyNzEyNTE0N1oXDTA0MDkxNzEyNTE0N1oweDESMBAGA1UEChMJbWl0cmUub3JnMQ8w
DQYDVQQLEwZwZW9wbGUxFjAUBgoJkiaJk/IsZAEBEwZzc2VzYXIxGDAWBgNVBAMTD1Nlc2Fy
LFN0ZXZlbiBMLjEfMB0GCSqGSIb3DQEJARYQc3Nlc2FyQG1pdHJlLm9yZzCBnzANBgkqhkiG
9w0BAQEFAAOBjQAwgYkCgYEArDBRuz/AZLrDUTVpqKh9Muu4d2a2IrfTiCcxw7iR3UDwhMDG
GfYo+EBEVC+ESRsLgbfqY/bZLMFYt0e6iyqqHTTLIl4SAZNuZ/Rfcjtyh8k5QUeD01t3bVgE
Xp7fxq+Z1kfX50FcG1RGHqm0UkJC630cPZjin20fOk4ldgiV+HcCAwEAAaMSMBAwDgYDVR0P
AQH/BAQDAgXgMA0GCSqGSIb3DQEBBAUAA4GBAEej1WiY0EcBvVq2/3hFpRtSrPVCTb/VBGGI
RDuF18IH+NcXu0iGVEG2+NLpV+p5JWfbvXUxDRXxj2pjvbDdgvGLNHYqJ1Kuz+7aAqIV0rcQ
SG8IBO5IO1CMwJim7hvKVe4lGOYOuJ13IG+CL4yQ1O90wvUZz/ITeS457D+NHxydMIICZTCC
Ac6gAwIBAgIBBTANBgkqhkiG9w0BAQQFADBPMRIwEAYDVQQKEwltaXRyZS5vcmcxHjAcBgNV
BAsTFUNlcnRpZmljYXRlIEF1dGhvcml0eTEZMBcGA1UEAxMQcm9vdGNhLm1pdHJlLm9yZzAe
Fw05ODA5MDkxNjQ4NTJaFw0wNzA5MDcxNjQ4NTJaMEsxEjAQBgNVBAoTCW1pdHJlLm9yZzEe
MBwGA1UECxMVQ2VydGlmaWNhdGUgQXV0aG9yaXR5MRUwEwYDVQQDEwxjYS5taXRyZS5vcmcw
gZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAM6K1dCL4VTShZUcn1sDzOvDo0hTp025906W
mOnGhLx/2QEUmb7pZS77+T1/nqmthxtoZXwjBYWPTFCnoD/1xXks28NdGVZRvRDOtEbpDvTw
adtbzfXQp/fwFNPcnL8+UgyM7G2ZnakPNDTAf0ZcY4Z4P+g6177smfPplwYPWdZHAgMBAAGj
VTBTMBEGCWCGSAGG+EIBAQQEAwIABzAfBgNVHSMEGDAWgBSaU2bHq4MlY+ThWyYZdbxqjDQ/
XTAdBgNVHQ4EFgQUqTMTu3doqXs3nKOJAaaKMXIkFmkwDQYJKoZIhvcNAQEEBQADgYEAbWXG
jCtdKYAD6El1yMDAo9o4xya8UAX01cK2ObyX89ejLkwBSNdvcM094nLJNhblh9wgUP2K6Ptl
JHvBhykjwv+Pi/dc4o2IEzNzDdKRV8Hs2ncL55HL5FDiJYzkmzR8Pu2ap10Bb2tVdFERhC0h
6RCesI75QQwa23fwyzCV9sExggJyMIICbgIBATBRMEsxEjAQBgNVBAoTCW1pdHJlLm9yZzEe
MBwGA1UECxMVQ2VydGlmaWNhdGUgQXV0aG9yaXR5MRUwEwYDVQQDEwxjYS5taXRyZS5vcmcC
Ahk0MAkGBSsOAwIaBQCgggF3MBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcN
AQkFMQ8XDTAzMDYxMzE3MDQzMVowIwYJKoZIhvcNAQkEMRYEFEuIerqM3fiQxf8cVW0IH4Y5
VGlgMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0GCCqG
SIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMGAGCSsGAQQBgjcQBDFTMFEwSzES
MBAGA1UEChMJbWl0cmUub3JnMR4wHAYDVQQLExVDZXJ0aWZpY2F0ZSBBdXRob3JpdHkxFTAT
BgNVBAMTDGNhLm1pdHJlLm9yZwICGTQwYgYLKoZIhvcNAQkQAgsxU6BRMEsxEjAQBgNVBAoT
CW1pdHJlLm9yZzEeMBwGA1UECxMVQ2VydGlmaWNhdGUgQXV0aG9yaXR5MRUwEwYDVQQDEwxj
YS5taXRyZS5vcmcCAhk0MA0GCSqGSIb3DQEBAQUABIGAnB7m8fZeTVvEbmxHYB7sd5jmWDsz
A5ob/p58eMdrVYFGUxKp1+skYAu8nLA6Kgj81ivbCZ1s7xVEQflsSbYKMvpwe6EArasikPAE
bEMfr67YQMsrWyMmiusokhwcBtbDxr1njXMe85fieIVCxj1UiGjFN5fv+tZaKkh9XS+jEccA
AAAAAAA=
--------------ms080902080002060808070802--
|