nobleit
asked on
multiplexing control files
I was trying to multiplexing control files
Database altered.
Elapsed: 00:00:04.64
SQL> alter database open;
Database altered.
Elapsed: 00:00:28.50
SQL> show parameters control_files;
NAME TYPE VALUE
-------------------------- ---------- ----------- -------------------------- ----
control_files string C:\APP\MATHEW\ORADATA\COMP ANY\
CONTROL01.CTL, C:\APP\MATHEW\O
RADATA\COMPANY\CONTROL02.C TL,
C:\APP\MATHEW\ORADATA\COMP ANY\
CONTROL03.CTL
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> host copy C:\APP\MATHEW\ORADATA\COMP ANY\CONTRO L01.CTL C:\APP\MATHEW\ORADATA\COMP ANY\CONTRO L02.CTL C:\APP\MATHEW\ORADATA\COMP ANY\CONTRO L03.CTL
The syntax of command is incorrect. (The message is shown like this)
What could be the reason?
or else is there any way to multiplex the control files
Database altered.
Elapsed: 00:00:04.64
SQL> alter database open;
Database altered.
Elapsed: 00:00:28.50
SQL> show parameters control_files;
NAME TYPE VALUE
--------------------------
control_files string C:\APP\MATHEW\ORADATA\COMP
CONTROL01.CTL, C:\APP\MATHEW\O
RADATA\COMPANY\CONTROL02.C
C:\APP\MATHEW\ORADATA\COMP
CONTROL03.CTL
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> host copy C:\APP\MATHEW\ORADATA\COMP
The syntax of command is incorrect. (The message is shown like this)
What could be the reason?
or else is there any way to multiplex the control files
ASKER
no this is totally different for sure..thank you
Ok then...not sure...
What command syntax is wrong?
What command syntax is wrong?
ASKER
To copy control file in 8 different locations..
I mentioned I don't think copy works that way.
Did you try 8 individual copy commands?
Did you try 8 individual copy commands?
ASKER
Could you please help me to multiplex control file..
Actually I was trying to multiplex...
Actually I was trying to multiplex...
Going from memory:
Shut down the instance.
Make the copies (one at a time).
Startup nomount.
Alter the spfile with alter system commands
Or
Edit the pfile and startup with it.
Then open the database.
If started with pfile, then recreate the spfile.
Shut down the instance.
Make the copies (one at a time).
Startup nomount.
Alter the spfile with alter system commands
Or
Edit the pfile and startup with it.
Then open the database.
If started with pfile, then recreate the spfile.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The dos copy command is: copy from_file to_file
Try one copy at a time...