-
Taking Manual backup with RMAN
You have taken a manual backup of a datafile using o/s. How RMAN will know about it?
dbxplorer
- Jul 24th, 2011
If you already have copy of datafile using OS command, then you can let RMAN know about it using command "CATALOG".
We have copy of datafile "user01.dbf" using OS.
RMAN> Connect target=/
RMAN> CATALOG datafilecopy 'C:/Backup/users01.dbf';
For verification:
RMAN> LIST COPY
-
Missing data file
Outline the steps for recovery of missing data file?
naveen_rc
- Aug 6th, 2009
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 tablespa...
-
Missing archived redo logs
Outline steps for recovery with missing archived redo logs?
jp1985verma
- Oct 19th, 2009
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 followin...
-
RTO MTBF and MTTR
What are RTO, MTBF, and MTTR?
satyam_2007
- Dec 14th, 2009
RTO: Recovery Time objective-is the maximum amount of time that the database can be unavailable and still stasfy SLA'sMTBF (Meant tiem Between Failure)-MTTR (Mean tie to recover)- fast recovery solutions
-
RMAN Auxiliary Channel
What is auxiliary channel in RMAN? When do you need this?
naveen_rc
- Aug 6th, 2009
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 ...
-
RMAN Parallel Backups
What is Channel? How do you enable the parallel backups with RMAN?
naveen_rc
- Aug 6th, 2009
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 ...
-
Backup Set
What is backup set?
naveen_rc
- Aug 6th, 2009
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.
-
RMAN Backup Encryption
How do you enable the encryption for RMAN backups?
naveen_rc
- Aug 6th, 2009
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 RM...
-
Begin Backup Script
How do you generate the begin backup script?
naveen_rc
- Aug 6th, 2009
SQL>set head off SQL>spool beginbackup.sql SQL>select 'alter tablespace ' tablespace_name ' begin backup;' from dba_tablespaces; SQL>spool off This will create file beginbackup....
-
What is FRA
What is FRA ? When do you use this ?
naveen_rc
- Aug 6th, 2009
A flash recovery area, a disk location in which the database can store and manage files related to backup and recovery. Flash recovery area where you can store not only the traditional compon...
-
RMAN Tape Backups
How do you setup the RMAN tape backups?
shrikant2711
- Mar 20th, 2009
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 '...
-
RAID, RAID0, RAID1 and RAID10
What is RAID? What is RAID0? What is RAID1? What is RAID 10?
sasikumar12
- Dec 10th, 2008
RAID: It is a redundant array of independent diskRAID0: Concatenation and strippingRAID1: Mirroring
-
RMAN Catalog View
List some of the RMAN catalog view names which contains the catalog information ?
moulvi
- Dec 13th, 2008
RC_DATABASE_INCARNATION,RC_BACKUP_COPY_DETAILS,RC_BACKUP_CORRUPTION,RC_BACKUP-DATAFILE_SUMMARY to name a few
-
Point in Time Recovery
Explain the steps to perform the point in time recovery with a backup which is taken before the resetlogs of the db?
satyam_2007
- Dec 14th, 2009
RMAN can perform recovery of the whole database to a specified past time, SCN, or log sequence number. This type of recovery is sometimes called incomplete recovery because it does not completely use ...
-
RMAN Duplicate
Is it possible to specific tables when using RMAN DUPLICATE feature? If yes, how?
Sandhya.Kishan
- May 12th, 2012
It is possible to use RMAN duplicate features to specific tables,with RMAN Duplicate we first create a target or duplicate single instance database and then convert the single instance database to a RAC database.
-
SCN based hot backup recovery
Outline the steps involved in SCN based recovery from the full database from hot backup?
-
Verify integrity of image copy
How do you verify the integrity of the image copy in RMAN environment?
saneshkale
- Apr 5th, 2010
Use below commands :rman> catalog datafilecopy 'f:testsystem.dbf';rman> backup validate check logical datafile 'f:testsystem.dbf';SQL> SELECT * FROM v$database_block_corruption;
-
Target Database RMAN Backup
List the steps required to enable the RMAN backup for a target database?
naveen_rc
- Aug 6th, 2009
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 RETE...
-
RMAN Physical Standby database
Explain how to setup the physical stand by database with RMAN?
naveen_rc
- Aug 6th, 2009
$ 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 REC...
-
Schema restore in RMAN
Can a schema be restored in oracle 9i RMAN when the schema having numerous table spaces?
jp1985verma
- Oct 14th, 2009
RMAN gives the command to find all the tablespaces and hence the datafiles belonging to different schemas as:REPORT SCHEMA;This command lists all the schemas, tablespace names and the corresponding da...
RMAN Interview Questions
Ans