Fulltext results:

Oracle: SPFile and PFiles

20 Hits, Last modified: 14 years ago

====== Oracle: SPFile and PFiles ====== Oracle reads its parameters from a file called "SPFile". You can't change it directly as it's a binary file. Additionally, Oracle can read the parameters from "PFiles", which are regular text files. ===== Create PFile ===== To export th

Oracle Errors

12 Hits, Last modified: 14 years ago

57: archiver error. Connect internal only, until freed. ===== * **Reason**: The flash recovery area is full. * **Resolution**: [[rman|Remove archive logs]]. * **Resolution**: [[spfile_an

Oracle: Recovery Manager

7 Hits, Last modified: 14 years ago

====== Oracle: Recovery Manager ====== ===== Start Recovery Manager ===== <code bash> rman target / </code> ===== De... : <code sql> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> To remove archive logs older than 3 days without prompting, e.g. via cron, af

Oracle: Resize Instance

5 Hits, Last modified: 14 years ago

====== Oracle: Resize Instance ====== In this example, the SGA will be resized to 6GB and the PGA to 2GB. First, change th... les|SPFile]]: <code sql> ALTER SYSTEM SET pga_aggregate_target = 2G SCOPE=SPFILE; ALTER SYSTEM SET sg... nally) export the SPFile to a PFile: <code sql> CREATE PFILE FROM SPFILE; </code> Finally, reboot th

Oracle

2 Hits, Last modified: 11 years ago

homepage|Oracle Database Online Documentation 10g Release 2 (10.2)]] * [[http://www.oracle.com/pls/db112/homepage|Oracle Database Online Documentation 11g Release 2 (11.2)]] {{tag>oracle topic}}