RMAN Q & A Page - 7

RMAN INTERVIEW QUESTIONS AND ANSWERS

                                                                     

                                                                   Page – 7

61. What are the various  reports  available  with RMAN?

RMAN>list backup;

RMAN>list archive;

61.How do you see the information about backups in RMAN?

RMAN> list backup:

Use this sql  statements to check

SQL> select sid totalwork sofar from v$session_longops where sid 153;

here we gave sid  when back start it will show SID

62. List the advantages of  RMAN backup comparing  with the traditional hot backups?

A). Ability  to perform  INCREMENTAL BACKUP

B). Ability  to recover one block of datafile

C). Ability  to automatically  backup CONTROLFIEL  and SPFILE

D). Ability   to Automatically To delete  the ARCHIVE REDDOLOG files,  with the new one’s automatically .

E). Ability  to perform  backup and restore with parallelism

F). Ability  to RESTART the  failed  backup, without starting  from beginning

G). Much faster comparing with other traditional backup strategie.

63. How to clone the database  using RMAN ?

A). Duplicate

B). Restore.

64.How do you setup the RMAN tape backups?

RMAN Target /

Run

{

Allocate channel ch1 device tape sbt_tape maxpiecesize 4g

Format ’D_U_T_t’;

sql ‘alter system switch logfile’;

backup databases;

backup archivelog from time ‘sysdate-7’;

backup Format ‘D_CTLFILE_P_U_T_t’ current controlfile

release channel ch1;

}

The above script for  Tivoli backup server.

66. What is the difference between physical backup and logical backups?

In oracle  logical backup is “ which  is taken using  either Traditional  export / import or  latest data dump. “Where as physical backup is known as when you take the physical  O/S database files as backup.”

67. What is the meaning of RAID? What is RAID0,RAID1?

RAID: It is redundant array of independent disk

RAID0: concatenation and strippin

RAID1: Mirroring

67. Difference between  hot backup and cold backup?

Hot backup taken when the database is on, cold backup is taken during the shut down period

68. How do you test  that your recovery was successful?

SQL> select count(*) from flashback_table;

69. You have taken a manual backup of datafile using O/S, How RMAN can identified the backup?

RMAN>catalogdatafilecopy ‘DB01/BACKUP/userso1.pdf’;

Restriction> Accessible  on disk> A complete copy of single file

69. How can you display warning message?

SQL> select object_type. message_message_type,message_level, reason, suggested_action from dab_outstanding_alerts;

70. How do you backup the entire database?

SQL> BACKUP DATABASE;