Fulltext results:

Oracle: Recovery Manager

3 Hits, Last modified: 13 years ago

: <code sql> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> To remove archive logs ol... sql> DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> A sample script could be ... OF__ DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -3'; EXIT __EOF__ </code> {{tag>admin d

Oracle: SPFile and PFiles

1 Hits, Last modified: 13 years ago

cle can read the parameters from "PFiles", which are regular text files. ===== Create PFile ===== To... s the size of the flash recovery area. * For more inforamtion, see the documentation: [[http://down