Re: RMAN restore - log_file_name_convert

Posted by ErmanArslansOracleBlog on Nov 21, 2016; 3:53pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-restore-log-file-name-convert-tp1576p1580.html

Where is your restore command ( I mean the restore command for datafile/database)

You cant use the same syntax for restore of datafiles.

For example, following command will result with "RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP "

restore datafile 4 from 'C:\ORACLE\PRODUCT\9.2\DATABASE\0TI6L6AD_1_1';

2016-11-21 18:49 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

I managed to restore the controlfile using

RMAN> run {
set controlfile autobackup format for device type disk to '/opt/app/oracle/product/<a href="http://11.2.0.4/dbs/%F" target="_blank">11.2.0.4/dbs/%F';
restore controlfile from autobackup;
}2> 3> 4>


Now I am getting



allocated channel: c4
channel c4: SID=1563 device type=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 21-NOV-16

released channel: c1
released channel: c2
released channel: c3
released channel: c4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/21/2016 19:59:54
RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/RMAN-restore-log-file-name-convert-tp1576p1579.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--