Przejdź do głównej zawartości

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

Szukaj na tym blogu

Pobierz link
Facebook
X
Pinterest
E-mail
Inne aplikacje

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

Pobierz link
Facebook
X
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 ---------- ---------------- ---------

DBMS_METADATA.GET_DDL database link password missing | Oracle 11.2.0.4 DB_LINK password metadata

SQL> CREATE DATABASE LINK "DBLINK" CONNECT TO "USER1" IDENTIFIED BY VALUES ':1' USING 'ORCL'; 2 3 CONNECT TO "USER1" IDENTIFIED BY VALUES ':1' * ERROR at line 2: ORA-02153: invalid VALUES password string SELECT col1,REPLACE(To_Char(col2),':1',(SELECT PASSWORDX FROM link$ WHERE owner#=v3.owner# AND name=v3.name)) FROM (SELECT 'DROP PUBLIC DATABASE LINK '||v1.name||' ;' AS col1,dbms_metadata.get_ddl('DB_LINK',v1.name,v2.name)||';' AS col2, v1.owner#,v1.name FROM link$ v1 , user$ v2 WHERE v1.owner#=v2.user# AND v1.owner# = 1 ) v3; Kamil Piórek kamil.piorekk@gmail.com

Obsługiwane przez usługę Blogger