TutorialDBA - Support | Training | Consultant

Q 1 What is SCN? A 1 The SCN is an Oracle server–assigned number that indicates a committed version of the database. It’s quite possible that different datafiles in the database might have a different SCN at any given point in time. At checkpoint, the server will makes all database file SCNs and control file SCN consistent with respect to an identical SCN.The datafiles will not contain any database changes beyond that common SCN. This synchronization of the SCNs will make sure we have a consistent backup of database. When you are doing hot backup, you may end up with backups of the various datafiles at various time points and different SCNs and you can not open a database without synchronizing the SCN on all data files, so you will have to apply archive logs to make the data current and synchronize the SCNs across the datafiles. Q 2 What is the significance of fast_start_mttr_target parameter? A 2 You use the Oracle initialization parameter fast_start_mttr_target to spec...

1) Difference between catalog and nocatalog? ANS: CATALOG is used when you use a repository database as catalog. NOCATALOG is used when you used the controlfile to register your backup information. Default in NOCATALOG. 2) Difference between using recovery catalog and control file? ANS: When new incarnation happens, the old backup information in control file will be lost.  It will be preserved in recovery catalog. In recovery catalog, we can store scripts. Recovery catalog is central and can have information of many databases. 3) Can we use same target database as catalog? ANS: No.  The recovery catalog should not reside in the target database (database to be backed up), because the database can't be recovered in the mounted state. 4) How do u know how much RMAN task has been completed? ANS: By querying v$rman_status or v$session_longops 5) From where list & report commands will get input LIST: The primary purpose of the LIST command is to list backup and copies. For exam...

What is RMAN and How to configure it?   RMAN is an Oracle Database client    It performs backup and recovery tasks on your databases and automates administration of your backup strategies    It greatly simplifies the dba jobs by managing the production database's backing up, restoring, and recovering database files    This tool integrates with sessions running on an Oracle database to perform a range of backup and recovery activities, including maintaining an RMAN repository of historical data about backups   There is no additional installation required for this tool    It is by default get installed with the oracle database installation    The RMAN environment consists of the utilities and databases that play a role in acking up your data    We can access RMAN through the command line or through Oracle Enterprise Manager 2) Why to use RMAN?      RMAN gives you access to several backup and recover...