 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 ... How do you setup the RMAN tape backups? Latest Answer : RMAN Target / run{Allocate channel ch1 device type sbt_tape maxpiecesize 4gFormat'%D_%U_%T_%t';sql 'alter system switch logfile';Backup database;backup archivelog from time 'sysdate-7';Backup Format '%D_CTLFILE_P_%U_%T_%t' Current controlfile;release ... How do you enable the encryption for RMAN backups? Latest Answer : 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 RMAN command:
RMAN> CONFIGURE ENCRYPTION ALGORITHM ... What is Channel? How do you enable the parallel backups with RMAN? Latest Answer : 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 or can be preconfigured by using
automatic channel ... What is auxiliary channel in RMAN? When do you need this? Latest Answer : 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 within the same RUN command.
When a Duplicate ... 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 ... What is the difference between obsolete RMAN backups and expired RMAN backups? Latest Answer : The term obsolete does not mean the same as expired. In short, obsolete means "not needed," whereas expired means "not found." ... Is it possible to specific tables when using RMAN DUPLICATE feature? If yes, how? 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 ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
