Re: Yet another recovery question

'Bonjour' from Paris,

Without Rman :

       o. Restore the hot or cold database and controlfile backup 
       o. Restore archived logs if required for recovery
       o. Mount the database and offline datafiles belonging to the
          tablespaces that aren't required
       o. Recover the database
       o. Open the database and drop the tablespaces whose datafiles
          have not been restored (and rebuild if desired) 

With Rman (RMAN) :

 Example 1 (media recovery):

     Target database mode: Database mounted
       RMAN> run {
       RMAN> allocate channel t1 type 'sbt_tape';
       RMAN> restore database skip tablespace temp;
       RMAN> recover database skip tablespace temp;
       RMAN> sql "alter database open";
       RMAN> sql "drop tablespace temp";
       RMAN> sql "create tablespace temp datafile ''<filename>''";
       RMAN> }

     Example 2 (no media recovery):
     Target database mode: Database mounted
       RMAN> run {
       RMAN> allocate channel t1 type 'sbt_tape';
       RMAN> restore database skip tablespace temp;
       RMAN> sql "alter database datafile ''<temp datafile>'' offline drop";
       RMAN> sql "alter database open";
       RMAN> sql "drop tablespace temp";
       RMAN> sql "create tablespace temp datafile ''<filename>''";
       RMAN> }

" Au revoir" from Paris
Hieraklion

Syltrem wrote:

>I am restoring a database for someone to re-run a report.
>As not every tablespace / datafile is needed for this report, I did not
>restore all datafiles.
>I sometimes do this without problems as the un-needed tablespaces usually
>are not active and thus there are not transactions for those in the archive
>log files.
>
>What would happen if there were activities in the tablespaces not restored ?
>Would the recovery fail because some of the transactions could not be
>re-run?
>
>Thanks for your input.
>
>--
>
>Syltrem
>http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
>To reply to myself directly, remove .spammenot from my address
>
>
>
Received on Wed Mar 13 2002 - 09:27:09 CST