 Related Questions How do you install the RMAN recovery catalog? Latest Answer : 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 into RMAN with connection string ... List some of the RMAN catalog view names which contains the catalog information ? Latest Answer : RC_DATABASE_INCARNATION,RC_BACKUP_COPY_DETAILS,RC_BACKUP_CORRUPTION,RC_BACKUP-DATAFILE_SUMMARY to name a few ... Outline the steps for recovering the full database from cold backup? How do you clone the database using RMAN software? Give brief steps? When do you use crosscheck command? Latest Answer : Two commands available in RMAN to clone database: 1) Duplicate 2) Restore. ... How do you identify the block corruption in RMAN database? How do you fix it? Latest Answer : First check whether the block is corrupted or not by using this commandsql>select file#, block#  from v$database_block_corruption; file# block  2        507the above block is corrupted...conn to RmanTo recover the block use this command...Rman>blockrecover ... Outline the steps involved in TIME based recovery from the full database from hot backup? Outline the steps involved in CANCEL based recovery from the full database from hot backup? Outline the steps involved in SCN based recovery from the full database from hot backup? List the steps required to enable the RMAN backup for a target database? Latest Answer : 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 RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
new RMAN ... Explain how to setup the physical stand by database with RMAN? Latest Answer : $ 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 RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
