| delete datafile in Primary [message #555669] |
Sat, 26 May 2012 23:40  |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Dear all,
I haved drop a datafile on Primary,and the archived log has transported to Standby,but the datafile is still exist in Standby. Why?
Primary
alter tablespace tps_hxl
drop datafile '/u02/app/oracl/oradata/hxl10.dbf';
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: delete datafile in Primary [message #556071 is a reply to message #555669] |
Thu, 31 May 2012 02:52  |
|
|
Hi,
If you want automatically delete standby datafile, you must set *.standby_file_management parameter file value AUTO on primary and standby.
Becouse, if you make switchover, after that old standby chage role to primary and primary change role to standby.
After switchover you can delete datafile, and old primary must delete file automatically.
Regards.
Mahir M. Quluzade
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
