DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER SPFILE SET DB_UNIQUE_NAME=”st_mjidb” comment “Is a duplicate” SET LOG_ARCHIVE_DEST_2=”service=st_mjidb ASYNC REGISTER VALID_FOR=(online_logfile,primary_role)” set audit_file_dest=”/u01/app/oracle/admin/mjidb/adump” set control_files=”/Data/oradata/mjidb/control01.ctl”,”/Data/oradata/fast_recovery_area/mjidb/control02.ctl” set DB_FILE_NAME_CONVERT=’mjidb’,’st_mjidb’ set LOG_FILE_NAME_CONVERT=’mjidb’,’st_mjidb’ SET FAL_CLIENT=”st_mjidb” COMMENT “Is standby” SET FAL_SERVER=”mjidb” COMMENT “Is primary” NOFILENAMECHECK; чтоб стендбай накатил логи(на нем): ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Script – List SQL being executed by a particular SID
col sql_text format a100 heading “Current SQL” select q.sql_text from v$session s , v$sql q WHERE s.sql_address = q.address and s.sql_hash_value + DECODE (SIGN(s.sql_hash_value), -1, POWER( 2, 32), 0) = q.hash_value AND s.sid=&1;
Script – Find SQL being executed by a OS Process ID (PID)
prompt “Please Enter The UNIX Process ID” set pagesize 50000 set linesize 30000 set long 500000 set head off select s.username su, substr(sa.sql_text,1,540) txt from v$process p, v$session s, v$sqlarea sa where p.addr=s.paddr and s.username is not null and s.sql_address=sa.address(+) and s.sql_hash_value=sa.hash_value(+) and spid=&SPID;
16200/cs
контент-сервер. админ удалил себя из админов или просто забыли пароль. сбрасываем и получаем доступ через апплет, запущенный в cli update users set dpasswordencoding=’idc’ where dname like ‘sysadmin’; update users set dpassword=’idc’ where dname like ‘sysadmin’;commit;
dshb
cnv