Oracle/RMAN

Advertisement


Question
Hi Elliot,

Could you please explain me.
1) How many days backup, by default RMAN stores?
2) From where list & report commands will get input?
3) What is the difference between auxiliary channel and maintenance channel?

Regards,
Seshu

Answer
Good day Sechu

(1) I don't really know what the default RMAN keep for backup.  I always specify my retention policy.  I never use the default.  Here is some information about RMAN retention policy
http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmconc1.htm#i1008093

(2) It is depending on how you configure your rman.  Are you using catalog or not?  If you are using catalog, then it will be from the catalog, otherwise, it's the control file.
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm

(3) The definition of the auxiliary channel is as follow according to http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta004.htm
  
"Specifies a connection between RMAN and an auxiliary database instance.

An auxiliary instance is used when executing the DUPLICATE or TRANSPORT TABLESPACE command, and when performing TSPITR with RECOVER TABLESPACE (see Example 2-9). When specifying this option, the auxiliary instance must be started but not mounted.

See Also: DUPLICATE to learn how to duplicate a database, and CONNECT to learn how to connect to a duplicate database instance"

You will be able to find the other channel description ther.

Elliot  

Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Elliot Mak

Expertise

I can answer questions with regarding to Oracle DB (8i, 9i, 10g, 11g) installation, configuration, administration, Data Guard, SQL, and PL/SQL (Procedures, triggers, functions).

Experience

I am an Oracle DBA, Senior PA, Project Manager, and Data Architect with 10 years of experience.

Education/Credentials
Bachelor of Science in Management System

©2016 About.com. All rights reserved.