Re: RMAN backup

Posted by Roshan on Oct 12, 2016; 10:16am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-backup-tp1369p1391.html

Hello Erman,

it's ok. I will not delete later. .

I copied all the archive logs from production to test instance(log_destination)

I recovered the database using the following command:
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
ORA-00279
....
ORA-00289...
ORA-00280:...
specify log: {=suggested | filename | AUTO | CANCEL}

From there, I specified the archive log it was asking.

Then I issued alter database open resetlogs. It worked.

--https://dbatricksworld.com/ora-01113-file-n-needs-media-recovery-ora-01110-data-file-n-system01-data4/

Thanks,
Roshan