Use the following commands:
STARTUP MOUNT ALTER DATABASE OPEN RESETLOGS; SHUTDOWN IMMEDIATEThe OPEN RESETLOGS will re-create the missing online redo logs. After the database is shut down, take a backup of the database.
Dig deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.