Monday, 4 July 2016

How to create backup of control file


— backup control file in readable format in /tmp/x.trc, the script created doesn’t contain information about backups so if you backup in the binary format it will keep the backup information


SQL> alter database backup controlfile to trace as ‘/tmp/x.trc’;

Database altered.

No comments:

Post a Comment

Add Data file

 ************************************************** Database status Tablespace Usage ASM Disk Group Usage(RAC) Backup Filesystem Usage Alert...