An offline backup of a standby database, without going into detail about Data Guard and RMAN, differs in some respects from a normal offline backup. First, the files that are required for a complete backup of the database must be determined. For the backup, the data files of the standby database and the control file as well as the configuration files of the primary database must be backed up, since in the worst case scenario the primary database needs to be restored.
Data files: Information about all data files including path, name and size of the files can be determined using the V$DATAFILE view . The DBA_DATA_FILES view is not bulgaria telegram screening available when the database is not open - i.e. also in the MOUNT status, which is usually the case with the standby database.
Path and file names as well as size of the data files:
Standby database:
If the directory structures of the primary and standby databases differ, the initialization parameters LOG_FILE_NAME_CONVERT and/or DB_FILE_NAME_CONVERT must be set in the primary and standby databases.