Wednesday, 4 December 2013

Backup Control File To Binary File

Goal:

Backup Control File To Binary File

Statement:

SQL> ALTER DATABASE BACKUP CONTROLFILE TO '/tmp/control.bkp';

Database altered.

SQL>ALTER DATABASE BACKUP CONTROLFILE TO 'D:\control.bkp' REUSE;


Using RMAN

RMAN> backup as copy current controlfile format 'c:\control.ctl';

No comments:

Post a Comment