Method 1
1.conn username/pwd@server
2.create pfile='dir\inifile.ini' from spfile='%oracle_home%\db_1\dbs\spfilesid.ora'
3.shutdown db system
4.edit inifile.ini file for add lines of new control file location.
5.copy control files to multi locaition.
6. startup db nomount.
7. copy spfile='%oracle_home%\dbs\spfile_sid.ora.new' from pfile='dir\inifile.ini'
8.alter database mount;
9. alter database open;
get txt version of control file:
alter database backup controlfile to trace
------------------------------------------
Method 2
1.SQL> ALTER SYSTEM SET CONTROL_FILES ='C:\ORA\DATA\CONTROL\CONTROL1.CTL','D:\ORA\DATA\CONTROL\CONTROL1.CTL'SCOPE = SPFILE;
2.SHUTDOWN NORMAL
3. COPY CONTROL FILE
4. STARTUP
Saturday, December 09, 2006
Multi control files on 10G Oracle
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment