What is the command to take Oracle Control file backup? Standby Control file, ASCII control file

advertisements

_____________________________________________________________________________________________________________________

1. You can create the ASCII control file script using the following command. The output of the command will be created in the user_dump_dest directory of the database. This script can be used for the control file recreation during the database restoration.

Alter database backup controlfile to trace;

Alter database backup controlfile to trace as ‘/data/oracle/backup/file’;

Alter database backup controlfile to trace as ‘/data/oracle/backup/file’ reuse;

Reuse keyword is used for to replace if the file already present.

2. You can back up the control file to a specific location. The output of the command would be in binary format. Normally this command is used for taking the backup of the control file for the hot backup.

Alter database backup controlfile to ‘/data/oracle/backup/file’;

Alter database backup controlfile to ‘/data/oracle/backup/file’ reuse;

3. Below mentioned command is used to create the standby control file. The output of this command will be used for the standby database creation for the primary database(The database which we have prepared the control file).

alter database create standby controlfile as ‘/data/oracle/backup/file’;

_____________________________________________________________________________________________________________________

Website Stats