crazy thought: what if I point a cooked chunk link to /dev/null?
Posted in 2004
Topics: Storage & Space Management
I have asked this before in another forum, just wondering if anyone has any thoughts on what would happen? Thinking about how I might restore one database from a level 0 containing two databases, avoiding over laying the one I dont want to restore by repointing all of its links to /dev/null? This sounds crazy I know, just wondering what you guys think! The ability to easily restore one database in a multidatabase instance is something we have always struggled with just because no one here has ever mastered HPL.
"sumGirl" <emebohw@netscape.net> wrote in message news:a5e13cff.0406180937.6152f71e@posting.google.com... > I have asked this before in another forum, just wondering if anyone > has any thoughts on what would happen? Thinking about how I might > restore one database from a level 0 containing two databases, avoiding > over laying the one I dont want to restore by repointing all of its > links to /dev/null? This sounds crazy I know, just wondering what you > guys think! The ability to easily restore one database in a > multidatabase instance is something we have always struggled with just > because no one here has ever mastered HPL. Try it and find out! I guess you're saying that you have a root dbspace, a llog and phys log dbspace and 2 app dbspaces each containing a database? My guess? It won't work. When you try to bring the server out of recovery mode and online, it'll try and open each chunk, fail on the /dev/null one, and barf.