-
RMAN Utility
What is the advantage of RMAN utility?
leopeter
- Jun 15th, 2011
Central Repository Incremental Backup Corruption Detection Advantage over tradition backup system: 1). copies only the filled blocks i.e. even if 1000 blocks is allocated to datafile but...
taya_ronak
- Dec 17th, 2008
Advantage over tradition backup system:1). copies only the filled blocks i.e. even if 1000 blocks is allocated to datafile but 500 are filled with data then RMAN wi...
-
Control File Auto Backup
How do you enable the autobackup for the controlfile using RMAN?
vishpri
- Jul 20th, 2008
issue command at rman prompt..... RMAN> configure controlfile autobackup on;also we can configure controlfile backup format...... RMAN> configure controlfile autoba...
-
RMAN Backup Advantages
List atleast 6 advantages of RMAN backups compare to traditional hot backups?
ashokbabugaddipati
- Jun 1st, 2011
Centralized RepositoryIdentified the corrupted blocks..that means easy to recover the corrupted blocksReduce the backup size ...It takes only occupied blocks
dbasathi
- Oct 14th, 2008
RMAN has the following advantages over Traditional backups:1. Ability to perform INCREMENTAL backups2. Ability to Recover one block of datafile3. Ability to automatically backup CONTROLFILE and SPFILE...
-
Hot Backup Cold Backup
What is hot backup and what is cold backup?
Deshpande Umesh
- Nov 16th, 2010
Cold backup is a backup of database when datafiles are not opened. Hot backup is a backup when datafiles are opend and operational.Suppose your database is in mount stage ( not shutdown ) and you take a backup then it is also a cold backup since datafiles are not opened.
mb.appsdba
- Aug 27th, 2010
Backup taken when database is shutdown is called as cold backup and the backup taken when the database is up and running is called as hot backup.
-
Cumulative and Differential Incremental Backups
What is the difference between cumulative incremental and differential incremental backups?
boyansmail
- Aug 15th, 2010
A cumulative incremental backup is the backup of all files that have changed since the last full backup. A differential incremental backup is the backup of all files that have changed since the last backup.
vishpri
- Jul 20th, 2008
Differencial backup: This is the default type of incremental backup which backs up all blocks changed after the most recent backup at level n or lower.Cumulative backup: Backup all blocks cahnged after the most recent backup at level n-1 or lower.
-
Verify integrity of image copy
How do you verify the integrity of the image copy in RMAN environment?
saneshkale
- Apr 5th, 2010
Use below commands :rman> catalog datafilecopy 'f:testsystem.dbf';rman> backup validate check logical datafile 'f:testsystem.dbf';SQL> SELECT * FROM v$database_block_corruption;
-
Point in Time Recovery
Explain the steps to perform the point in time recovery with a backup which is taken before the resetlogs of the db?
satyam_2007
- Dec 14th, 2009
RMAN can perform recovery of the whole database to a specified past time, SCN, or log sequence number. This type of recovery is sometimes called incomplete recovery because it does not completely use ...
-
RTO MTBF and MTTR
What are RTO, MTBF, and MTTR?
satyam_2007
- Dec 14th, 2009
RTO: Recovery Time objective-is the maximum amount of time that the database can be unavailable and still stasfy SLA'sMTBF (Meant tiem Between Failure)-MTTR (Mean tie to recover)- fast recovery solutions
-
Missing archived redo logs
Outline steps for recovery with missing archived redo logs?
jp1985verma
- Oct 19th, 2009
If the database is operating in ARCHIVELOG mode, and if the only copy of an archived redo log file is damaged, then the damaged file does not affect the present operation of the database. The followin...
-
Schema restore in RMAN
Can a schema be restored in oracle 9i RMAN when the schema having numerous table spaces?
jp1985verma
- Oct 14th, 2009
RMAN gives the command to find all the tablespaces and hence the datafiles belonging to different schemas as:REPORT SCHEMA;This command lists all the schemas, tablespace names and the corresponding da...
-
Missing data file
Outline the steps for recovery of missing data file?
naveen_rc
- Aug 6th, 2009
Connect to RMAN and make the affected Tablespace offline immediate. SQL> !rman target / RMAN> sql 'ALTER TABLESPACE DATA OFFLINE IMMEDIATE'; Perform Restore and Recover of The tablespa...
-
Begin Backup Script
How do you generate the begin backup script?
naveen_rc
- Aug 6th, 2009
SQL>set head off SQL>spool beginbackup.sql SQL>select 'alter tablespace ' tablespace_name ' begin backup;' from dba_tablespaces; SQL>spool off This will create file beginbackup....
-
Target Database RMAN Backup
List the steps required to enable the RMAN backup for a target database?
naveen_rc
- Aug 6th, 2009
1. $ rman target / 2. Configure the persistent parameter of RMAN eg : RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS; old RMAN configuration parameters: CONFIGURE RETE...
-
RMAN Physical Standby database
Explain how to setup the physical stand by database with RMAN?
naveen_rc
- Aug 6th, 2009
$ Export ORACLE_SID=TEST $ rman target / RMAN> show all; Using target database controlfile instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REC...
-
RMAN Auxiliary Channel
What is auxiliary channel in RMAN? When do you need this?
naveen_rc
- Aug 6th, 2009
An auxiliary channel is a link to auxiliary instance. If you do not have automatic channels configured, then before issuing the DUPLICATE command, manually allocate at least one auxiliary channel ...
-
DB Recovery File Dest
What is db_recovery_file_dest ? When do you need to set this value?
naveen_rc
- Aug 6th, 2009
db_recovery_file_dest and db_recovery_file_dest_size are used to specify the location and size of the Flash Recovery Area. These database intilization parameters help RMAN to manage the bac...
-
RMAN Backup Encryption
How do you enable the encryption for RMAN backups?
naveen_rc
- Aug 6th, 2009
If you wish to modify your existing backup environment so that all RMAN backups are encrypted, perform the following steps: ? Set up the Oracle Encryption Wallet ? Issue the following RM...
-
RMAN Parallel Backups
What is Channel? How do you enable the parallel backups with RMAN?
naveen_rc
- Aug 6th, 2009
Channel is a link that RMAN requires to link to target database. This link is required when backup and recovery operations are performed and recorded. This channel can be allocated manually ...
-
What is FRA
What is FRA ? When do you use this ?
naveen_rc
- Aug 6th, 2009
A flash recovery area, a disk location in which the database can store and manage files related to backup and recovery. Flash recovery area where you can store not only the traditional compon...
-
Backup Set
What is backup set?
naveen_rc
- Aug 6th, 2009
RMAN can also store its backups in an RMAN-exclusive format which is called backup set. A backup set is a collection of backup pieces, each of which may contain one or more datafile backups.
RMAN Interview Questions
Ans