Oracle Switch datafile example

RMAN> report schema;

Report of database schema for database with db_unique_name DW

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    1250     SYSTEM               ***     /u01/app/oracle/oradata/dw/system01.dbf
2    860      SYSAUX               ***     /u01/app/oracle/oradata/dw/sysaux01.dbf
3    470      UNDOTBS1             ***     /u01/app/oracle/oradata/dw/undotbs01.dbf
4    861      USERS                ***     /u02/oradata/dw/USERS.dbf
5    100      EXAMPLE              ***     /u02/oradata/dw/EXAMPLE.dbf
6    10       FLOW_1               ***     /u02/oradata/dw/FLOW_1.dbf
7    250      FLOW_2               ***     /u01/app/oracle/oradata/dw/FLOW_2.dbf
8    250      FLOW_3               ***     /u02/oradata/dw/FLOW_3.dbf
9    1024     DM                   ***     /u02/oradata/dw/DM.dbf
10   20       DM_ARCHIVE           ***     /u02/oradata/dw/DM_ARCHIVE.dbf
11   556      APEX                 ***     /u02/oradata/dw/APEX.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    384      TEMP                 32767       /u01/app/oracle/oradata/dw/temp01.dbf

change datafile to

/u02/oradata/dw

sql 'ALTER TABLESPACE FLOW_2 OFFLINE';

COPY DATAFILE 7 TO '/u02/oradata/dw/FLOW_2.dbf';

SWITCH DATAFILE 7 TO COPY;

recover tablespace FLOW_2;

sql 'ALTER TABLESPACE USERS ONLINE';

*rman backup as copy before switch datafile ( image copy )

backup as copy datafile x format 'new_location_of_datafile';


Examples

RMAN> LIST ARCHIVELOG ALL;
RMAN> LIST BACKUP OF ARCHIVELOG ALL;
RMAN> LIST BACKUP;
RMAN> LIST BACKUP OF DATABASE;
RMAN> LIST BACKUP OF DATAFILE 1;
RMAN> LIST BACKUP SUMMARY;
RMAN> LIST INCARNATION;
RMAN> LIST BACKUP BY FILE;
RMAN> LIST COPY OF DATABASE ARCHIVELOG ALL;
RMAN> LIST COPY OF DATAFILE 1, 2, 3;
RMAN> LIST BACKUP OF DATAFILE 11 SUMMARY;
RMAN> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 1437;
RMAN> LIST CONTROLFILECOPY "/tmp/cntrlfile.copy";
RMAN> LIST BACKUPSET OF DATAFILE 1;
RMAN> LIST FAILURE;
RMAN> LIST FAILURE 641231 detail;

Cyrus-imapd error no mailbox

exp:
===
error: could not complete request. query: select "inbox" reason given: mailbox does not exist  
or
error: could not complete request. query: create "inbox/sent" reason given: permission denied

imapd.conf configuration
=============
[root@Grads etc]# vi imapd.conf
configdirectory: /var/lib/imap
partition-default: /var/spool/imap
admins: cyrus root <------------------- add root as cyrus admin
sievedir: /var/lib/imap/sieve
sendmail: /usr/sbin/sendmail
hashimapspool: true
sasl_pwcheck_method: saslauthd
sasl_mech_list: PLAIN
tls_cert_file: /etc/pki/cyrus-imapd/cyrus-imapd.pem
tls_key_file: /etc/pki/cyrus-imapd/cyrus-imapd.pem
tls_ca_file: /etc/pki/tls/certs/ca-bundle.crt
unixhierarchysep: yes

restart services
==========
service cyrus-imapd stop
service cyrus-imapd start

[root@Grads etc]# cyradm -u root localhost
localhost.localdomain> cm user/wilailak.1
localhost.localdomain> cm user/warut.ing
localhost.localdomain> lm user/wilailak.1
user/wilailak.1 (\HasChildren)
localhost.localdomain> lm user/warut.ing
user/warut.ing (\HasNoChildren)

ref:
http://oreilly.com/catalog/mimap/chapter/ch09.html
http://doc.norang.ca/cyrus-imap-server.html

Solaris 10 Date, Time

Manual Setting
===========
#date “month day hour minute year”
# date 1201010106
Fri Dec  1 01:01:00 PST 2006

sync with time server
===============
#ntpdate xxx.xxx.xxx.xxx

ESXi 5.5 vib install (driver on ESXi)

esxcli system module list

esxcli software vib install -v  <path-drivername>

esxcli software vib install -v /tmp/Brocade_bootbank_scsi-bfa_3.2.4.0-1OEM.500.0.0.472560.vib


#remove

# esxcli software vib remove -n vendor vib name -f

Check Driver Version
================
 ethtool -i vmnic9

Disable NIC  fcoe
==============
Esxcli fcoe nic disable -n=vmnic8

ipv6

netsh interface ipv6 set privacy state=disabled store=active
netsh interface ipv6 set privacy state=disabled store=persistent
netsh interface ipv6 set global randomizeidentifiers=disabled store=active
netsh interface ipv6 set global randomizeidentifiers=disabled store=persistent

Relay client qmail

Relay client File:

/etc/tcp.smtp

restart qmail services:

/var/qmail/bin/qmailctl stop
/var/qmail/bin/qmailctl start

Clean up metadata ntdsutil

ntdsutil: metadata cleanup (enter)

metadata cleanup: select operations target (enter)

select operation target: connections (enter)

server connections: connect to domain <DNS-Domain-Name> (enter)

server connections: quit (enter)

select operation target: list domains (enter)

select operation target: select domain <Domain-Number> (enter)

select operation target: list sites (enter)

select operations target: select site <Site’s-Number> (enter)

select operation target: list servers in site (enter)

select operation target: select server <Failed-DC-Number> (enter)

select operation target: quit (enter)

metadata cleanup: remove selected server (enter)

metadata cleanup: quit (enter)

ntdsutil: quit (enter)