-
Hot Backup Pre-requirements
-
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;
-
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 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
-
Physical and Logical Backups
What is the difference between physical and logical backups?
abhishek_jee
- Nov 17th, 2014
Logical backup implies taking "logical"copies of the database, i.e., the tables, indexes, synonyms, triggers, tablespaces, etc. Physical backup implies taking a "physical" or "actual"backup of the dat...
Jai
- Jan 11th, 2013
Logical backup means backup of tablespace in the form of binary but physical backup means backup of databfile, controlfile, logfile, 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.
-
DBID and Incarnation
What is the significance of incarnation and DBID in the RMAN backups?
Priyan
- Mar 26th, 2013
Incaranation help to go backup to old position of the database.
nareshkumarmca
- Jan 23rd, 2010
DBID means database id.Incunation means: Database incarnation is effectively a new “version” of the database that happens when you reset the online redo logs using “alter ...
-
Tape Backup Solutions
What are the various tape backup solutions available in the market?
-
Recover Full Database from Cold Backup
Outline the steps for recovering the full database from cold backup?
Ravindra Dorlikar
- Dec 12th, 2014
Copy all datafile from latest cold backup as per datafile location in curret control file and make sure all the archive log file are present as the same location mentioned in pfile from the date of c...
pavan.barakam
- Jun 28th, 2014
Copy paste the backed up DBF files in the locations specified in PFILE and open the DB in startup mode.
-
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 ... -
Identify target database
How do you identify what are the all the target databases that are being backed-up with RMAN database?
-
RMAN without Catalog
Where RMAN keeps information of backups if you are using RMAN without Catalog?
RMAN Interview Questions
Ans