Database Backup and Recovery (MOSC)

MOSC Banner

How to exploit the parameters in the file sql with RMAN

edited Mar 1, 2010 3:08PM in Database Backup and Recovery (MOSC) 3 commentsAnswered ✓
HELLO

on oracle 11g

To call rman with a file sql and variables in parameters

Example

RMAN TARGET / NOCATALOG cmdfile='File__for_Rman_.sql   %DBID%  %SID%   %Name_InitOra%

Question

How to exploit the parameters in the file sql

 

ExAmple

SET DBID (DBID ?);

restore spfile to PFILE 'D:\ORACLE\admin\(SID ? )\pfile\( Name_InitOra ?)' from 'D:\oracle\flash_recovery_area\(SID ?)\AUTOBACKUP\ ';

shutdown immediate;

thank you

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center