Re: Minimum Files to Clone a Database

mrb456_at_comcast.net (Mike Blocker) wrote in message news:<da95e407.0405110816.25d1903d_at_posting.google.com>...
> I am helping a DBA clone an Oracle 8i database using disk "snapshots".
> He would like to use the more expensive disk snapshot hardware for
> just the data files. The rest (indexes, redo, rbs, etc.) will be on
> local disks. The split of the data will be done in hot backup mode.
> I'm thinking he will need a control file listing and archive logs to
> create the clone, but will he be able to rebuild the index files?
>
> Thanks!
>
> Mike

Mention to your dba he can get the commands to create indices from the exp utility, and modify them to be put whereever. But Ana nailed the DBA on the head with the "how long would that take" question, if your indices are big enough to be too expensive to fit on the hardware...

Maybe your DBA can split off some old data into RO tablespaces so the more recent data and indices can fit.

jg

--
@home.com is bogus.  "What's the one thing you'd change about San
Diego?"
"I'd bring San Diego closer to Brooklyn, where most of my family is."
- Ryan Bruins
"Welcome to California, now go back to New York" - bumper sticker