Recover database backup controlfile

If the backup controlfile was created when the database was open, the recovery ends with. ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

UNTIL CANCEL] [UNTIL TIME date ] [UNTIL CHANGE int ] [USING BACKUP CONTROLFILE] [TEST ALLOW int CORRUPTION ] RECOVER [AUTOMATIC] [FROM ] [STANDBY] DATABASE

archivelog options: ARCHIVELOG NOARCHIVELOG backup and recovery options: BACKUP CONTROLFILE TO DATABASE - CREATE DATABASE. RECOVER - SHUTDOWN - STARTUP - ALTER SYSTEM ARCHIVE LOG STOP

to create a backup controlfile for scripting recovery? Often times we are faced, in Oracle, to recover our databases with a backup controlfile. Or worse yet we just need to clone or copy our database

SVRMGR Reapply all of the archived redo logs from the production database

RECOVER DATABASE USING BACKUP CONTROLFILE ----- Remove

you restore your database using a backup control file, you must run RECOVER DATABASE and perform an OPEN RESETLOGS on the database. For more details on restrictions on using RESTORE CONTROLFILE in

Since a backup controlfile is being used, the archive logs necessary for recovery will NOT appear in V$RECOVERY_LOG. RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE Starting with the

SQLPLUSll be prompted to supply an archived log file, Restore that file. to the archive log destination (if not already there

CREATE CONTROLFILE REUSE DATABASE It is quite possible that you might get some