Welcome to SCSI
AIX: How to access LPAR console from BLADE MM PDF Print E-mail
Written by Wira Chinwong   
Monday, 26 September 2016 23:25

IBM Blade Power

1. Connect to MM

2. console -T system:blade[6]      (6 = BLADE Server ID)

3.   mkvt -id x    (x = lpar ID)

 
Oracle: ลบ datafile ขณะที่ database กำลัง online PDF Print E-mail
Written by Wira Chinwong   
Wednesday, 08 January 2014 19:36

Oracle version 9

 

Case: มีการสร้าง datafile ขึ้นมาใหม่ แล้วเผลอลบทิ้งขณะที่ database กำลัง online อยู่ โดยที่ไม่มี Backup เลย แต่มี archive log ครอบคลุมตั้งแต่วันที่สร้าง datafile

 

solved:

1. สร้าง datafile ชื่อเดิม

alter database create datafile '/oracle/data02.dbf';

 

2. หา Datafile number แล้วก็ทำการ recover

select file#,name from v$datafile where name like '%data02.dbf';

 

recover datafile (file#);

 

3. alter database datafile '/oracle/data02.dbf' online;


 
SQL: SQL Server 2012 High Availability Functions PDF Print E-mail
Written by Wira Chinwong   
Tuesday, 12 November 2013 22:57

AlwaysOn Failover Clustering
Microsoft’s premier high-availability technology, AlwaysOn Failover Clustering, is designed to reduce unplanned downtime by allowing clustered services such as SQL Server to automatically fail over to a backup node when a hardware or software failure makes the primary node unavailable. The SQL Server 2012 Business Intelligence and Standard editions are limited to two node failover clusters. SQL Server 2012 Enterprise edition can have up to 16 node clusters on Windows Server 2008 R2 and up to 64 onWindows Server 2012.

AlwaysOn Availability Groups
A new option for SQL Server 2012, AlwaysOn Availability Groups is essentially the next evolution of database mirroring. Designed to protect against unplanned and planned downtime, AlwaysOn Availability Groups can replicate multiple databases to as many as four replica systems with a mix of both synchronous and asynchronous replication of the transaction log. It fully supports automatic failover. AlwaysOn Availability Groups are found only in the SQL Server 2012 Enterprise edition.

Database Mirroring
Although I expect it will be eventually replaced by AlwaysOn Availability Groups, database mirroring is still available in SQL Server 2012. Database mirroring is limited to two systems: a principal and a mirror, with an optional witness that enables automatic failover. Database mirroring works by forwarding transaction log entries from a principal to a mirrored database, and it can be set up either synchronously for high availability or asynchronously across a WAN for disaster recovery. The SQL Server 2012 Business Intelligence and Standard editions can operate only in the synchronous full safety mode.

Log Shipping
Designed to protect against disasters at the system and site levels, log shipping works by periodically running a stored procedure that forwards transaction log entries to one or more destination systems Unlike database mirroring, which works in real time and is capable of automatic failover, log shipping requires manual failover and failback processes. Log shipping is supported by all SQL Server 2012 editions.

Database Snapshots
Database Snapshots are a point-in-time metadata-based copy of a given database, and they can be used for reporting purposes or to restore a database to previous state. For instance, database snapshots could be an effective protection against data corruption caused by user error. Database snapshots are supported only in the SQL Server 2012 Enterprise edition.

Fast Recovery
Fast recovery helps a database to be available more quickly following a restore operation. With Fast Recovery, the database is available as soon as the committed transactions are reapplied following a restore operation, with no need to wait for the uncommitted transactions to be rolled back. Like many of the other high availability options, Fast Recovery is available only in the SQL Server 2012 Enterprise edition.

Live Migration
While not technically a part of SQL Server 2012, Live Migration is a Windows Server technology that can help reduce planned downtime for virtualized SQL Server systems by allowing the SQL Server virtual machines (VMs) to be moved to a different host, with no end-user downtime. This enables maintenance to be performed on the virtualization host. All editions of SQL Server 2012 support live migration.

SQL Server on Server Core
Again, while not strictly a high-availability technology, SQL Server 2012’s support for running on Server Core can also boost SQL Server 2012’s availability by reducing the amount of patching that’s required by the host Windows Server OS. All editions of SQL Server 2012 support running on Windows Server Core.

 
TSM: ตัวอย่าง E-mail alert sending setup PDF Print E-mail
Written by Administrator   
Wednesday, 27 November 2013 00:31
ใน TSM 6.3 มี feature add เพิ่มเกี่่ยวกับ mail alert 
set alertmonitor on
set alertemail on
set alertemailsmtphost tsm.scsi.co.th
set alertemailsmtpport 25
set alertemailfromaddr 
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it
 
update admin myadmin alert=yes emailaddress=
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it
 
update admin djadmin alert=yes emailaddress=
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it
 
update admin csadmin alert=yes emailaddress=
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it
 
define alerttrigger anr0175e admin=myadmin,djadmin,csdadmin
Last Updated on Wednesday, 27 November 2013 00:37
 
VMware: vCenter appliance limitation PDF Print E-mail
Written by Administrator   
Wednesday, 18 July 2012 23:42

The vCenter Server Appliance has the following limitations:-

  • No Update Manager
  • No Linked-Mode
  • No support for the VSA (vSphere Storage Appliance)
  • Only support for Oracle as the external database
  • Embedded database, DB2, only supports 5 hosts and 50 VMs
  • No support for vCenter Heartbeat

 
<< Start < Prev 1 2 3 4 5 6 Next > End >>

Page 1 of 6

Polls

คุณใช้ Software Backup อะไรในองค์กร