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

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by 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.

Answer Question  Select Best Answer

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

abdul_dy

 Profile Answers by abdul_dy Questions by abdul_dy

• Jun 15th, 2012

Nid utility is use to change DBID and SID

saneshkale

 Profile Answers by saneshkale Questions by saneshkale

• Apr 5th, 2010

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

Answer Question  Select Best Answer

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

Mahender

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

Answer Question  Select Best Answer

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

Priyan

• Mar 26th, 2013

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

nareshkumarmca

 Profile Answers by nareshkumarmca Questions by nareshkumarmca

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

Answer Question  Select Best Answer

What is the difference between physical and logical backups?

abhishek_jee

 Profile Answers by abhishek_jee Questions by abhishek_jee

• Nov 17th, 2014

Logical backup implies taking "logical"copies of the database, i.e., the tables, indexes, synonyms, triggers, tablespaces, etc. Physical backup implies taking a "physical" or "actual"backup of the dat...

Jai

• Jan 11th, 2013

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

Answer Question  Select Best Answer

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

Ravindra Dorlikar

• Dec 12th, 2014

Copy all datafile from latest cold backup as per datafile location in curret control file and make sure all the archive log file are present as the same location mentioned in pfile from the date of c...

pavan.barakam

 Profile Answers by pavan.barakam Questions by pavan.barakam

• Jun 28th, 2014

Copy paste the backed up DBF files in the locations specified in PFILE and open the DB in startup mode.

Answer Question  Select Best Answer

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

ravinder

• Feb 21st, 2015

You cannot shutdown the database for even some minutes, then in which mode you should run the database?

Aneesh

• 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

Answer Question  Select Best Answer

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

narendra yadav

• Sep 3rd, 2016

I am using HP Data Protector to store Oracle Backup.

Sumit

• Apr 14th, 2014

We are using EMC for Storage

Answer Question  Select Best Answer

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

zakir

• Jun 21st, 2017

We can find out from catalog database.

nanda

• Jun 20th, 2017

Rman> list db_unique_name all;

Answer Question  Select Best Answer

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

subhash

• Jul 13th, 2017

In Reusable Section of Control File

Nisha Srivastava

• Nov 10th, 2014

By Default RMAN Stores all the Backup information to
Target Database Control file.

Answer Question  Select Best Answer

Outline the steps for recovery with missing online redo logs?

Amresh Panda

• Sep 12th, 2017

When One of the Online redo log file is missing fast we know is that current or active or inactive because when current and active is missing then DB is crashed but inactive or unused case db not gone...

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

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

Answer Question  Select Best Answer