Fulltext results:

Oracle: SPFile and PFiles

10 Hits, Last modified: 12 years ago

he parameters from the PFile to the SPFile, you have to boot the instance from the PFile and the write the SPFile. You have to enter the path to the PFile instead of ${PATH_... = Initialization Parameters ===== ==== Flash Recovery Area ==== === DB_RECOVERY_FILE_DEST_SIZE === The parameter ''DB_RECOVERY_FILE_DEST_SIZE'' specifi

Oracle: Recovery Manager

9 Hits, Last modified: 12 years ago

====== Oracle: Recovery Manager ====== ===== Start Recovery Manager ===== <code bash> rman target / </code> ===== Delete Archive Logs ===== Delete all archive logs but keep the last 45 days: <code sql> DELETE ARCHIVELOG ALL COMP

Oracle Errors

7 Hits, Last modified: 12 years ago

===== Oracle Errors ====== ===== ORA-00257: archiver error. Connect internal only, until freed. ===== * **Reason**: The flash recovery area is full. * **Resolution**: [[rman|Remove archive logs]]. * **Resolution**: [[spfile_and_pfiles|Enlarge the flash recovery area]]. * **Docu

Oracle: SQLplus Scripting

1 Hits, Last modified: 12 years ago

SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET MARKUP HTML OFF SPOOL