RMAN Interview Questions

Configure encryption for database on
Configure encryption algorithm 'AES256'

RMAN offers three encryption modes: transparent mode, password mode, and dual mode

Yes, you can perform backup of catalog database using RMAN with below steps:1. Start the RMAN with NOCATALOG option.2. Run the recovery catalog database in ARCHIVELOG mode.3. set the retention policy ...

RMAN Target / run{Allocate channel ch1 device type sbt_tape maxpiecesize 4gFormat'%D_%U_%T_%t';sql 'alter system switch logfile';Backup database;backup archivelog from time 'sysdate-7';Backup Format '...

HI,    I can expalin what are all the steps to take a rman backup with TSM tape library as follows1.Install TDPO (default path /usr/tivoli/tsm/client/oracle/)2.Once u installed the TDPO,auto...

How RMAN works with TAPE with TSM ?

Two commands available in RMAN to clone database:

 1) Duplicate

 2) Restore.

Check whether backup pieces, proxy copies, or disk copies still exist.

RC_DATABASE_INCARNATION,RC_BACKUP_COPY_DETAILS,RC_BACKUP_CORRUPTION,
RC_BACKUP-DATAFILE_SUMMARY to name a few

using RMAN BLOCK RECOVER command

RAID: It is a redundant array of independent disk
RAID0: Concatenation and stripping
RAID1: Mirroring

Cold backup: shutdown the database and copy the datafiles with the help of O.S. command. this is simply copying of datafiles just like any other text file copy. Holt backup: backup process start...

I Believe in designing a good backup strategy it will not only be simply backup but also a contingency plan. In this case you should consider the following:1. How long is the allowable down time durin...

You have to catalog that manual backup in RMAN's repository by command
RMAN> catalog datafilecopy '/DB01/BACKUP/users01.dbf';

restrictions:
> Accessible on disk
> A complete image copy of a single file

First check whether the block is corrupted or not by using this commandsql>select file#, block#  from v$database_block_corruption; file#  block  2        507the above block is corrupted.....

using v$block_corruption view u can find which blocks corrupted.

Rman>> block recover datafile block ;

Using the above statement u recover the corrupted blocks.

Thanks & Regards,
Kishore.