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

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

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

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

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

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

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

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

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

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

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

How RMAN improves backup time?

gzhang1970

 Profile Answers by gzhang1970 Questions by gzhang1970

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

atif waqar

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

Answer Question  Select Best Answer

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

gopi

• Feb 21st, 2012

Allocate channels / parallelism.

AJ SAR

• 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

Answer Question  Select Best Answer

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

John X

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

Answer Question  Select Best Answer

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

a.rakesh

 Profile Answers by a.rakesh Questions by a.rakesh

• 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

leopeter

 Profile Answers by leopeter Questions by leopeter

• Jun 15th, 2011

Database should me archive log mode. 

Answer Question  Select Best Answer

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

dbxplorer

 Profile Answers by dbxplorer Questions by 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

Answer Question  Select Best Answer

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

mangeshchede

 Profile Answers by mangeshchede Questions by mangeshchede

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

saneshkale

 Profile Answers by saneshkale Questions by saneshkale

• Apr 5th, 2010

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

Answer Question  Select Best Answer

How do you see information about backups in RMAN?

mangeshchede

 Profile Answers by mangeshchede Questions by mangeshchede

• Jun 16th, 2011

RMAN>list backup;Above command gives you the information about RMAN backups.

shrikant2711

 Profile Answers by shrikant2711 Questions by shrikant2711

• Mar 20th, 2009

Use this SQL to checkSQL> SELECT sid,totalwork,sofar FROM v$session_longops
WHERE sid=153;
Here give SID when back start it will show SID

Answer Question  Select Best Answer

How do you install the RMAN recovery catalog?

leopeter

 Profile Answers by leopeter Questions by leopeter

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

taya_ronak

 Profile Answers by taya_ronak Questions by taya_ronak

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

Answer Question  Select Best Answer