-
multiplexing controlfile
i have my controlfiles all in a single directory but was just thinking that won't be ideal enough,as shown below.
Code:
SQL> show parameters control_files;
NAME TYPE VALUE
-------- ----------- ------------------------------
control_files string C:\ORACLE\PRODUCT\10.1.\ORADATA\ORCL_1\CONTROL01.CTL,
C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL02.CTL,
C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL03.CTL
i need to make a multiplex to a new directory like
''C:\oracle\product\10.1.0\oradata\orcl_1\mulplx\CONTROL04.CTL''
If I do
alter system set control_file=''C:\oracle\product\10.1.0\oradata\orcl_1\CONTROL01.CTL'',''C:\oracle\product\10.1.0\or adata\orcl_1\mulplx\CONTROL04.CTL '' scope = spfile;
Will oracle synchronise the new controlfile withe the old ones even if they are in different directory.
thanks
-
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
If C drive fails
Is your C drive under raid?, else you need to put them in different drives.
-
sorry dbasan what do you mean by this
-
Originally Posted by seyiisq
sorry dbasan what do you mean by this
(disk) fails=crash=gone=dead=kaput
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Originally Posted by seyiisq
sorry dbasan what do you mean by this
I mean multiplexing to different drives, like
Code:
C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL01.CTL,
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL02.CTL,
E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL03.CTL
This will save you against media failure if your drives not under raid. Make sure you regularly backup your controlfile.
-
thanks, after multiplexing do i need to edit my initfile
note i use spfile which is the default
-
That depends on how you are setting. If you make location change in spfile before shutdown, then you need not change in pfile, also you cannot use pfile for startup.
Or the other way, change in pfile and then do a pfile startup and then create spfile and bounce the db. Its your choice.
-
I connected as sysdba did the following
1)shutdown immediate
2)copy the controlfile successfully to new directory using the
os command
3)startup nomount
Then i i tried setting the control file to the new one but got the error below.
Code:
SQL> alter system set control_files = ''C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL01.CTL'',''C:
\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\MLPLX_CTL\CONTROL01'' scope=spfile;
alter system set control_files = ''C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL01.CTL'',''C:\ORAC
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
I queried the v$parameter to confirm that i am using spfile as below
Code:
SQL> select name,value from v$parameter where name = 'spfile';
NAME VALUE
-----------------------------------------------------------------
spfile C:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE\SPFILEORCL1.ORA
SQL> select name,value from v$parameter where name = 'pfile';
no rows selected
pls can you help
[Updated on: Wed, 27 June 2007 19:01]
-
Is this a production database? When ever you touch a production database, read read read read and understand what you are doing and how you can do it.
Just read carefully, the last post from dbasan and do again.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|