Fulltext results:

Oracle: SPFile and PFiles

5 Hits, Last modified: 12 years ago

he PFile instead of ${PATH_TO_PFILE}. <code sql> SHUTDOWN IMMEDIATE; STARTUP NOMOUNT PFILE='${PATH_TO_PFILE}' CREATE SPFILE FROM PFILE; SHUTDOWN IMMEDIATE; </code> If your PFile is locate... > ===== Initialization Parameters ===== ==== Flash Recovery Area ==== === DB_RECOVERY_FILE_DEST_SIZ... ERY_FILE_DEST_SIZE'' specifies the size of the flash recovery area. * For more inforamtion, see the

Oracle: Recovery Manager

3 Hits, Last modified: 12 years ago

===== ===== Start Recovery Manager ===== <code bash> rman target / </code> ===== Delete Archive Logs... ng all logs except the last three days): <code bash> #!/bin/bash . ${HOME}/.profile rman target / << __EOF__ DELETE NOPROMPT ARCHIVELOG ALL COMPLETED

Oracle Errors

2 Hits, Last modified: 12 years ago

only, until freed. ===== * **Reason**: The flash recovery area is full. * **Resolution**: [[rman... *Resolution**: [[spfile_and_pfiles|Enlarge the flash recovery area]]. * **Documentation**: [[http://

Oracle: EXP

1 Hits, Last modified: 12 years ago

the account name insteand of ''{user}''. <code bash> exp USERID=\'/ as sysdba\' FILE={user}.dmp FULL=

Oracle: SQLplus Scripting

1 Hits, Last modified: 12 years ago

====== Oracle: SQLplus Scripting ====== To show only data in SQLplus and no header or other stuff, en

Oracle: Resize Instance

1 Hits, Last modified: 12 years ago

the instance to activate the change: <code sql> SHUTDOWN IMMEDIATE; STARTUP; </code> {{tag>admin or