🛠️ Manual Restore & Recover (From backup pieces)
Ü Database Shutdown
sqlplus / as sysdba
SQL> shutdown immediate;
SQL> exit;
Ü DB Startup NOMOUNT
sqlplus / as sysdba
SQL> startup nomount;
SQL> exit;
Ü Controlfile Restore
rman target /
RMAN> RESTORE CONTROLFILE FROM
'/u01/backup/MAXCDB_C_20250929_01.bkp';
RMAN> ALTER DATABASE MOUNT;
Ü Datafiles Restore
RMAN> CATALOG START WITH '/u01/backup'; -- backup location
RMAN> RESTORE DATABASE;
Ü Database Recovery
o Perform a Point-In-Time Recovery (PITR):
RMAN> RECOVER DATABASE UNTIL TIME "TO_DATE('29-SEP-2025 02:30:00','DD-MON-YYYY HH24:MI:SS')";
o Perform a full recovery (up to the latest archive logs):
RMAN> RECOVER DATABASE;
Ü Database Open
RMAN> ALTER DATABASE OPEN RESETLOGS;
Tags
Production