How to recover Controlfile without backup
In this video, we are going to learn how to recover controlfile without backup step by step.
#recovercontrolfile #withoutbackup #controlfile
How to recover controlfile without backup?
Website Link: https://ocptechnology.com/recover-or-...
How to create controlfile?
In the Below code, you need to change your database name, logfile group location, and datafile with the location.
1. Check your Database name
select name from v$database;
2. Check your Datafile Location
select name from v$datafile;
3. Check your redo location and size
col member for a55
select l.group#,l.member,f.bytes/1024/1024 "size in MB"
from v$logfile l, v$log f where l.group#=f.group#;
4. How to check your database characterset
col PROPERTY_VALUE for a20
col DESCRIPTION for a20
set line 120
select * from database_properties where PROPERTY_NAME='NLS_CHARACTERSET';
Oracle Interview application https://play.google.com/store/apps/de...
My Facebook page / ocptechnology
My Second Channel / 4usupport
My Instagram / ocptechnology
My Website http://ocptechnology.com/
My Twitter / ocptechnology