Wednesday, June 14, 2017

RMAN Reset a parameter

In order to reset the parameter user keyword clear


CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';


RMAN> CONFIGURE DEFAULT DEVICE TYPE clear;

old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
RMAN configuration parameters are successfully reset to default value

RMAN> 


New value is 

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

RMAN get DB ID

Simple command to get the DB ID or database

RMAN> list db_unique_name of database QA1TST;


List of Databases
DB Key  DB Name  DB ID            Database Role    Db_unique_name
------- ------- ----------------- ---------------  ------------------
8320622 QA1TST   4251438513       PRIMARY          QA1TSTP            
8320622 QA1TST   4251438513       STANDBY          QA1TSTD            

RMAN>