Wednesday, May 21, 2025

How to run sql commands from rman prompt ?

 

run sql commands from rman prompt 


[oracle@orcl dbs]$

[oracle@orcl dbs]$

[oracle@orcl dbs]$ rman target /


Recovery Manager: Release 19.0.0.0.0 - Production on Wed May 21 12:22:35 2025

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


connected to target database: DB1 (DBID=1788905834)


RMAN> select dbid , name ,open_mode from v$database;


using target database control file instead of recovery catalog

      DBID NAME      OPEN_MODE

---------- --------- --------------------

1788905834 DB1       READ WRITE


RMAN>



*Note - not all sql commands will run from rman prompt 

No comments:

Post a Comment