Скачать с ютуб HOW TO PERFORM BACKUP & RESTORE & RECOVERY|| ORACLE 12C || RMAN BACKUP RESTORE & RECOVERY || в хорошем качестве

HOW TO PERFORM BACKUP & RESTORE & RECOVERY|| ORACLE 12C || RMAN BACKUP RESTORE & RECOVERY ||

Hi Viewers In this video I have tried to explain backup and restore and recovery with practical method. I am attaching the steps I have performed in the video. FOR THE RMAN SCRIPTS CURLY BRACES ARE NOT ALLOWED OVER THE DESCRIPTION SO I HAVE KEPT THEM AS "()". ACTION PLAN 1. WE WILL TAKE BACKUP OF AN EXISTING DATABASE 2. WE WILL DROP THE DATABASE 3. WE WILL RESTORE THE DATABASE WITH THE HELP OF THE BACKUP mkdir backup chmod 777 backup TAKE BACKUP : ============ rman target / RMAN run ( allocate channel ch1 device type disk; allocate channel ch2 device type disk; crosscheck archivelog all; backup as compressed backupset database format '/u02/backup/Fullback_%T_%U.dbf' plus archivelog format '/u02/backup/Archive_%T_%U.arc'; backup current controlfile format '/u02/backup/Controlback_%T_%U.ctl'; release channel ch1; release channel ch2; ) cd $ORACLE_HOME/dbs TAKE BACKUP OF SPFILE PFILE ============================ cp spfilePROD.ora spfilePROD.ora_bkp create spfile from pfile='/u02/backup/spfilePROD.ora'; VALIDATE BACKUP STATUS BEFORE DROP: =================================== sqlplus / as sysdba col STATUS format a10 col hrs format 999.99 select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; SHUTDOWN THE DATABASE AND START THE DATABASE IN RESTRICT MOUNT MODE: =================================================================== shut immediate; startup mount exclusive restrict; DROP DATABASE ============= drop database; ps -ef | grep pmon RESTORE THE SPFILE FROM THE BACKUP ================================== cp spfilePROD.ora_bkp spfilePROD.ora cd $ORACLE_HOME/dbs sqlplus / as sysdba START THE DATABASE IN NOMOUNT MODE ================================== startup nomount; echo $ORACLE_SID RESTORE THE CONTROL FILE: ======================== rman target / restore controlfile from '/u02/backup/Controlback_20220402_1k0puemd_1_1.ctl'; TAKE THE DATABASE IN MOUNT MODE =============================== RMAN-- alter database mount; CATALOG THE BACKUP LOCATION: =========================== RMAN-- catalog start with '/u02/backup/'; RESTORE THE DATABASE ===================== RMAN-- run ( allocate channel ch1 device type disk; allocate channel ch2 device type disk; restore database; switch datafile all; switch tempfile all; release channel ch1; release channel ch2; ) RECOVER THE DATABASE ==================== RMAN-- recover database; archived log for thread 1 with sequence 12 is already on disk as file /u01/app/oracle/FRA/PROD/archivelog/2022_04_02/o1_mf_1_12_k4hxmnn9_.arc archived log file name=/u01/app/oracle/FRA/PROD/archivelog/2022_04_02/o1_mf_1_12_k4hxmnn9_.arc thread=1 sequence=12 unable to find archived log archived log thread=1 sequence=13 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 04/02/2022 12:50:01 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 13 and starting SCN of 2109369 MAKE THE DATABASE IN OPEN MODE WITH RESETLOGS OPTION: ===================================================== RMAN-- alter database open RESETLOGS; CHECK THE DATABASE STATUS ========================== ps -ef | grep pmon sqlplus / as sysdba select name,open_mode,database_role from v$database; #oracle #oracledba #backup #restore #BACKUPANDRESTORE