Explore topic-wise InterviewSolutions in .

yes

yes

EXPORT and import COMMAND ROUTING and Enterprise management.

Export and import Command Routing and Enterprise management.

AUDIT VOL volname preview=no

RESTORE vol volnme preview=yes

Restore vol volname copystg=copystgname

Audit vol volname preview=no

Restore vol volnme preview=yes

Restore vol volname copystg=copystgname

There is no chance of RESTORING single FILE in image BACKUP. We have RESTORE entire image.

There is no chance of restoring single file in image backup. We have restore entire image.

by installing this SOFTWARE we can take MODIFIED FILES and directory which are stored in that FOLDER.

by installing this software we can take modified files and directory which are stored in that folder.

Server will initiate the schedule PROCESS by CONTACTING the CLIENT.

Server will initiate the schedule process by contacting the client.

After DELETING the FILES from the tapes how many DAYS it should wait before returning to the scratch.Copy STORAGE pools.

After deleting the files from the tapes how many days it should wait before returning to the scratch.Copy storage pools.

RESTORATION is QUICKER for the CLIENT.

Restoration is quicker for the client.

To INCREASE the VOLUMES for the STORAGE POOLS.

To increase the volumes for the storage pools.

DEPEND on CLIENT REQUIREMENTS.

Depend on client requirements.

After running EXPIRATION, expired files are DELETED from the database and by running RECLAMATION moves fragmented data from ONE or more vols to FILLING or new volumes.

After running Expiration, expired files are deleted from the database and by running reclamation moves fragmented data from one or more vols to filling or new volumes.

For SCSI libraries:

The SERVER issues a request to have the VOLUME inserted into a cartridge slot in the library or, if available, into an entry PORT. The cartridge slot or entry port is identified by its element address. For 349X libraries: The volume could already be in the library, or you could PUT it into the I/O station when prompted.

Yes- Specifies that the server searches the library for volumes to be checked in

Bulk -Specifies that the server searches the library's entry/exit PORTS for volumes that can be checked in automatically. This option only applies to SCSI libraries.

For SCSI libraries:

The server issues a request to have the volume inserted into a cartridge slot in the library or, if available, into an entry port. The cartridge slot or entry port is identified by its element address. For 349X libraries: The volume could already be in the library, or you could put it into the I/O station when prompted.

Yes- Specifies that the server searches the library for volumes to be checked in

Bulk -Specifies that the server searches the library's entry/exit ports for volumes that can be checked in automatically. This option only applies to SCSI libraries.

No

No

CHECKIN libvolume Libraryname volname status=CLEANER cleanings=10/only for SCSI LIBR checklabel=no/for cleaner it SHUD be no

checkin libvolume Libraryname volname status=cleaner cleanings=10/only for scsi libr checklabel=no/for cleaner it shud be no

CHECKOUT the tape, POWER cycling the DRIVE, RAISE the ticket to Hardware team.

Checkout the tape, power cycling the drive, raise the ticket to Hardware team.

update path servername DRIVE name src=server dest=drive libr=libname device=device name ONLINE =yes update path servername librname src=server dest=libray device=device name online =yes

Found all the drives are taking 30mins time to DISMOUNT volume from Drive after the backup/restore/migration/reclamation or any process;

update path servername drive name src=server dest=drive libr=libname device=device name online =yes update path servername librname src=server dest=libray device=device name online =yes

Found all the drives are taking 30mins time to dismount volume from Drive after the backup/restore/migration/reclamation or any process;

SELECT COUNT(*) from libvol where status=scratch

select count(*) from libvol where status=scratch

tdpsql.cfg, dms.sys/domdsm.cfg,dsm.sys/tdpexc.cfg,dsm.sys

tdpsql.cfg, dms.sys/domdsm.cfg,dsm.sys/tdpexc.cfg,dsm.sys

devconfig.out, volh.out dsmserv.disk, dsmserv.opt

devconfig.out, volh.out dsmserv.disk, dsmserv.opt

mutable/not mountable/courier/vault/vault RETRIEVE/courier retrieve/onsite retrieve//// MOVE MEDIA volname were state=x to state=x 

mutable/not mountable/courier/vault/vault retrieve/courier retrieve/onsite retrieve//// move media volname were state=x to state=x 

you must recreate it before you can start the restore operation. The device configuration FILE must follow these CONVENTIONS:

The COMMANDS must be in this ORDER:

•  DEFINE SERVER (if you are using virtual VOLUMES)
•  DEFINE DEVCLASS
•  DEFINE LIBRARY
•  DEFINE EXIT
•  DEFINE DRIVE "

you must recreate it before you can start the restore operation. The device configuration file must follow these conventions:

The commands must be in this order:

dsmserv RESTORE DB

dsmserv restore db

DSMFMT CREATE volumes in console/ dsmserv FORMAT means intializes the SERVER DATABASE and log, dsmfmt create volumes in console.

dsmfmt create volumes in console/ dsmserv format means intializes the server database and log, dsmfmt create volumes in console.

2typess VB and AWK.

2typess vb and awk.

by running this script command:pathcscript planexpl.vbs PATH of the PLAN file

by running this script command:pathcscript planexpl.vbs path of the plan file

lanfreetcpport, lanfreetcpserveradress, enablelanfree YES, tcpport,tcpsereraddress,SERVERNAME, commmethod tcpip, lanfreecommmethod tcpip

lanfreetcpport, lanfreetcpserveradress, enablelanfree yes, tcpport,tcpsereraddress,servername, commmethod tcpip, lanfreecommmethod tcpip

update the drive to ONLINE and if STILL it is not online delete the PATH and againdef the \path delete the paths using rmdev and re-run CFGMGR and try to make them online by using defining drive path command again

update the drive to online and if still it is not online delete the path and againdef the \path delete the paths using rmdev and re-run cfgmgr and try to make them online by using defining drive path command again

BRINGING define STATE to available state

if any hardware is connected to the SERVER and is not detected ,then run CFGMGR

bringing define state to available state

if any hardware is connected to the server and is not detected ,then run cfgmgr

DEF server storage angent NAME server PASSWORD= PASSWD hla=xx lla=xx

def server storage angent name server password= passwd hla=xx lla=xx

Whether the file exist on the node will AFFECT which RULES are used to expire the file copies if the FILES exists.

VEREX: specifies number of file copies or versions to keep. Includes inactive and active files.

VERDEL: specifies number of versions to maintain after files have been deleted from client system

RETEX: specifies the no of days to keep inactive file versions . RETON: Specifies the number of days to RETAIN the last backup version of a file that has been deleted from the client file system.

Serialization: specifies how tsm handles the client data that to be backed up

Whether the file exist on the node will affect which rules are used to expire the file copies if the files exists.

VEREX: specifies number of file copies or versions to keep. Includes inactive and active files.

VERDEL: specifies number of versions to maintain after files have been deleted from client system

RETEX: specifies the no of days to keep inactive file versions . RETON: Specifies the number of days to retain the last backup version of a file that has been deleted from the client file system.

Serialization: specifies how tsm handles the client data that to be backed up

Use the tdposync utility to delete the Oracle backups on the TIVOLI Storage MANAGER server which are not in the RMAN catalog. By thus removing unwanted objects in Tivoli Storage Manager storage, you can reclaim space on the server. This utility ALLOWS you to REPAIR such discrepancies between the Tivoli Storage Manager Server and the RMAN catalog.

Use the tdposync utility to delete the Oracle backups on the Tivoli Storage Manager server which are not in the RMAN catalog. By thus removing unwanted objects in Tivoli Storage Manager storage, you can reclaim space on the server. This utility allows you to repair such discrepancies between the Tivoli Storage Manager Server and the RMAN catalog.

DEVICE TYPE

device type

tdpoconf.cfg, dsm.opt, dsm.sys

tdpoconf.cfg, dsm.opt, dsm.sys

tdpoconf PASSWORD

tdpoconf password

Tdpoconf: The tdpoconf utility is used for password MAINTENANCE and general DATA Protection for Oracle setup and maintenance.

Tdposync: Use the tdposync utility to delete the Oracle backups on the Tivoli Storage Manager server which are not in the RMAN catalog. By THUS removing unwanted objects in Tivoli Storage Manager storage, you can reclaim space on the server. This utility ALLOWS you to repair such discrepancies between the Tivoli Storage Manager Server and the RMAN catalog.

Tdpoconf: The tdpoconf utility is used for password maintenance and general Data Protection for Oracle setup and maintenance.

Tdposync: Use the tdposync utility to delete the Oracle backups on the Tivoli Storage Manager server which are not in the RMAN catalog. By thus removing unwanted objects in Tivoli Storage Manager storage, you can reclaim space on the server. This utility allows you to repair such discrepancies between the Tivoli Storage Manager Server and the RMAN catalog.

if the data to be transferred more than 150GB than 

LAN free backup steps:-

Install TSM SEVER in SAN environment with LIBRARY

CONFIGURE library in SHARED mode (def lib shared=yes)

We have to install storage agent software in Client machine .then we act as a server

Then we have to register the storage agent as server in TSM server

Def server storage agent server serverpassword= ** hla= IP address lla= port no.,

Configuration files:- DSMSTOPT , DSMCONFIG.OUT, DSM.SYS/OPT we use in lanfree backup.

if the data to be transferred more than 150GB than 

LAN free backup steps:-

Install TSM sever in SAN environment with library

Configure library in shared mode (def lib shared=yes)

We have to install storage agent software in Client machine .then we act as a server

Then we have to register the storage agent as server in TSM server

Def server storage agent server serverpassword= ** hla= IP address lla= port no.,

Configuration files:- DSMSTOPT , DSMCONFIG.OUT, DSM.SYS/OPT we use in lanfree backup.

MOVE drmedia medianame where state=courier tostate=vault

Move drmedia medianame where state=courier tostate=vault

DRM (Disaster Recovery Manager) if any thing happen TSM server then we need to RESTORE the TSM server for that PURPOSE we need to use

DRM DAILY OPERATION:-

Backup of the primary storage pool to COPY storage pool

Backup the TSM DATA base

Move DR Media status

Run the prepare command

TRANSPORT the DR media offsite

Return empty media from offsite

DRM life cycle:-

Mountable:- it is valid data

Non mountable:- it is valid data can’t be access

Courier:- ready to transfer

Vault: - it is offsite

Retrieve vault:-return to offsite to onsite

Courier retrieve:- transfer from onsite

Onsite retrieve:- it is in onsite

DRM (Disaster Recovery Manager) if any thing happen TSM server then we need to restore the TSM server for that purpose we need to use

DRM DAILY OPERATION:-

Backup of the primary storage pool to copy storage pool

Backup the TSM data base

Move DR Media status

Run the prepare command

Transport the DR media offsite

Return empty media from offsite

DRM life cycle:-

Mountable:- it is valid data

Non mountable:- it is valid data can’t be access

Courier:- ready to transfer

Vault: - it is offsite

Retrieve vault:-return to offsite to onsite

Courier retrieve:- transfer from onsite

Onsite retrieve:- it is in onsite

CHECKIN libvolume library_name volume_name search=no/yes/bulk status=private/scratch

CHECKOUT libvolume library_name volume_name remove=bulk/yes/no

checkin libvolume library_name volume_name search=no/yes/bulk status=private/scratch

Checkout libvolume library_name volume_name remove=bulk/yes/no

NO

NO

LOGICALLY SHARED

Logically shared

YES

DEFINE LIBRARY library_name library TYPE= manual/scsi/349x autolabel=yes/no shared=yes / no

YES

Define library library_name library type= manual/scsi/349x autolabel=yes/no shared=yes / no

LTO 3

SIZE: 400 GB, when compressed 800 GB

LTO 3

Size: 400 GB, when compressed 800 GB

6 DRIVES

6 DRIVES

3582 MODEL

3582 MODEL

DEFINE shed domainname shedname ACTION= COMMAND object=”C:\sqlfull.cmd” startday=” “ starttime=” “ duration=” “ durationunits=min

define shed domainname shedname action= command object=”c:\sqlfull.cmd” startday=” “ starttime=” “ duration=” “ durationunits=min

YES I KNOW about TDP SQL

Yes I know about TDP SQL

BACKUP DB devc=deviceclass type=full/incremental/snapshot.

Backup DB devc=deviceclass type=full/incremental/snapshot.

verexit, verdelete, retextra, retonly, retver.

verexit, verdelete, retextra, retonly, retver.

USING SELECT COMMANDS we can do

Using SELECT commands we can do