But you can place several DB instances, in seperate qtree's, into hotbackup mode and take a snapshot of the entire volume. Takes less time than to shutdown your DB and "waste" one snapshot per instance. Hence, you can consolidate more DB's on a larger volume (read: more spindles) and increase performance overall. Be sure to keep your redo logs on different volume! If you have different *types* of DB's, group them by how fast you can place them into a consistent state and then take one snapshot.
/M/
-----Original Message----- From: Noll, Kevin [mailto:Kevin.Noll@capgemini.co.uk] Sent: Tuesday, September 04, 2001 1:48 PM To: 'Jay Newton'; 'toasters@mathworks.com' Subject: RE: Snapshots of QTREEs
Good question. As far as I am aware of, a snap shot is ONLY Per VOLUME.
-----Original Message----- From: Jay Newton [mailto:jnewton@chkenergy.com] Sent: 04 September 2001 21:05 To: 'toasters@mathworks.com' Subject: Snapshots of QTREEs
Is there a way to snapshot an individual QTREE from command line or must it be the entire volume. I have a volume set up for databases and I want to snapshot from command line individual QTREEs that represent different types of databases. Any help would be appreciated!
Jay Newton Systems Engineer - Chesapeake Operating (405)810-2683 (405)879-9578 fax
******************************************************************************************** " This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message ". ********************************************************************************************