Re: changing location of datafiles.

From: Mauro Giovara <mauro.giovara_at_its.it>
Date: Wed, 27 May 1998 17:23:56 +0200
Message-ID: <356C300B.BA9082A5@its.it>

Mike Mountjoy wrote:

> Hi There.
>
> I've recently archived a little used database on a machine short
> of space.
>
> I now want to reactivate this database on a different machine using the
> same version of the server/OS and the same ORACLE_SID. The directory
> location is different , however.
>
> Is there a way of doing this without first restoring the datafiles to the
> orginal
> machine and doing a export/import to the new machine.
>
> Regrds,
> Mike

After restoring the datafiles in your BIG machine try to create a new version of controlfiles with the following commands:

# The following commands will create a new control file and use it
# to open the database.
# No data other than log history will be lost. Additional logs may
# be required for media recovery of offline data files. Use this
# only if the current version of all online logs are available.

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "<db name>" NORESETLOGS NOARCHIVELOG

    MAXLOGFILES <?>
    MAXLOGMEMBERS <?>
    MAXDATAFILES <?>
    MAXINSTANCES <?>
    MAXLOGHISTORY <?>
LOGFILE
  GROUP 1 (
    '<new path file>',
    '<new path file>'
  ) SIZE <?>,
  GROUP 2 (
    '<new path file>',
    '<new path file>'
  ) SIZE <?>
DATAFILE
  '<new path file>',
  '<new path file>'
;
# Recovery is required if any of the datafiles are restored backups, # or if the last shutdown was not normal or immediate. RECOVER DATABASE
# Database can now be opened normally.
ALTER DATABASE OPEN; Bye.

--
Mauro Giovara (mauro.giovara_at_its.it)
Phone: +39 11 6853066
Fax: +39 11 6853583 Received on Wed May 27 1998 - 10:23:56 CDT