Wish you a Happy New Year 2014

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>

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>

Welcome Back

Busy one year spent on work, decided to work on my blog ....................
soon newlearning will be posted :)

HP Data Protector ERRORS and Solutions

. HP Data Protector 6.11 Errors & Solutions . . [61:12500] Cannot connect to inet for getting filesystem list on host"clientname.abc.com". . Check for the service on the host. Cannot connect to inet simply indicates that CRS unable to reach client it may be down / service may down/ or firwall stopping the port . . [61:4001] Error accessing the database, in line 1410, file u:\src\sm\bsm2\bcsmutil.c. Database subsystem reports: "[12:1165] Internal Database network communication error." Database subsystem reports: "[12:1165] Internal Database network communication error." . . . Internal error. End medium failed. The Media Management daemon reports: "[12:1165] Internal Database network communication error." . . . This Happens When ever server rebooted unexpectly (while backup is running) . Restart the Cell Manager services.

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'

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.

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 .

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.

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 :(