Friday, August 26, 2016
Sunday, May 31, 2015
Veeam Backup Replication Setup
As we know Veeam Trending two words enterprise backup tool for VM infra.
If you are planning a dedicated service account that should be in Local Administrator group of Veeam Backup server.
You can't install Veeam on A domain controller and any other co existing application which uses SQL and IIS.
If you want integrate vCenter , you must have vCenter Login Credentials to Add the vCenter to Veeam Backup server.
Going forward couple of posts will be posted on this tool
I have created a LAB with ESXi host and couple of other servers on my new LAB..
Enjoy. ...
Primary installation :
By registering you business mail id at Veeam you can download temporary licence of Veeam products for 30 Days.
If you are planning a dedicated service account that should be in Local Administrator group of Veeam Backup server.
You can't install Veeam on A domain controller and any other co existing application which uses SQL and IIS.
If you want integrate vCenter , you must have vCenter Login Credentials to Add the vCenter to Veeam Backup server.
if you want recover Host backup at file system level , you must have host login or host domain account login details.
Hope this help............:)
Thursday, October 23, 2014
Wednesday, October 22, 2014
Wednesday, January 1, 2014
Saturday, September 7, 2013
Database Backups Oracle Recovery through RMAN --------------------DB Backups Part 2
Here is the recovery from RMAN Side. it is as simple as from RMAN side now the big deal how we are going to work with this tool using backup software's, as we all know any integrated backup works through a API to backup in a flexible method.
So when ever we are going deal with any Specific backup we need to know few use full parameters like control file, catalogue, sfile, restore , recover, database, mount, open ,sysadm, etc, etc.
C:\Documents and Settings\Administrator>rman target sys/XXX@dporacle nocatalog
Recovery Manager: Release 8.1.5.0.0 - Production
RMAN-06005: connected to target database: DPORACLE (DBID=2406364181)
RMAN-06009: using target database controlfile instead of recovery catalog
RMAN> run {
2> allocate channel t1 type disk;
3> RESTORE DATABASE;
4> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=11 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel t1: starting datafile backupset restore
RMAN-08502: set_count=1 set_stamp=825458721 creation_time=06-SEP-13
RMAN-08089: channel t1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to F:\ORACLE\ORADATA\DPORACLE\SYSTEM01.DBF
RMAN-08523: restoring datafile 00002 to F:\ORACLE\ORADATA\DPORACLE\USERS01.DBF
RMAN-08523: restoring datafile 00003 to F:\ORACLE\ORADATA\DPORACLE\RBS01.DBF
RMAN-08523: restoring datafile 00004 to F:\ORACLE\ORADATA\DPORACLE\TEMP01.DBF
RMAN-08523: restoring datafile 00005 to F:\ORACLE\ORADATA\DPORACLE\OEMREP01.DBF
RMAN-08523: restoring datafile 00006 to F:\ORACLE\ORADATA\DPORACLE\INDX01.DBF
RMAN-08023: channel t1: restored backup piece 1
RMAN-08511: piece handle=F:\BACKUP\DPORACLE_T825458721_S1_P1 params=NULL
RMAN-08024: channel t1: restore complete
RMAN-08031: released channel: t1
RMAN> run {
2> RECOVER DATABASE;
3> }
RMAN-03022: compiling command: recover
RMAN-03022: compiling command: recover(1)
RMAN-03022: compiling command: recover(2)
RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery
RMAN-08055: media recovery complete
RMAN-03022: compiling command: recover(4)
RMAN> ALTER DATABASE OPEN;
RMAN-06400: database opened
RMAN>
So when ever we are going deal with any Specific backup we need to know few use full parameters like control file, catalogue, sfile, restore , recover, database, mount, open ,sysadm, etc, etc.
C:\Documents and Settings\Administrator>rman target sys/XXX@dporacle nocatalog
Recovery Manager: Release 8.1.5.0.0 - Production
RMAN-06005: connected to target database: DPORACLE (DBID=2406364181)
RMAN-06009: using target database controlfile instead of recovery catalog
RMAN> run {
2> allocate channel t1 type disk;
3> RESTORE DATABASE;
4> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=11 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel t1: starting datafile backupset restore
RMAN-08502: set_count=1 set_stamp=825458721 creation_time=06-SEP-13
RMAN-08089: channel t1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to F:\ORACLE\ORADATA\DPORACLE\SYSTEM01.DBF
RMAN-08523: restoring datafile 00002 to F:\ORACLE\ORADATA\DPORACLE\USERS01.DBF
RMAN-08523: restoring datafile 00003 to F:\ORACLE\ORADATA\DPORACLE\RBS01.DBF
RMAN-08523: restoring datafile 00004 to F:\ORACLE\ORADATA\DPORACLE\TEMP01.DBF
RMAN-08523: restoring datafile 00005 to F:\ORACLE\ORADATA\DPORACLE\OEMREP01.DBF
RMAN-08523: restoring datafile 00006 to F:\ORACLE\ORADATA\DPORACLE\INDX01.DBF
RMAN-08023: channel t1: restored backup piece 1
RMAN-08511: piece handle=F:\BACKUP\DPORACLE_T825458721_S1_P1 params=NULL
RMAN-08024: channel t1: restore complete
RMAN-08031: released channel: t1
RMAN> run {
2> RECOVER DATABASE;
3> }
RMAN-03022: compiling command: recover
RMAN-03022: compiling command: recover(1)
RMAN-03022: compiling command: recover(2)
RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery
RMAN-08055: media recovery complete
RMAN-03022: compiling command: recover(4)
RMAN> ALTER DATABASE OPEN;
RMAN-06400: database opened
RMAN>
Sunday, September 1, 2013
Database Backups Series - Part 1
Most challenging area for any backup tool administrator is Database backups.
Here we are going to discuss most of the database backups like oracle, sql,db2,sap,exchange starting with oracle I am going to post my understandings on DB backups .
Example of simple rman cold backup in oracle DB:
SQL> CONNECT sys AS SYSDBA
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 1.007E+09 bytes
Fixed Size 65484 bytes
Variable Size 86917120 bytes
Database Buffers 919568384 bytes
Redo Buffers 73728 bytes
Database mounted.
SQL>
C:\Documents and Settings\Administrator>rman target sys/xxxxx@dporacle nocatalo
g
Recovery Manager: Release 8.1.5.0.0 - Production
RMAN-06005: connected to target database: DPORACLE (DBID=2406364181)
RMAN-06009: using target database controlfile instead of recovery catalog
RMAN> run {
2> allocate channel t1 type disk;
3> backup
4> format '%d_t%t_s%s_p%p'
5> (database);
6> release channel t1;
7> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=12 devtype=DISK
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting full datafile backupset
RMAN-08502: set_count=2 set_stamp=824918367 creation_time=31-AUG-13
RMAN-08010: channel t1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00001 name=F:\ORACLE\ORADATA\DPORACLE\SYSTEM01.DB
F
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00003 name=F:\ORACLE\ORADATA\DPORACLE\RBS01.DBF
RMAN-08522: input datafile fno=00005 name=F:\ORACLE\ORADATA\DPORACLE\OEMREP01.DB
F
RMAN-08522: input datafile fno=00002 name=F:\ORACLE\ORADATA\DPORACLE\USERS01.DBF
RMAN-08522: input datafile fno=00004 name=F:\ORACLE\ORADATA\DPORACLE\TEMP01.DBF
RMAN-08522: input datafile fno=00006 name=F:\ORACLE\ORADATA\DPORACLE\INDX01.DBF
RMAN-08013: channel t1: piece 1 created
RMAN-08503: piece handle=DPORACLE_T824918367_S2_P1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:01:10
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1
RMAN> list backup;
RMAN-03022: compiling command: list
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
1 1 824918432 0 824918367 2 31-AUG-13
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ---------------------- ------------------------
1 1 1 AVAILABLE 31-AUG-13 DPORACLE_T824918367_S2_P1
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ---------- -------------
1 F:\ORACLE\ORADATA\DPORACLE\SYSTEM01.DBF 0 Full 138066 31-AUG-13
2 F:\ORACLE\ORADATA\DPORACLE\USERS01.DBF 0 Full 138066 31-AUG-13
3 F:\ORACLE\ORADATA\DPORACLE\RBS01.DBF 0 Full 138066 31-AUG-13
4 F:\ORACLE\ORADATA\DPORACLE\TEMP01.DBF 0 Full 138066 31-AUG-13
5 F:\ORACLE\ORADATA\DPORACLE\OEMREP01.DBF 0 Full 138066 31-AUG-13
6 F:\ORACLE\ORADATA\DPORACLE\INDX01.DBF 0 Full 138066 31-AUG-13
RMAN>
Here we are going to discuss most of the database backups like oracle, sql,db2,sap,exchange starting with oracle I am going to post my understandings on DB backups .
Example of simple rman cold backup in oracle DB:
SQL> CONNECT sys AS SYSDBA
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 1.007E+09 bytes
Fixed Size 65484 bytes
Variable Size 86917120 bytes
Database Buffers 919568384 bytes
Redo Buffers 73728 bytes
Database mounted.
SQL>
C:\Documents and Settings\Administrator>rman target sys/xxxxx@dporacle nocatalo
g
Recovery Manager: Release 8.1.5.0.0 - Production
RMAN-06005: connected to target database: DPORACLE (DBID=2406364181)
RMAN-06009: using target database controlfile instead of recovery catalog
RMAN> run {
2> allocate channel t1 type disk;
3> backup
4> format '%d_t%t_s%s_p%p'
5> (database);
6> release channel t1;
7> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=12 devtype=DISK
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting full datafile backupset
RMAN-08502: set_count=2 set_stamp=824918367 creation_time=31-AUG-13
RMAN-08010: channel t1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00001 name=F:\ORACLE\ORADATA\DPORACLE\SYSTEM01.DB
F
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00003 name=F:\ORACLE\ORADATA\DPORACLE\RBS01.DBF
RMAN-08522: input datafile fno=00005 name=F:\ORACLE\ORADATA\DPORACLE\OEMREP01.DB
F
RMAN-08522: input datafile fno=00002 name=F:\ORACLE\ORADATA\DPORACLE\USERS01.DBF
RMAN-08522: input datafile fno=00004 name=F:\ORACLE\ORADATA\DPORACLE\TEMP01.DBF
RMAN-08522: input datafile fno=00006 name=F:\ORACLE\ORADATA\DPORACLE\INDX01.DBF
RMAN-08013: channel t1: piece 1 created
RMAN-08503: piece handle=DPORACLE_T824918367_S2_P1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:01:10
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1
RMAN> list backup;
RMAN-03022: compiling command: list
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
1 1 824918432 0 824918367 2 31-AUG-13
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ---------------------- ------------------------
1 1 1 AVAILABLE 31-AUG-13 DPORACLE_T824918367_S2_P1
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ---------- -------------
1 F:\ORACLE\ORADATA\DPORACLE\SYSTEM01.DBF 0 Full 138066 31-AUG-13
2 F:\ORACLE\ORADATA\DPORACLE\USERS01.DBF 0 Full 138066 31-AUG-13
3 F:\ORACLE\ORADATA\DPORACLE\RBS01.DBF 0 Full 138066 31-AUG-13
4 F:\ORACLE\ORADATA\DPORACLE\TEMP01.DBF 0 Full 138066 31-AUG-13
5 F:\ORACLE\ORADATA\DPORACLE\OEMREP01.DBF 0 Full 138066 31-AUG-13
6 F:\ORACLE\ORADATA\DPORACLE\INDX01.DBF 0 Full 138066 31-AUG-13
RMAN>
Saturday, June 2, 2012
Welcome Back
Busy one year spent on work, decided to work on my blog ....................
soon newlearning will be posted :)
soon newlearning will be posted :)
Sunday, May 29, 2011
HP Data Protector ERRORS and Solutions
Saturday, May 28, 2011
Emc Legato networker MMINFO usefull TIPS
Here some of use full combinations of mminfo
Generally mminfo resides in /usr/sbin in unix, c:\programfiles\legato\nsr\bin in windows .
To query a client backup info for past 120 Hours:
/usr/sbin/mminfo -avot -c axx.domain.com -t "-120 hours"
some times we can use grep effectively with networker command :
for example above command we can use in alternative way:
/usr/sbin/mminfo -avot -t "-120 hours" | grep -i axx.domain.com
To Query a client backup info with ssid , size of saveset, tape info
mminfo -q "client= axx.domain.com" -r "ssid,name,totalsize,savetime,volume" -t '60 hours ago'
Generally mminfo resides in /usr/sbin in unix, c:\programfiles\legato\nsr\bin in windows .
To query a client backup info for past 120 Hours:
/usr/sbin/mminfo -avot -c axx.domain.com -t "-120 hours"
some times we can use grep effectively with networker command :
for example above command we can use in alternative way:
/usr/sbin/mminfo -avot -t "-120 hours" | grep -i axx.domain.com
To Query a client backup info with ssid , size of saveset, tape info
mminfo -q "client= axx.domain.com" -r "ssid,name,totalsize,savetime,volume" -t '60 hours ago'
Basic Trouble shooting in EMC Legato Networker
If a client backup failed in EMC legato networker these setups helps you.
# /usr/sbin/ping xxx.abc.com
xxx.abc.com is alive
It is confirms that client is ping able so we can move for second step.
# /usr/bin/rpcinfo -p xxx.abc.com
program vers proto port service
100000 2 tcp 7938 rpcbind
100000 2 udp 7938 rpcbind
390436 1 tcp 9101
390435 1 tcp 8920
390113 1 tcp 7937 nsrexec
By this out put it is confirm that nsrexec running on client.
# /usr/sbin/nsradmin -s xxx.abc.com -p 390113
nsradmin> print nsrla
type: NSRLA;
name: xxx.abc.com;
NW instance info operations: ;
NW instance info file: ;
installed products: NetWorker 7.4.3.Build.569;
version: "EMC NetWorker 7.4.3.Build.569 ";
servers: backup.abc.com;
auth methods: "0.0.0.0/0,nsrauth/oldauth";
administrator: No privilege to view administrator list;
kernel arch: AMD_X8664;
machine type: server;
OS: Windows Server 2003 5.2;
NetWorker version: 7.4.3.Build.569;
client OS type: Windows NT Server on Intel;
CPUs: 8;
MB used: 23525;
IP address: 10.206.1.24, 192.168.41.12;
Above out put may gives the clue about the ip interface and client version which helps you out in trouble shooting.
# /usr/sbin/ping xxx.abc.com
xxx.abc.com is alive
It is confirms that client is ping able so we can move for second step.
# /usr/bin/rpcinfo -p xxx.abc.com
program vers proto port service
100000 2 tcp 7938 rpcbind
100000 2 udp 7938 rpcbind
390436 1 tcp 9101
390435 1 tcp 8920
390113 1 tcp 7937 nsrexec
By this out put it is confirm that nsrexec running on client.
# /usr/sbin/nsradmin -s xxx.abc.com -p 390113
nsradmin> print nsrla
type: NSRLA;
name: xxx.abc.com;
NW instance info operations: ;
NW instance info file: ;
installed products: NetWorker 7.4.3.Build.569;
version: "EMC NetWorker 7.4.3.Build.569 ";
servers: backup.abc.com;
auth methods: "0.0.0.0/0,nsrauth/oldauth";
administrator: No privilege to view administrator list;
kernel arch: AMD_X8664;
machine type: server;
OS: Windows Server 2003 5.2;
NetWorker version: 7.4.3.Build.569;
client OS type: Windows NT Server on Intel;
CPUs: 8;
MB used: 23525;
IP address: 10.206.1.24, 192.168.41.12;
Above out put may gives the clue about the ip interface and client version which helps you out in trouble shooting.
HP Data Protector CRS Service Errors.
Can not start "crs" service, system error: [1053] 1053 Unknown Error Can not start "uiproxy" service, system error: [1053] 1053 Unknown Error.
Above error happens in Linux , if you miss glib packages. it is known issue with Data protector.
Crs account may not started due to one more reason:
If installation user account password changed it will not start .
Above error happens in Linux , if you miss glib packages. it is known issue with Data protector.
Crs account may not started due to one more reason:
If installation user account password changed it will not start .
Friday, February 18, 2011
PUBLIC & PRIVATE option in backup sepecfication.
If you want to give restore permission other than backup owner or owner group or any user.
we must select PUBLIC option in bakcup specification, this allows permitter user /admin group member to restore backup data.
we must select PUBLIC option in bakcup specification, this allows permitter user /admin group member to restore backup data.
Saturday, February 12, 2011
HP Data Protector CRS Cell Request Service How it works
Hi
Who is the owner of backup ?
CRS (Cell Request Service ) is the owner for all backups in HP data protector. because CRS is the intiator for all backup specifications (Except Some of BAR applications )
Why we add DBA system user in backup admin group ?
Bacause this account acts as CRS for this accounts.
What happens if CRS account is changed and it is not update in Data protector user list ?
No backu will initiated :(
Who is the owner of backup ?
CRS (Cell Request Service ) is the owner for all backups in HP data protector. because CRS is the intiator for all backup specifications (Except Some of BAR applications )
Why we add DBA system user in backup admin group ?
Bacause this account acts as CRS for this accounts.
What happens if CRS account is changed and it is not update in Data protector user list ?
No backu will initiated :(
Monday, January 3, 2011
Wish You a Happy New Year
SHARE YOUR KNOWLEDGE.....................................
Please send me an email who want share some knowledge on my blog. i will add them as my team so you can directly write the post on my blog.
Please send me an email who want share some knowledge on my blog. i will add them as my team so you can directly write the post on my blog.
Saturday, December 18, 2010
HP Data protector tape library installation
Data Protector tape library installation.
Thanks to author.
Friday, December 17, 2010
Tech Videos On Data Protector
Hi All,
Installation and Setup of Basic Data Protector. and some more interesting topics will be posted as Video.
Wednesday, December 15, 2010
How to install a linux / Unix Disk Agent (Data Protector)
One of the good post observed in this blog:
Wednesday, December 1, 2010
Omnimm Ejecting tapes from Command prompt
I Prefer to eject tapes from command prompt than Command View .
General Syntax :
omnimm -eject LibraryName {Slot | FromSlot-ToSlot} [-location Location]
Command Usage :
omnimm -eject "MYLIB" 4
omnimm eject "MYLIB" 4 5 6 7 22 (to eject slot no 4 ,5,6,7 and 22 Tapes).
Other Usefull Commands:
uma -ioctl to scan and know mail slot status.
TIP : Make sure tape library in idle position while ejecting.
Tuesday, November 30, 2010
HP Data Protector IDB purge using OMNIDBUTIL - PURGE Part 2
hp data protector idb purge
General Syntax :
omnidbutil -purge {-filenames [host_1 [host_n...]] [-force] | -sessions
[NumberOfDays] | -days [NumberOfDays] | -messages [NumberOf-Days] | -dcbf | -mpos | -daily}
omnidbutil -purge_failed_copies
omnidbutil -purge_stop
Related Error Messages:
[12:10907] Invalid format of detail catalog binary file.
61:4039] Following error occurred while storing detail catalog
information for device "XXXX_D01"
with loaded medium "abcdef:abcdef:adbcdef:abcedef: KKKLT04"
to Data Protector Internal Database:
There is no more space available in any of the Detail Catalog directories.
From this point on, all objects on this medium
will have logging switched to "No Log".
Command Usage :
omnidbutil -purge -filenames aa.bb.com -force
Other Usefull Commands:
omnirpt -report db_size : Helps in knowing IDB Size
TIP : Services need to up and make sure that no session is running @ PURGING.
We can work around the IDB syncranation that depends how your IDB effected.
if it is filenames we can purge expired filenames by omnidubtil -purge -filenames -force.
if you want purge a specified server filenames please see the command usage example.
Subscribe to:
Posts (Atom)































