Przejdź do głównej zawartości

オラクル | oracle blog | Kamil Piórek | kamil.piorekk@gmail.com

Szukaj na tym blogu

Pobierz link
Facebook
Twitter
Pinterest
E-mail
Inne aplikacje

http://dbareactions.com/post/79592872533/when-the-new-systems-vendor-says-the-users-will#notes-wrap

Pobierz link
Facebook
Twitter
Pinterest
E-mail
Inne aplikacje

Komentarze

Prześlij komentarz

Popularne posty

RMAN DUPLICATE ORA-19838 RMAN-06054 || ORA-19838: Cannot use this control file to open database || RMAN-06054: media recovery requesting unknown archived log

****************************************************************************************** RMAN DUPLICATE ORA-19838 RMAN-06054 **** Rman Script connect catalog '<rmanuser>/<rmanuser_pwd>@<tns_for_rman_catalog>'; connect auxiliary / ; run { allocate auxiliary channel t1_db device type sbt parms="ENV=(NB_ORA_SERV=<hostname>, NB_ORA_CLIENT=<hostname>)"; allocate auxiliary channel t2_db device type sbt parms="ENV=(NB_ORA_SERV=<hostname>, NB_ORA_CLIENT=<hostname>)"; allocate auxiliary channel t3_db device type sbt parms="ENV=(NB_ORA_SERV=<hostname>, NB_ORA_CLIENT=<hostname>)"; allocate auxiliary channel t4_db device type sbt parms="ENV=(NB_ORA_SERV=<hostname>, NB_ORA_CLIENT=<hostname>)"; duplicate database <src_db_name> to <dsT-db_name>; release channel t1_db; release channel t2_db; release channel t3_db; release channel t4_db; } ************************************

ORA-00305: log 1 of thread 1 inconsistent; belongs to another database

log_file_name_convert fail ;) ORA-00305 DUPLICATE| RMAN ORA-00305 | REDO ORA-00305 ORA-00305: log 1 of thread 1 inconsistent; belongs to another database Errors in file /oracle/app/product/diag/rdbms/scomm/scomm/trace/scomm_m000_2253032.trc: ORA-00305: dziennik 6 wątku 1 jest niezgodny; należy do innej bazy danych ORA-00312: dziennik online 6 wątek 1: '/oradb1/scomm/redo06.log' Errors in file /oracle/app/product/diag/rdbms/scomm/scomm/trace/scomm_m000_2253032.trc: ORA-00305: dziennik 7 wątku 1 jest niezgodny; należy do innej bazy danych ORA-00312: dziennik online 7 wątek 1: '/oradb1/scomm/redo07.log' Errors in file /oracle/app/product/diag/rdbms/scomm/scomm/trace/scomm_m000_2253032.trc: ORA-00316: dziennik 8 wątku 1, typ 0 w nagłówku nie jest plikiem dziennika ORA-00312: dziennik online 8 wątek 1: '/oradb1/scomm/redo08.log' SQL> select GROUP#, status,MEMBERS ,archived from v$log ; GROUP# STATUS MEMBERS ARC ---------- ---------------- ---------

Oracle Database | Read Files In Directory by java | #OakTable

create global temporary table DIR_LIST ( filename varchar2(255) ) on commit delete rows; / GRANT JAVAUSERPRIV to privilegedUser create or replace and compile java source named "DirList" as import java.io.*; import java.sql.*; public class DirList { public static void getList(String directory) throws SQLException { File path = new File( directory ); String[] list = path.list(); String element; for(int i = 0; i < list.length; i++) { element = list[i]; #sql { INSERT INTO DIR_LIST (FILENAME) VALUES (:element) }; create or replace procedure get_dir_list( p_directory in varchar2 ) as language java name 'DirList.getList( java.lang.String )';

Obsługiwane przez usługę Blogger