Can a schema be restored in oracle 9i RMAN when the schema having numerous table spaces?

jp1985verma

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

Answer Question  Select Best Answer

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

tiwari.abhijeet

 Profile Answers by tiwari.abhijeet Questions by tiwari.abhijeet

• Sep 8th, 2008

You have to catalog that manual backup in RMAN's repository by commandRMAN> catalog datafilecopy '/DB01/BACKUP/users01.dbf';restrictions:> Accessible on disk> A complete image copy of a single file

Answer Question  Select Best Answer

moulvi

 Profile Answers by moulvi Questions by moulvi

• Dec 13th, 2008

Using RMAN BLOCK RECOVER command

Answer Question  Select Best Answer

msmanan

 Profile Answers by msmanan Questions by msmanan

• Jun 19th, 2009

Yes, you can perform backup of catalog database using RMAN with below steps:1. Start the RMAN with NOCATALOG option.2. Run the recovery catalog database in ARCHIVELOG mode.3. set the retention policy ...

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

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

What is db_recovery_file_dest ? When do you need to set this value?

naveen_rc

 Profile Answers by naveen_rc Questions by naveen_rc

• Aug 6th, 2009

db_recovery_file_dest and db_recovery_file_dest_size are used to specify the location and size of the Flash Recovery Area.  These database intilization parameters help RMAN to manage the bac...

shrikant2711

 Profile Answers by shrikant2711 Questions by shrikant2711

• Mar 20th, 2009

If Database Flashback option is on then use this option.

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

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

What are things which play major role in designing the backup strategy?

taya_ronak

 Profile Answers by taya_ronak Questions by taya_ronak

• Dec 7th, 2008

Cold backup: shutdown the database and copy the datafiles with the help of O.S. command. this is simply copying of datafiles just like any other text file copy. Holt backup: backup process start...

fbchua

 Profile Answers by fbchua Questions by fbchua

• Oct 17th, 2008

I Believe in designing a good backup strategy it will not only be simply backup but also a contingency plan. In this case you should consider the following:1. How long is the allowable down time durin...

Answer Question  Select Best Answer

How do you clone the database using RMAN software? Give brief steps? When do you use crosscheck command?

taya_ronak

 Profile Answers by taya_ronak Questions by taya_ronak

• Dec 17th, 2008

Two commands available in RMAN to clone database:?1) Duplicate?2) Restore.

moulvi

 Profile Answers by moulvi Questions by moulvi

• Dec 13th, 2008

Check whether backup pieces, proxy copies, or disk copies still exist.

Answer Question  Select Best Answer

How do you identify the block corruption in RMAN database? How do you fix it?

oracle56

 Profile Answers by oracle56 Questions by oracle56

• Aug 24th, 2008

First check whether the block is corrupted or not by using this commandsql>select file#, block# ?from v$database_block_corruption;?file#? block??2????????507the above block is corrupted.....

kishoredba

 Profile Answers by kishoredba Questions by kishoredba

• Jul 21st, 2008

Using v$block_corruption view u can find which blocks corrupted.Rman>> block recover datafile block ;Using the above statement u recover the corrupted blocks.Thanks & Regards,Kishore.

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 steps required to perform in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software?

krishnaprasad.sola

 Profile Answers by krishnaprasad.sola Questions by krishnaprasad.sola

• Feb 2nd, 2009

HI,    I can expalin what are all the steps to take a rman backup with TSM tape library as follows1.Install TDPO (default path /usr/tivoli/tsm/client/oracle/)2.Once u installed the TDPO,auto...

abdulwahab

 Profile Answers by abdulwahab Questions by abdulwahab

• Jun 30th, 2008

How RMAN works with TAPE with TSM ?

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

How do you enable the autobackup for the controlfile using RMAN?

ashokbabugaddipati

 Profile Answers by ashokbabugaddipati Questions by ashokbabugaddipati

• Jun 1st, 2011

RMAN> configure controlfile autobackup on;

vishpri

 Profile Answers by vishpri Questions by vishpri

• Jul 20th, 2008

issue command at rman prompt.....    RMAN> configure controlfile autobackup on;also we can configure controlfile backup format......   RMAN> configure controlfile autoba...

Answer Question  Select Best Answer

List atleast 6 advantages of RMAN backups compare to traditional hot backups?

ashokbabugaddipati

 Profile Answers by ashokbabugaddipati Questions by ashokbabugaddipati

• Jun 1st, 2011

Centralized RepositoryIdentified the corrupted blocks..that means easy to recover the corrupted blocksReduce the backup size ...It takes only occupied blocks

dbasathi

 Profile Answers by dbasathi Questions by dbasathi

• Oct 14th, 2008

RMAN has the following advantages over Traditional backups:1. Ability to perform INCREMENTAL backups2. Ability to Recover one block of datafile3. Ability to automatically backup CONTROLFILE and SPFILE...

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

List the encryption options available with RMAN?

msmanan

 Profile Answers by msmanan Questions by msmanan

• Jun 19th, 2009

Configure encryption for database onConfigure encryption algorithm 'AES256'

pradipta182

 Profile Answers by pradipta182 Questions by pradipta182

• Sep 26th, 2008

RMAN offers three encryption modes: transparent mode, password mode, and dual mode

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