-
RMAN Encryption Option
List the encryption options available with RMAN?
pradipta182
- Sep 26th, 2008
RMAN offers three encryption modes: transparent mode, password mode, and dual mode
-
Is it possible to take Catalog Database Backup using RMAN?
msmanan
- Jun 19th, 2009
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 Tape Backups
How do you setup the RMAN tape backups?
shrikant2711
- Mar 20th, 2009
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 '...
-
RMAN with NetBackup, TSM Type Library
What are the steps required to perform in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software?
krishnaprasad.sola
- Feb 2nd, 2009
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...
-
Clone database using RMAN
How do you clone the database using RMAN software? Give brief steps? When do you use crosscheck command?
taya_ronak
- Dec 17th, 2008
Two commands available in RMAN to clone database:?1) Duplicate?2) Restore.
-
RMAN Catalog View
List some of the RMAN catalog view names which contains the catalog information ?
moulvi
- Dec 13th, 2008
RC_DATABASE_INCARNATION,RC_BACKUP_COPY_DETAILS,RC_BACKUP_CORRUPTION,RC_BACKUP-DATAFILE_SUMMARY to name a few
-
In catalog database, if some of the blocks are corrupted due to system crash, How will you recover?
-
RAID, RAID0, RAID1 and RAID10
What is RAID? What is RAID0? What is RAID1? What is RAID 10?
sasikumar12
- Dec 10th, 2008
RAID: It is a redundant array of independent diskRAID0: Concatenation and strippingRAID1: Mirroring
-
Backup Strategy
What are things which play major role in designing the backup strategy?
taya_ronak
- Dec 7th, 2008
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...
fbchua
- Oct 17th, 2008
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...
-
Manual Backup
You have taken a manual backup of a datafile using o/s. How RMAN will know about it?
tiwari.abhijeet
- Sep 8th, 2008
You have to catalog that manual backup in RMAN's repository by commandRMAN> catalog datafilecopy '/DB01/BACKUP/users01.dbf';restrictions:> Accessible on disk> A complete image copy of a single file
-
RMAN Block Corruption
How do you identify the block corruption in RMAN database? How do you fix it?
oracle56
- Aug 24th, 2008
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.....
kishoredba
- Jul 21st, 2008
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.
-
TIME based hot backup recovery
Outline the steps involved in TIME based recovery from the full database from hot backup?
RMAN Interview Questions
Ans