You can even do something like:
alter database backup controlfile to trace as '/tmp/rename.sql';
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL> alter database backup controlfile to trace as '/tmp/rename.sql';
Database altered.
Then the search & rename step is no longer needed.
On 02/01/2004 01:36:26 PM, "Vergara, Michael (TEM)" wrote:
>
> 0. "alter database backup controlfile to trace". Find and rename
> this
> file to something significant like "rename_db.sql".
> > 1. Shut down the instance
> > 2. Copy all data files to the new locations
> 2.1 Copy rename_db.sql to new location
> > 3. Change the DB_NAME, dump directories, and redo log paths in the
> =
> init.ora file
> 3.1 modify rename_db.sql to reflect new locations of data files,
> control =
> files, etc.
> also change CREATE CONTROLFILE REUSE DATABASE "OLD_SID"
> to CREATE CONTROLFILE REUSE SET DATABASE "NEW_SID" =
> RESETLOGS
> in rename_db.sql
> > 4. startup nomount. Rename the redo logs
> "Rename the redo logs?" Never done that!
> 4.1 Startup nomount. @rename_db
> > 5. Create control file
> See step 4.1
> > 6. Open database.
> See step 4.1. rename_db.sql includes the lines...
> # Database can now be opened normally.
> ALTER DATABASE OPEN;
> ...which you should modify to '...OPEN RESETLOGS'.
>
> HTH,
> Mike
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@(protected)
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
--
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
