![]() ![]() If you lose the server parameter file, then RMAN can restore it to its default location or to a location of your choice. Open the database with the RESETLOGS option.įor example, enter the following command: ALTER DATABASE OPEN RESETLOGS To recover a NOARCHIVELOG database with incremental backups:Īfter connecting to the target database and the recovery catalog, place the database in a mounted state: STARTUP FORCE MOUNTįor example, you can perform incomplete recovery with the following commands: RESTORE DATABASE When you are recovering a NOARCHIVELOG database, specify the NOREDO option on the RECOVER command to indicate that RMAN should not attempt to apply archived redo logs. The incremental backups must be consistent, like all backups of a database run in NOARCHIVELOG mode, so you cannot make backups of the database when it is open. You can perform limited recovery of changes to a database running in NOARCHIVELOG mode by applying incremental backups. Media recovery is not possible because no archived redo logs exist. ![]() Only consistent backups can be used in restoring a database in NOARCHIVELOG mode. Restoring a database running in NOARCHIVELOG mode is similar to restoring a database in ARCHIVELOG mode. ![]() Recovering a NOARCHIVELOG Database with Incremental Backups ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |