SELECT dl.owner
,dl.db_link
,dl.username login_name
,dl.host
,to_char(dl.created,'YYMMDD HH24:MI') crdate
FROM dba_db_links dl
ORDER BY dl.owner
,dl.db_link
,dl.db_link
,dl.username login_name
,dl.host
,to_char(dl.created,'YYMMDD HH24:MI') crdate
FROM dba_db_links dl
ORDER BY dl.owner
,dl.db_link
virtualnuggets offering oracle dba online training,corporate training services.
ReplyDeleteHow to recover online redo’s?
Target>select member from v$logfile;
Target>archive log list;
Target>select group#, sequence#, status from v$log;
Target>!
$cd dev/log/log/
$rm –rf *
Rman>startup mount force;
Rman> restore database force;
Rman>list backup of archivelog all;
Rman>recover database until logseq number;
Rman>sql ‘alter database open resetlogs’;
Rman>reset database;
target>archive log list;
rman>delete backupset number;