Showing posts with label RESETLOGS AND NORESETLOGS IN ORACLE DATABASE. Show all posts
Showing posts with label RESETLOGS AND NORESETLOGS IN ORACLE DATABASE. Show all posts

Tuesday, May 16, 2023

Oracle Database RESETLOGS AND NORESETLOGS Options

RESETLOGS:-

alter database open resetlogs;

this option will reset redo logs and start generating redo logs newly so all old redo logs will be discarded. 

NORESETLOGS:-

alter database open noresetlogs;

this option will used pre-existing redo logs and don't generate redo logs newly. 

Enable OpenSSH on Windows 11

Step 1: Install OpenSSH Server You can do this via PowerShell (run as Administrator ): Check if it's already available: Get-WindowsCapab...