GeekInterview.com
Series: Subject: Topic:

RMAN Interview Questions

Showing Questions 1 - 20 of 52 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

Tape backup solutions

Asked By: shanthiavari | Asked On: Jun 9th, 2008

What are the various tape backup solutions available in the market?

Answered by: Sumit on: Apr 14th, 2014

We are using EMC for Storage

Answered by: jayaprakash on: Aug 31st, 2013

i am using HP proliant.

RMAN without catalog

Asked By: shanthiavari | Asked On: Jul 22nd, 2008

Where RMAN keeps information of backups if you are using RMAN without catalog?

Answered by: nasar khan on: Nov 26th, 2013

in this case. all the information of back set will b in controlfile only. and all backup pieces will get stored in $ORACLE_HOME/dbs. if we didn't configured FRA.

Answered by: Bond007 on: Aug 8th, 2011

RMAN keeps the backup information in control file if we using RMAN w/o catalog.

Dbid and incarnation

Asked By: shanthiavari | Asked On: Jun 10th, 2008

What is the significance of incarnation and dbid in the RMAN backups?

Answered by: Priyan on: Mar 26th, 2013

Incaranation help to go backup to old position of the database.

Answered by: nareshkumarmca on: Jan 23rd, 2010

DBID means database id.Incunation means:  Database incarnation is effectively a new “version” of the database that happens when you reset the online redo logs using “alter ...

Physical and logical backups

Asked By: shanthiavari | Asked On: Jun 9th, 2008

What is the difference between physical and logical backups?

Answered by: Jai on: Jan 11th, 2013

Logical backup means backup of tablespace in the form of binary but physical backup means backup of databfile, controlfile, logfile, spfile

Answered by: rawishsiddiqui on: Jul 19th, 2008


In Oracle Logical Backup is "which is taken using either Traditional Export/Import or Latest Data Pump". Where as Physical backup is known "when you take Physical O/s Database related Files as Backup".

SCN based hot backup recovery

Asked By: shanthiavari | Asked On: Jun 10th, 2008

Outline the steps involved in SCN based recovery from the full database from hot backup?

Answered by: Mahender on: Nov 1st, 2012

The steps are: 1) Shutdown the database 2) Restore data files 3) Mount the database 4) Recover the database (sql> recover database until time 2005-12-14:12:10:03 Time base) (sql> recover database unti...

Dbid in cloned environment

Asked By: shanthiavari | Asked On: Jun 10th, 2008

Outline the steps for changing the dbid in a cloned environment?

Answered by: abdul_dy on: Jun 15th, 2012

nid utility is use to change DBID and SID

Answered by: saneshkale on: Apr 5th, 2010

Note:
Mount the databse
$export ORACLE_SID=test
$ nid target=system/manager
It will change and automaticaly generate new id and asign it to the database.

RMAN duplicate

Asked By: shanthiavari | Asked On: Jun 10th, 2008

Is it possible to specific tables when using RMAN duplicate feature? If yes, how?

Answered by: Sandhya.Kishan on: 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.

Obsolete and expired RMAN backups

Asked By: shanthiavari | Asked On: Jun 10th, 2008

What is the difference between obsolete RMAN backups and expired RMAN backups?

Answered by: vineet tyagi on: May 8th, 2012

Obsolete: means the backup piece is still available,but it is no longer needed.It depends on retention policy,i,e.recovery window .

Expired: means the backup piece or backup set is not found in the backup destination.

Answered by: rawishsiddiqui on: Jul 19th, 2008

The term obsolete does not mean the same as expired. In short, obsolete means "not needed," whereas expired means "not found."

RMAN backup time

Asked By: shanthiavari | Asked On: Jul 22nd, 2008

How RMAN improves backup time?

Answered by: gzhang1970 on: May 6th, 2012

run rman BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG incr_update DATABASE; RECOVER COPY OF DATABASE WITH TAG incr_update; If this is the first time to run it will create an incremental...

Answered by: atif waqar on: Mar 31st, 2012

In 10g You can minimize backup time By "duration 00:30 minimize time;"

run{backup format /complete path duration 00:30 minimize time database}

ADD CHANNELS FOR IMPROVE PERFORMANCE ...

Recover full database from cold backup

Asked By: shanthiavari | Asked On: Jun 10th, 2008

Outline the steps for recovering the full database from cold backup?

Answered by: Nishant Chawre on: May 5th, 2012

Start the database in MOUNT mode RMAN>restore database; then if the online redo logs are intact then RMAN>recover database; if the online redo logs are not intact/not available then RMAN>recover dat...

Answered by: Navas2u on: Jan 8th, 2011

We don't need to recover a database if it were a consistent backup (cold).

But You should make sure to shutdown the DB with options available other than
Abort.

RMAN backup

Asked By: manish03.dba | Asked On: Oct 19th, 2011

How would you speed up the RMAN backup of a 500gb database?

Answered by: gopi on: Feb 21st, 2012

Allocate channels / parallelism.

Answered by: AJ SAR on: Feb 1st, 2012

You can use incremental backup either differential or accumalative. so you dont have to backup the whole database everytime just the changes made

Online redo logs

Asked By: shanthiavari | Asked On: Jun 10th, 2008

Outline the steps for recovery with missing online redo logs?

Answered by: Lokesh M on: Dec 8th, 2011

Create pfile from spfile Edit pfile with _allow_resetlog_currpuation=true 1) Connect / as sysdba 2) Startup 3) Recover database until cancel; 4) Alter database open resetlogs; In RMAN restore: RMAN...

RMAN encryption algorithm

Asked By: gyanudba | Asked On: Jul 6th, 2011

What is the meaning of configure encryption algorithm in RMAN and why we need to set this parameter in RMAN configuration

Answered by: John X on: Sep 8th, 2011

The encryption of backup sets by using one of the algorithms listed in V$RMAN_ENCRYPTION_ALGORITHMS. RMAN can transparently encrypt data written to backup sets and decrypt those backup sets when they ...

Cancel based hot backup recovery

Asked By: shanthiavari | Asked On: Jun 10th, 2008

Outline the steps involved in cancel based recovery from the full database from hot backup?

Answered by: Aneesh on: Aug 18th, 2011

startup nomount pfile='/data01/init.ora'
run create controlfile script SQL>@create_control.sql
SQL>recover database using backup controlfile until cancel;
then after recovery SQL>alter database open resetlogs

Hot backup pre-requirements

Asked By: shanthiavari | Asked On: Jun 9th, 2008

When do you recommend hot backup? What are the pre-reqs?

Answered by: a.rakesh on: Aug 17th, 2011

when there is no down time for database (24/7) ,we should go for hot backup.

pre-req:database must be in archive log mode

Answered by: leopeter on: Jun 15th, 2011

Database should me archive log mode. 

Identify target database

Asked By: shanthiavari | Asked On: Jun 10th, 2008

How do you identify what are the all the target databases that are being backed-up with RMAN database?

Answered by: mahendra on: Aug 10th, 2011

connect to the catalog database and issue following query. it will list the target databases registered and manged by the catalog databases.

SQL> select name,dbid from rc_database;

Answered by: dbxplorer on: Jul 24th, 2011

You only can get information about one particular database at a time, after connecting with RMAN using target as that particular database.
Suppose there are three db A,B,C.

RMAN> connect target userA/pwd

Now whatever query you will execute will only give information about that database A only.

Taking manual backup with RMAN

Asked By: hkravipati | Asked On: Jul 9th, 2011

You have taken a manual backup of a datafile using o/s. How RMAN will know about it?

Answered by: dbxplorer on: 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


Identify expired, active, obsolete backups

Asked By: shanthiavari | Asked On: Jun 10th, 2008

How do you identify the expired, active, obsolete backups? Which RMAN command you use?

Answered by: mangeshchede on: Jun 16th, 2011

1) RMAN>crosscheck backup;

This command will give you the output for the Active and Expired Backups.


2) RMAN>report obsolete;

This command will shows you the obsolete backups.

Answered by: saneshkale on: Apr 5th, 2010

Use command:
Rman > crosscheck backup;
Rman > crosscheck archivelog all;
Rman > list backup;
Rman > list archive logall;

RMAN backup information

Asked By: shanthiavari | Asked On: Jul 22nd, 2008

How do you see information about backups in RMAN?

Answered by: mangeshchede on: Jun 16th, 2011

RMAN>list backup;

Above command gives you the information about RMAN backups.

Answered by: shrikant2711 on: Mar 20th, 2009

Use this SQL to check

SQL> SELECT sid,totalwork,sofar FROM v$session_longops
WHERE sid=153;


Here give SID when back start it will show SID


RMAN recovery catalog

Asked By: shanthiavari | Asked On: Jun 9th, 2008

How do you install the RMAN recovery catalog?

Answered by: leopeter on: Jun 15th, 2011

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 privi...

Answered by: taya_ronak on: Dec 17th, 2008

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...

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.