Home > Storage > PowerFlex > White Papers > Dell APEX Block Storage for AWS: Backup and Recovery using DDVE and DD Boost Oracle RMAN Agent > Restore procedure
The following section provides the steps to return an Oracle database to normal operation by restoring the damaged or deleted datafiles from RMAN agent backups that are stored in DD system using Amazon S3 object store.
The restore and complete recovery steps include:
Note: This step is only to simulate a data loss scenario; do not perform this step in a production environment.
[grid@oraaz1 ~]$ asmcmd ASMCMD> cd DATA/ORADB1/DATAFILE/ ASMCMD> ls DAILY_CHANGE_TBS.263.1101916583 SLOBDATA.270.1101906489 SYSAUX.258.1101904555 SYSTEM.257.1101904521 UNDOTBS1.259.1101904571 USERS.264.1101904571 ASMCMD> pwd +DATA/ORADB1/DATAFILE ASMCMD> rm * You may delete multiple files and/or directories. Are you sure? (y/n) y ASMCMD> |
The database fails to open due to the following error:
[oracle@oraaz1 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Apr 18 06:57:50 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started.
Total System Global Area 3221222464 bytes Fixed Size 8901696 bytes Variable Size 1979711488 bytes Database Buffers 1207959552 bytes Redo Buffers 24649728 bytes Database mounted. ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '+DATA/ORADB1/DATAFILE/system.257.1101904521' |
[oracle@oraaz1 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Apr 18 07:04:43 2022 Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORADB1 (DBID=2447094964, not open)
RMAN> RUN { ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle_backup, BACKUP_HOST=10.63.xx.xx, RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent/)'; RESTORE DATABASE; RELEASE CHANNEL CH1; } |
RMAN> RUN { ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle_backup, BACKUP_HOST=10.63.xx.xx, RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent/)'; RECOVER DATABASE; RELEASE CHANNEL CH1; } |
RMAN> alter database open;
Statement processed
RMAN> select name,open_mode from v$database;
NAME OPEN_MODE --------- -------------------- ORADB1 READ WRITE
RMAN> |