Friday, December 22, 2023

RMAN Basic

                                             RMAN basic


                    after connection Rman, check database is open or not.






Open Database  from SQL Plus as follow.

           



Connect RMAN:-



RMAN> SHOW ALL;


check all RMAN parameter


RMAN> LIST BACKUP SUMMARY;



when the RMAN backup is running, if you want to see the progress, you can query the V$RMAN_STATUS table from sql*plus as shown below.


SELECT OPERATION, STATUS, MBYTES_PROCESSED, START_TIME, END_TIME from V$RMAN_STATUS;




Changing Archivelog policy to STANDBY server



















 






No comments:

Post a Comment