Fulltext results:

Oracle: Recovery Manager

3 Hits, Last modified: 13 years ago

45 days: <code sql> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> To remove archive ... <code sql> DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> A sample script co... << __EOF__ DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -3'; EXIT __EOF__ </code> {{tag>

Oracle: SPFile and PFiles

2 Hits, Last modified: 13 years ago

==== Oracle reads its parameters from a file called "SPFile". You can't change it directly as it's a ... HUTDOWN IMMEDIATE; </code> If your PFile is located at ''/db/oracle/config/pfiles/initweb.ora'', the

Oracle Errors

1 Hits, Last modified: 13 years ago

: archiver error. Connect internal only, until freed. ===== * **Reason**: The flash recovery area i

Oracle: Resize Instance

1 Hits, Last modified: 13 years ago

nce ====== In this example, the SGA will be resized to 6GB and the PGA to 2GB. First, change the [[s