| Copy an Oracle Database [message #110161] |
Thu, 03 March 2005 15:24  |
kapil2005
Messages: 44
Registered: March 2005
|
Member |
|
|
When copying the oracle database from one server to another server, do I need to copy the redo log files with data files?
Thanks
kapil
|
|
|
|
| Re: Copy an Oracle Database [message #110181 is a reply to message #110161] |
Thu, 03 March 2005 21:06  |
delarosa_ng
Messages: 3
Registered: March 2005
Location: Philippines
|
Junior Member |
|
|
yes, including the control files and all parameter files
check all files from :
v$datafile
v$controlfile
v$logfile
also your target server should have the same filesystem like your source server
Norvin
|
|
|
|
| Re: Copy an Oracle Database [message #110468 is a reply to message #110161] |
Mon, 07 March 2005 16:34 |
kapil2005
Messages: 44
Registered: March 2005
|
Member |
|
|
|
I dont think I need to copy the controlfiles and redo log files, i need to create the controfile scripts from backup controlfile. i think i should be just creating the dirs for controlfiles and redo log files and copy just datafiles and modify my controfile script and init.ora. correct me if that is wrong?
|
|
|
|
| Re: Copy an Oracle Database [message #110892 is a reply to message #110161] |
Thu, 10 March 2005 17:52 |
jbatista
Messages: 8
Registered: March 2005
Location: Horsham, PA
|
Junior Member |
|
|
Note. When copying files you can delete all controlfiles & RedoLogFiles. You need to do this if you want
to change the size of the redo log.
======================================================
Cloning a Database:
1. Backup the Production database or source database
2. Create a new control File w/resetlogs
alter database backup controlfile to trace resetlogs;
3. Navigate to the directory were the new control file will located and rename it to recrt_con.sql
C:\> move e:\oracle\admin\prodx1\udump\<trace_file> e:\oracle\admin\prodx1\udump\recr_con.sql
4. SHUTDOWN DATABASE - Perform a "Clean" Shutdown of the Source Database
5. CREATE NEW DB STRUCTURE DIRECTORIES
6. COPY FILES FROM OLD or source DB TO NEW DB
7. Modify the Parameter File for the Cloned Database
revise the init.ora parameter file (from the clone db) to reflect the new values for the target/clonbe database.
8. MODIFY CONTROL FILE to reflect the new values for the target/clonbe database. (SEE NOTES TO EDIT THIS FILE)
9. CREATE SERVICES FOR NEW DB (WINNT ORADIM) if you are running Windows
10. STARTUP NOMOUNT PFILE=E:\ADMIN\MY_DB_NAME\PFILE\INIT_MY_DB_NAME.ORA
11. CREATE CONTROL FILE
12. ALTER DATABASE OPEN RESETLOGS;
If Database is in Archive Log Mode and you want to disable Archiving, do the following:
Placing a database in no archive log mode.
ACTION PLAN
============
1. svrmgrl> connect / as sysdba
2. svrmgrl> shutdown immediate
3. svrmgrl> startup mount
4. svrmgrl> archive log list;
5. svrmgrl> alter system archive log stop;
6. svrmgrl> alter database noarchivelog;
7. svrmgrl> archvie log list;
8. svrmgrl> alter database open;
9. Edit your init.ora for the instance and comment out the log_archive_start parameter.
log_archive_start=False
10. Since you have change the archive log mode of the database, it is suggested that you take a cold backup.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
