-
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...
-
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 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...
-
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
-
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 ...
-
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;
-
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.
-
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.
-
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...
-
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 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...
-
RMAN Recovery Catalog
How do you install the RMAN recovery catalog?
leopeter
- Jun 15th, 2011
Steps to be followed: 1) Create connection string at catalog database. 2) At catalog database create one new user or use existing user and give that user a recovery_catalog_owner privi...
taya_ronak
- Dec 17th, 2008
Steps to be followed: 1) Create connection string at catalog database. 2) At catalog database, create one new user or use existing user and give that user a recovery_catalog_owner privilege.3) Login...
-
RMAN Backup Information
How do you see information about backups in RMAN?
mangeshchede
- Jun 16th, 2011
RMAN>list backup;Above command gives you the information about RMAN backups.
shrikant2711
- Mar 20th, 2009
Use this SQL to checkSQL> SELECT sid,totalwork,sofar FROM v$session_longops
WHERE sid=153;
Here give SID when back start it will show SID
-
Identify Expired, Active, Obsolete Backups
How do you identify the expired, active, obsolete backups? Which RMAN command you use?
mangeshchede
- Jun 16th, 2011
1) RMAN>crosscheck backup;This command will give you the output for the Active and Expired Backups.2) RMAN>report obsolete;This command will shows you the obsolete backups.
saneshkale
- Apr 5th, 2010
Use command:Rman > crosscheck backup; Rman > crosscheck archivelog all; Rman > list backup;Rman > list archive logall;
-
Taking Manual backup with RMAN
You have taken a manual backup of a datafile using o/s. How RMAN will know about it?
dbxplorer
- Jul 24th, 2011
If you already have copy of datafile using OS command, then you can let RMAN know about it using command "CATALOG".
We have copy of datafile "user01.dbf" using OS.
RMAN> Connect target=/
RMAN> CATALOG datafilecopy 'C:/Backup/users01.dbf';
For verification:
RMAN> LIST COPY
-
Hot Backup Pre-requirements
-
RMAN Encryption Algorithm
What is the meaning of configure encryption algorithm in rman and why we need to set this parameter in rman configuration
-
RMAN backup
How would you speed up the RMAN backup of a 500GB database?
-
RMAN Backup Time
How RMAN improves backup time?
gzhang1970
- May 6th, 2012
run rman BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG incr_update DATABASE; RECOVER COPY OF DATABASE WITH TAG incr_update; If this is the first time to run it will create an incremental...
atif waqar
- Mar 31st, 2012
In 10g You can minimize backup time By "duration 00:30 minimize time;"
run{backup format /complete path duration 00:30 minimize time database}
ADD CHANNELS FOR IMPROVE PERFORMANCE ... -
Obsolete and Expired RMAN backups
What is the difference between obsolete RMAN backups and expired RMAN backups?
vineet tyagi
- May 8th, 2012
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.rawishsiddiqui
- Jul 19th, 2008
The term obsolete does not mean the same as expired. In short, obsolete means "not needed," whereas expired means "not found."
RMAN Interview Questions
Ans