May I know that What we can do if data file is corrupted and perform point in time recovery.
Kindly share your valuable views here.
Thanks in advance.
Restore and recovery
1. What does restore and recovery mean? "Restore" means restoring a database backup (data files, control files and/or redologs) from a backup medium. "Recovery" means...
DRS (Disaster Recovery Server)
DRS (Disaster Recovery Server) When the primary (production) database is duplicated on another database, this is referred as a standby database configuration. The aim of this configuration is to...
Speeding Up the SQL Anywhere Automatic Recovery.
How can we speed up SQL Anywhere automatic recovery?Solution:When a database is shut down, the database server performs a checkpoint so that information in the database is held in the database file...
If control file is deleted what to do.
Option 1. Restore the Control file from the latest backup using BRRESTORE command Then u will have to run command at SQL RECOVER using backup controlfile It will ask redo log files, then u will...