Showing posts with label RMAN. Show all posts
Showing posts with label RMAN. Show all posts

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