Prasanthkumar Reddy.M wrote:cant do it, need to move datafiles to new diskgroup with external redudancy which doesnt mirror. It assumes youre mirroring or raiding on the storage already. You cant change the redundancy of an existing group.
I facing a issue with Diskgroup in ASM@Test server..
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 16730790 16730331 1520980 7604675 0 N DATADG001/
MOUNTED NORMAL N 512 4096 1048576 162140 161950 0 80975 0 N FRA/
MOUNTED NORMAL N 512 4096 1048576 14331 13405 310 6547 0 Y SYSTEMDG/
Usable_file_mb space is equal to total_mb...when i am trying to restore space getting complete due to mirroring..getting with below error
channel CH2: ORA-19870: error while restoring backup piece MDA_2ao59uuj_1_1
ORA-19504: failed to create file "+DATADG001"
ORA-17502: ksfdcre:4 Failed to create file +DATADG001
ORA-15041: diskgroup "DATADG001" space exhausted
can you please suggest me some what of urgency that how to disable mirroring for diskgroup and make equal space for both Total_MB and Usable_file_MB..!
Thanks & Regards
See 188.8.131.52 Using Wallets with Automatic Login Enabled at http://docs.oracle.com/cd/E11882_01/network.112/e10746/asotrans.htm#sthref86
ORA-28365: wallet is not open Cause: The security module wallet has not been opened. Action: Open the wallet.
can you let me know how can i check the database links that which jobs updating data?I can't help you there. You'd have to look at the database objects and the application code and jobs.
if we have any jobs running how we can diasable the jobs,
Is i need remove the entries in /etc/hosts file regarding production?Some sites have seperate networks to as to prevent test/develpment connecting to prod. (But you'd have to see if your network restore of the database can be done).