Home → Archive by category "oracle"
Category Archives: oracle
PL/SQL quickie; generate RMAN set newname script to different mountpoints
Script below generates RMAN newname file where database A is copied to database B AND database B has ‘conflicting’ mountpoints set up. Mountpoints setup on database A is like /m001/, /m002/, /m003/, /m004/ but mountpoints on database B side is just /m001/ and /m002. /m001 has only 800 G free space so I place everything in /m001 until i_num_bytes reaches 800G then all the reset goes to /m002.
declare i_num_bytes number := 0; v_mount varchar2(100); v_file varchar2(100); begin for i in (select file_id, file_name, bytes from dba_data_files order by file_id) loop i_num_bytes := i_num_bytes + i.bytes ; -- 800g if i_num_bytes < 858993459200 then v_mount := '/m001/oradata/********/' ; else
Fix ORA-00257: archiver error. Connect internal only, until freed – in Oracle 11G
When your database hangs with a ORA-00257 error while you notice there is plenty of space in the /recoveryarea mountpoint you’re likely to have reached the maximum size defined by the new ** initialization parameter ‘db_recovery_file_dest_size‘. Fast solution is to simply increase the value for db_recovery_file_dest_size (and after that of course start archiving…)
** 2012-04-02T12:10:; I see now the init parameter db_recovery_file_dest_size is not so new in fact has been around since Oracle 10.1 … OK….
Read more →