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

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

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

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

vineet tyagi

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

rawishsiddiqui

 Profile Answers by rawishsiddiqui Questions by rawishsiddiqui

• Jul 19th, 2008

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

Answer Question  Select Best Answer

What is the difference between cumulative incremental and differential incremental backups?

boyansmail

 Profile Answers by boyansmail Questions by boyansmail

• Aug 15th, 2010

A cumulative incremental backup is the backup of all files that have changed since the last full backup. A differential incremental backup is the backup of all files that have changed since the last backup.

vishpri

 Profile Answers by vishpri Questions by vishpri

• Jul 20th, 2008

Differencial backup: This is the default type of incremental backup which backs up all blocks changed after the most recent backup at level n or lower.Cumulative backup: Backup all blocks cahnged after the most recent backup at level n-1 or lower.

Answer Question  Select Best Answer