RMAN Questions And Answers

1⟩ How to setup the RMAN tape backups?

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 '%D_CTLFILE_P_%U_%T_%t' Current controlfile;release channel ch1;}This is backup script for Tivoli Backup Server

Is this answer helpful? 0 Yes | 0 No

Answer This Question

138 views

2⟩ How to clone the database using RMAN software? Give brief steps? When do you use crosscheck command?

Two commands available in RMAN to clone database: 1) Duplicate 2) Restore.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

180 views

3⟩ Tell me Is it possible to take Catalog Database Backup using RMAN?

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 to a REDUNDANCY value greater than 1.

4. Backup the database onto two separate media(disk and tape), You can use BACKUP COPIES 2.

5. Donot use another recovery catalog as the repository for these backups.

6. configure the controlfile autoback feature to ON.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

152 views

4⟩ What are the steps required to perform in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software?

To take a rman backup with TSM tape library as follows

1.Install TDPO (default path /usr/tivoli/tsm/client/oracle/)

2.Once u installed the TDPO,automatically one link is created from TDPO directory to /usr/lib. Now we need to Create soft link between OS to ORACLE_HOME ln -s /usr/lib/libiobk64. a $ORACLE_HOME/lib/libobk.a(very imporatant)

3.Uncomment and Modify tdpo.opt file which in /usr/tivoli/tsm/client/oracle/bin/tdpo.opt as followsDSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm.optDSMI_LOG /home/tmp/oracleTDPO_NODE backupTDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64

4.create dsm.sys file in same path and add the entriesSErvername TCPPort 1500 passwordacess prompt nodename backup enablelanfree yesTCPSERVERADDRESS

5.Create dsm.opt file add an entrySErvername 5. Then take backupRMAN>run { allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; backup database include current controlfile; release channel t1; }

Is this answer helpful? 0 Yes | 0 No

Answer This Question

160 views

5⟩ Tell us In catalog database, if some of the blocks are corrupted due to system crash, How will you recover?

Using RMAN BLOCK RECOVER command

Is this answer helpful? 0 Yes | 0 No

Answer This Question

184 views

6⟩ List some of the RMAN catalog view names which contains the catalog information?

RC_DATABASE_INCARNATION,

RC_BACKUP_COPY_DETAILS,

RC_BACKUP_CORRUPTION,

RC_BACKUP-DATAFILE_SUMMARY to name a few

Is this answer helpful? 0 Yes | 0 No

Answer This Question

154 views

7⟩ Explain the steps involved in TIME based recovery from the full database from hot backup?

Please share your answers.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

178 views

8⟩ Explain the encryption options available with RMAN?

RMAN offers three encryption modes:

transparent mode,

password mode,

and dual mode

Is this answer helpful? 0 Yes | 0 No

Answer This Question

151 views

9⟩ What are things which play major role in designing the backup strategy?

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 starts even though database in running. The

process to take a hot backup is

1) sql> alter database begin backup;

2) copy the datafiles.

3) after copying

sql> alter database end backup;

Begin backup clause will generate the timestamp. it'll be used in backup

consistency i.e. when begin backup pressed, it'll generate the timestamp. During

restore, database will restore the data from backup till that timestamp and

remaining backup will be recovered from archive log.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

133 views

10⟩ What is RAID? What is RAID0? What is RAID1? What is RAID 10?

RAID: It is a redundant array of independent disk

RAID0: Concatenation and stripping

RAID1: Mirroring

Is this answer helpful? 0 Yes | 0 No

Answer This Question

143 views

11⟩ How to identify the block corruption in RMAN database? How do you fix it?

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...conn to RmanTo recover the block use this command...Rman>blockrecover dataile 2 block 507;the above command recover the block 507Now, just verify it.....Rman>blockrecover corruption list;Thks..

Is this answer helpful? 0 Yes | 0 No

Answer This Question

154 views

12⟩ Suppose you have taken a manual backup of a datafile using o/s. How RMAN will know about it?

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

Is this answer helpful? 0 Yes | 0 No

Answer This Question

177 views

13⟩ Explain the steps involved in SCN based recovery from the full database from hot backup?

The steps are:

1) Shutdown the database

2) Restore data files

3) Mount the database

4) Recover the database

(sql> recover database until time 2005-12-14:12:10:03 Time base)

(sql> recover database until change scn base)

5) Open the database with the resetlogs option

(sql>atler database open resetlogs)

Is this answer helpful? 0 Yes | 0 No

Answer This Question

164 views

14⟩ What is the difference between physical and logical backups?

In Oracle Logical Backup is "which is taken using either Traditional Export/Import or Latest Data Pump". Where as Physical backup is known "when you take Physical O/s Database related Files as Backup".

Is this answer helpful? 0 Yes | 0 No

Answer This Question

161 views

15⟩ Tell me is it possible to specific tables when using RMAN DUPLICATE feature? If yes, how?

It is possible to use RMAN duplicate features to specific tables,with RMAN Duplicate we first create a target or duplicate single instance database and then convert the single instance database to a RAC database.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

166 views

16⟩ Explain the steps for changing the DBID in a cloned environment?

Note: Mount the databse $export ORACLE_SID=test$ nid target=system/managerIt will change and automaticaly generate new id and asign it to the database.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

135 views

17⟩ How RMAN improves backup time?

Oracle database help us to reduce time for taking backup using followings

1) Oracle performs BLOCKlevel backup.

2) DBA can allocate channels which will start the backup activity in PARALLEL, but we need to ensure that not too many channels have been allocated. Number of allocated channel should not be more than number of CPU.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

141 views

18⟩ What is the difference between obsolete RMAN backups and expired RMAN backups?

Obsolete: means the backup piece is still available,but it is no longer needed.It depends on retention policy,i,e.recovery window .

Expired: means the backup piece or backup set is not found in the backup destination.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

152 views

19⟩ Explain the steps for recovery with missing online redo logs?

Create pfile from spfile

Edit pfile with _allow_resetlog_currpuation=true

1) Connect / as sysdba

2) Startup

3) Recover database until cancel;

4) Alter database open resetlogs;

In RMAN restore:

RMAN> RESTORE CONTROLFILE FROM '[[Location]]';

RMAN> ALTER DATABASE MOUNT;

RMAN> RESTORE DATABASE;

RMAN> RECOVER DATABASE UNTIL TIME "[[Time]]";

RMAN> ALTER DATABASE OPEN RESETLOGS;

Is this answer helpful? 0 Yes | 0 No

Answer This Question

143 views

20⟩ How would you speed up the RMAN backup of a 500GB database?

You can use incremental backup either differential or accumalative. so you dont have to backup the whole database everytime just the changes made

Is this answer helpful? 0 Yes | 0 No

Answer This Question

141 views

RMAN

Home Oracle RMAN

50 RMAN Questions And Answers

1⟩ How to setup the RMAN tape backups?

2⟩ How to clone the database using RMAN software? Give brief steps? When do you use crosscheck command?

3⟩ Tell me Is it possible to take Catalog Database Backup using RMAN?

4⟩ What are the steps required to perform in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software?

5⟩ Tell us In catalog database, if some of the blocks are corrupted due to system crash, How will you recover?

6⟩ List some of the RMAN catalog view names which contains the catalog information?

7⟩ Explain the steps involved in TIME based recovery from the full database from hot backup?

8⟩ Explain the encryption options available with RMAN?

9⟩ What are things which play major role in designing the backup strategy?

10⟩ What is RAID? What is RAID0? What is RAID1? What is RAID 10?

11⟩ How to identify the block corruption in RMAN database? How do you fix it?

12⟩ Suppose you have taken a manual backup of a datafile using o/s. How RMAN will know about it?

13⟩ Explain the steps involved in SCN based recovery from the full database from hot backup?

14⟩ What is the difference between physical and logical backups?

15⟩ Tell me is it possible to specific tables when using RMAN DUPLICATE feature? If yes, how?

16⟩ Explain the steps for changing the DBID in a cloned environment?

17⟩ How RMAN improves backup time?

18⟩ What is the difference between obsolete RMAN backups and expired RMAN backups?

19⟩ Explain the steps for recovery with missing online redo logs?

20⟩ How would you speed up the RMAN backup of a 500GB database?

Quick Links:

RMAN

Home Oracle RMAN

50 RMAN Questions And Answers

1⟩ How to setup the RMAN tape backups?

2⟩ How to clone the database using RMAN software? Give brief steps? When do you use crosscheck command?

3⟩ Tell me Is it possible to take Catalog Database Backup using RMAN?

4⟩ What are the steps required to perform in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software?

5⟩ Tell us In catalog database, if some of the blocks are corrupted due to system crash, How will you recover?

6⟩ List some of the RMAN catalog view names which contains the catalog information?

7⟩ Explain the steps involved in TIME based recovery from the full database from hot backup?

8⟩ Explain the encryption options available with RMAN?

9⟩ What are things which play major role in designing the backup strategy?

10⟩ What is RAID? What is RAID0? What is RAID1? What is RAID 10?

11⟩ How to identify the block corruption in RMAN database? How do you fix it?

12⟩ Suppose you have taken a manual backup of a datafile using o/s. How RMAN will know about it?

13⟩ Explain the steps involved in SCN based recovery from the full database from hot backup?

14⟩ What is the difference between physical and logical backups?

15⟩ Tell me is it possible to specific tables when using RMAN DUPLICATE feature? If yes, how?

16⟩ Explain the steps for changing the DBID in a cloned environment?

17⟩ How RMAN improves backup time?

18⟩ What is the difference between obsolete RMAN backups and expired RMAN backups?

19⟩ Explain the steps for recovery with missing online redo logs?

20⟩ How would you speed up the RMAN backup of a 500GB database?

BE THE FIRST TO KNOW

Quick Links: