Thursday, 21 June 2018

General good apps dba commands

1)  create oracle password file
orapwd file=orapw<sid> password=hot entries=5

orapwd file=orapwtst8 password=hot entries=5

2) Restore archive log to destination form seq to seq
run {
 set archivelog destination to /temp/lnp1';
 restore archivelog from logseq=29096 until logseq=29134;
 }

 

No comments:

Post a Comment

SQL Shared Area - BIND MISMATCH