| General |
| Note:
Archive logging is essential for production databases where the loss of a transaction might
be fatal. It is generally considered unnecessary in development and test environments.
|
| |
| Init.ora Parameters |
Configure for multiple archiver processes |
log_archive_max_processes=<integer>; |
SELECT value
FROM gv
WHERE name = 'log_archive_max_processes';
ALTER SYSTEM SET log_archive_max_processes=3;
SELECT value
FROM gv
WHERE name = 'log_archive_max_processes'; |
| |
| Startup The Database In Archivelog Mode |
Steps Required To Take A Database Not In Archive Log Mode And Alter It To Archive Log Mode |
SELECT
log_mode
FROM v;
SHUTDOWN;
STARTUP MOUNT EXCLUSIVE;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
SELECT log_mode
FROM v; |
| |
| Startup The Database In NoArchivelog Mode |
Steps Required To Take A Database In Archive Log Mode And Alter It To No Archive Log Mode |
SELECT
log_mode
FROM v;
SHUTDOWN;
STARTUP MOUNT EXCLUSIVE;
ALTER DATABASE NOARCHIVELOG;
ALTER DATABASE OPEN;
SELECT log_mode
FROM v; |
| |
| Restart After Archiving Logging Failure |
| Archive Logging Restart |
SHUTDOWN;
STARTUP;
ARCHIVE LOG START;
ARCHIVE LOG ALL; |
| |
| Archive Log Related Commands |
| Start Archive Logging |
alter system archive log start; |
| Stop Archive Logging |
alter system archive log stop; |
| Force archiving of all log files |
alter system archive log all; |
| Force archiving of the current log file |
alter system archive log current; |
| |
| Shell Scripts |
Move Archive Logs |
export ARCH_DIR="/tmp/rim"
NEW_DIR ="/tmp/rim/new_dir"
export FILE_EXT="arc"
export MOVELIST="/tmp/move.list"
export CALF="/tmp/calc.tmp"
export TMPF="/tmp/workfile.tmp"
CMD="ls -ltr /*. | awk {'print $9'}
| sort -r > "
export FILE_COUNT="
echo "Number of files foundis "
cat
echo - 1" >
echo "quit" >>
MOVE ="/usr/bin/bc/ "
echo "Number of files to move is "
/usr/bin/tail - >
echo "File to be moved"
cat
while read FILE
do
cho "Moving file to "
done < |
Free