Fulltext results:

Oracle: SPFile and PFiles

11 Hits, Last modified: 12 years ago

====== Oracle: SPFile and PFiles ====== Oracle reads its parameters from a file called "SPFile". You ... y as it's a binary file. Additionally, Oracle can read the parameters from "PFiles", which are regular text files. ===== Create PFile ===== To export th... ===== Initialization Parameters ===== ==== Flash Recovery Area ==== === DB_RECOVERY_FILE_DEST_SIZE =

Oracle Errors

7 Hits, Last modified: 12 years ago

Connect internal only, until freed. ===== * **Reason**: The flash recovery area is full. * **Resolution**: [[rman|Remove archive logs]]. * **Resolution**: [[spfile_and_pfiles|Enlarge the flash re

Oracle: Recovery Manager

3 Hits, Last modified: 12 years ago

====== Oracle: Recovery Manager ====== ===== Start Recovery Manager ===== <code bash> rman target / </code> ===== De... G ALL COMPLETED BEFORE 'SYSDATE -45'; </code> To remove archive logs older than 3 days without prompt

Oracle: Resize Instance

3 Hits, Last modified: 12 years ago

====== Oracle: Resize Instance ====== In this example, the SGA will be resized to 6GB and the PGA to 2GB. First, change th... sql> CREATE PFILE FROM SPFILE; </code> Finally, reboot the instance to activate the change: <code s

Oracle

2 Hits, Last modified: 9 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}}