Kwiecień « 2013 « Różności …

Różności …

25 kwietnia 2013

mail session

Zaszufladkowany do: Linux — Tagi: — Jacek @ 11:05
MAIL FROM:<God@heaven.af.mil>
     250 ok
     RCPT TO:<angels@heaven.af.mil>
     250 ok
     DATA
     354 ok

     Hi, guys.
     Just testing our new mail system.
     .
     250 Written safely to disk. #902487694.289148.12219.

Kolejność działań

Zaszufladkowany do: Oracle — Tagi: — Jacek @ 07:50

24 kwietnia 2013

Oracle Virtual Box shared foleders.

Zaszufladkowany do: Oracle — Tagi: — Jacek @ 07:34

http://www.oracledistilled.com/virtualbox/create-and-mount-virtualbox-shared-folders/

22 kwietnia 2013

FAST RECOVERY AREA

Zaszufladkowany do: Oracle — Tagi: — Jacek @ 09:10

FAST RECOVERY AREA

http://umardba.blogspot.com/2009/12/how-to-change-flash-recovery-area-to.html

sql> select value from v$parameter where name like ‘%db_recovery%;
sql> select value from v$paremeter where name=’control_files’;
sql> show parameter control_files;

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+disk1' SCOPE=BOTH SID='*';
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH;
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;
sql> alter system switch logfile;
rman> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
RMAN> show all;
RMAN> list backup;
RMAN> list expired backup;
http://gavinsoorma.com/2009/12/11g-release-2-rman-backup-compression/  
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
RMAN> CONFIGURE COMPRESSION ALGORITHM ‘HIGH’;
or
RMAN> CONFIGURE COMPRESSION ALGORITHM ‘MEDIUM’;
or
RMAN> CONFIGURE COMPRESSION ALGORITHM ‘LOW’;
or
RMAN> CONFIGURE COMPRESSION ALGORITHM ‘BASIC’;
Unfortunately, unless you have purchased the Advanced Compression Option, your only choice is BASIC.
rman>list backup summary;
rman>DELETE BACKUPSET 145913,145914,145915,145916,145917;
rman>delete obsolete;
rman> crosscheck backup;
rman> crosscheck copy;
rman> list archivelog all;
rman> delete backup;

rman> DELETE NOPROMPT ARCHIVELOG ALL;
rman> delete noprompt archivelog until time 'SYSDATE-10';

SELECT * FROM v$recovery_file_dest; SELECT * FROM v$recovery_area_usage;

RMAN (Oracle docs)
http://docs.oracle.com/cd/E29597_01/backup.1111/e10642/rcmmaint.htm

ORACLE 9i

rman> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/ora_df%t_s%s_s%p';

Retention policy
rman> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;



Strona startowa: www.jaceksen.pl