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

How do you verify the integrity of the image copy in RMAN environment?

saneshkale

 Profile Answers by saneshkale Questions by saneshkale

• Apr 5th, 2010

Use below commands :rman> catalog datafilecopy 'f:testsystem.dbf';rman> backup validate check logical datafile 'f:testsystem.dbf';SQL> SELECT * FROM v$database_block_corruption;

Answer Question  Select Best Answer

List the steps required to enable the RMAN backup for a target database?

naveen_rc

 Profile Answers by naveen_rc Questions by naveen_rc

• Aug 6th, 2009

1. $ rman target / 2. Configure the persistent parameter of RMAN eg :   RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS; old RMAN configuration parameters: CONFIGURE RETE...

Answer Question  Select Best Answer

Explain how to setup the physical stand by database with RMAN?

naveen_rc

 Profile Answers by naveen_rc Questions by naveen_rc

• Aug 6th, 2009

$ Export ORACLE_SID=TEST $ rman target / RMAN> show all;  Using target database controlfile instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REC...

Answer Question  Select Best Answer

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

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

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