Outline the steps for recovery of missing data file?
Latest Answer: 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 tablespace.
RMAN> RESTORE TABLESPACE DATA;
RMAN> ...
Outline the steps for recovery with missing online redo logs?
What is db_recovery_file_dest ? When do you need to set this value?
Latest Answer: db_recovery_file_dest and db_recovery_file_dest_size are used to specify the location and size of the Flash Recovery Area. These database intilization parameters help RMAN to manage the backup storage and delete the obsolete backups and the ...
Outline steps for recovery with missing archived redo logs?
Latest Answer: 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 following situations can arise, however, depending on when ...
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 ...
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 ...
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 backup set?
Latest Answer: RMAN can also store its backups in an RMAN-exclusive format which is called backup set. A backup set is a collection of backup pieces, each of which may contain one or more datafile backups. ...
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 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 ...
View page << Previous 1 2 3 [4] 5 Next >>
Go Top
