(BOT) Oracle 9i database movement Oracle 9i database movement Powerise Software Park in starmoon2003 Mobile databases, in the course of implementation of the project, often, for an experienced DBA, the mobile database is very easy. For those who understand only the system database is not very understanding of the staff, it is much of Oracle's mobile capacity. For example, when installation is completed, the expansion of the storage space needed for the original of the Oracle Mobile, the need for mobile data. Previously ORACLE8I FOR WINDOWS 2000 to be able to conduct the movement. Now ORACLE9I FOR WINDOWS 2000 Mobile do? ? ? A complex system of mobile data files 1), to obtain relevant information database The database must first look into the contents of the documents : Sqlplus "/ as sysdba" O select * from v$datafile; O select * from v$controlfile O select * from v$logfile; 2), the mobile application data files Shutdown immediate closure of the database, copy data files to another catalog. Need copy of the document : System01.dbf Indx01.dbf Temp01.dbf Users01.dbf Application data files 3), document the location of database changes MOUNT model launched ． startup mount; ． alter database rename file 'c:\oracle\oradata\ocp\system01.dbf' to 'd:\oradata\ocp\system01.dbf " ． alter database rename file 'c:\oracle\oradata\ocp\indx01.dbf' to 'd:\oradata\ocp\indx01.dbf'; Mobile attention can make changes to the database documents, including control of documents and log files, TEMPEST documents. 2. Mobile document control (1) which reads : Backup SPFILE Re-activated database : ． startup; ． create pfile= 'c:\init.ora' from spfile; (2) Revise the init.ora document : *.control_files= 'D:\oradata\ocp\control01.ctl,' 'd:\oradata\ocp\control02.ctl,' 'd:\oradata\ocp\control03.ctl' Contents position has been complicated by a change in the system. Shutdown database (3) control document duplicating the past, Control of the top three mobile document, which was revised by the catalog. (4) Add Parameter File Init.ora parameters to be initiated : ． startup pfile= 'c:\init.ora'; ． create spfile from pfile= 'c:\init.ora'; ． shutdown immediate; ． startup; spfile conducted from the start. This document control mobile work will be concluded. Third, reconstruction or reduction spaces LOG document There are two ways to solve log files Mobile, a mobile (RENAME way) is a re-creation. (1) Mobile LOG document Mobile database file and database re-Mobile is the same document, only the database must be "startup mount" method. ． startup mount ． alter database rename file 'c:\oracle\oradata\oralog1.ora' to 'd:\oradata\ocp\oralog1.dbf' Kind (2) documents reconstruction LOG GROUP rebuild a team first, the exchange of documents and to add a LOG document. ALTER DATABASE ADD LOGFILE GROUP 4 ( '$HOME/ORADATA/u01/log4.rdo,' '$HOME/ORADATA/u02/log4.rdo') SIZE 1M; LOG then delete the other group, which calls for maintaining a two LOG Division in the system. Alter database drop logfile member 'c:\oracle\oradata\ocp\oralog01.ora' Fourth, rebuilding systems supervisor at (temperature) File System Table space in the mobile data, mobile TEMPEST documents were not here asking for a renewal TEMPEST table space, and a tacit TEMPEST documents for the system. In addition to the original list then TEMPEST table space, reaching Mobile table space. "; Create temporary tablespace "temp02" tempfile 'd : \oradata\ocp\temp02.dbf 'size 500m extent management local uniform size bias TEMPEST then delete the original document would be fine. 5 test database ORACLE data for restart $ Sqlplus "/as sysdba" ． startup; O show sga; ． 6, meaning : This is a little test, and large system needs upgrading, we must consider this form of mobile database file. Is the system of planning, a little adjustment. : (BOT) Oracle 9i database movement Top of my useful (BOT) Oracle 9i database movement Thank you, (BOT) Oracle 9i database movement ! ! (BOT) Oracle 9i database movement On the way to ask a question, please correct me boss! Large databases of transplant promotion I often encountered previously in 8I NOLOG model, I used the closed data, copy data files and Redo Log documents, the documents parameters A new catalog, revised parameters, and then start a startup nomount way, Contents reconstruction control with a new document (RESETLOGS), alter database Open resetlogs. This method is feasible. 9I in which it is not alright (NOLOG). DB suggested the need RECOVER really RECOVER USING BACKUP DATABASE CONTROLFILE UNTIL CANCEL, DB also suggest different system01.dbf His! By reading a crescendo, I think the front part of document control is the same way with the use of redevelopment Achieve the same purpose, that is, change control and document data table space Redo Log file, I also re-built in the last 9I a new TEMPEST table space. Why so? I METALINK exchanges without the ORACLE SUPPORT To the correct answer. Boss also requested correction! ! ! (BOT) Oracle 9i database movement Brothers, a half truth, if the movement is based on the file system is, of course, no reconstruction control document. : Mobile process, there is a sequence of the first shift data files, and then shift control document. If it is filed, it can be changed - first filed for that shift. (BOT) Oracle 9i database movement Thank you first! Actually, I was to complete complex system of the original DB to another DB, I 8I on the method used to be a success. 9I has nowhere. I am sure that if you say the method is feasible. 9I used in the reconstruction of control will not work on a database to fragment? I turned around and put me in the method used to lay down, please correct me! (BOT) Oracle 9i database movement DB model assumptions in NOARCHIVELOG A. TRACE paper documents under control in creating SQL scripts Sqlplus /nolog Conn / as sysdba; Alter database backup controlfile to trace; Shutdown immediate; Exit; B. Duplicating data files, be a log file, a list of parameters to a new document C. SQL script to create the document revision control, change the database name, REUSE SET to change to RESETLOGS D. Redo Log revised script documents, data files list names. Apart from creating documents to delete the other SQL control orders. E. Laws to control paper documents list the name of the new parameters. F. DB set up a new environment variable. And the opening of a new environment for DB parameters documents can be found. G. Sqlplus /nolog Conn / as sysdba; Startup nomount; @ Founding document control script. Sgl Alter database open resetlogs; This sentence wrong. Asked RECOVER Recover database using backup controlfile until cancel This remark was a problem and ask for the documents in the archives. NOARCHIVE model, not the documents in the archives! If the above is not a mistake, add the following on a temporary table space I was pondering this way, if the documents used to establish control RESETLOGS parameters REDO will not use the original documents to be redeveloped REDO a new document? Conversely, if the use of NORESETLOGS parameters can then be used to document the original REDO? Please give pointers! ! (BOT) Oracle 9i database movement This method can not be used among different version? Otherwise, migration is not too easy. Migration paths for the older releases to Oracle9i : A. For Version 6 and Version 7 (7.3.3 and lower) : 1. Upgrade to version 7.3.4 2. Upgrade to Oracle9i B. For Releases Arc/Info8.0.1 to 8.0.5, upgrade to 8.0.6 or later C. For 8i Version 8.0.6 or later and, using upgrade - Oracel Data Upgrade Assistant - Manual upgrade Http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96530/toc.htm (BOT) Oracle 9i database movement I would like to ask, if we want to move to another machine, how do? [ Closed window ]