Reputation
2,271
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
2 11 26
Newest
 Enlightened
Impact
~230k people reached

Jan
11
awarded  Enlightened
Jan
11
awarded  Nice Answer
Jan
4
awarded  Yearling
Dec
18
awarded  Announcer
Dec
10
awarded  Nice Question
Dec
8
comment Restoring an Oracle database from files
Exactly. Once you set the correct value, you can mount the database with startup mount.
Dec
8
comment Restoring an Oracle database from files
You cannot use alter system set on human-readable initialization parameter file. You should use your favorite text editor to specify the parameters in the parameter file. Consult Specifying Initialization Parameters in Database Administrator's Guide.
Dec
8
comment Restoring an Oracle database from files
First, locate the control file—they usually named like control01.ctl. Now create the initialization parameter file initORACLE_SID.ora in ORACLE_HOME\database, where ORACLE_SID is your instance name you specified when installing the software. Add this line to your init file: control_files='path_to_your_control_file'. On the command line, say sqlplus / as sysdba (ensure that you've assigned the correct instance name to the ORACLE_SID environment variable, e. g. set ORACLE_SID=orcl). Mount the database with startup mount.
Dec
7
comment Restoring an Oracle database from files
It doesn't matter where your application's files reside, they can even be on a different host (there's a good point in separating the application and the database). What I meant by instance is that you just need to make a new Oracle Database installation but without creating the database, so you end up with just the software installed—your database data files and control file are already there, you just need to mount and open the database. You can use Oracle Universal Installer on your media to install the instance.
Dec
7
answered Restoring an Oracle database from files
Nov
10
reviewed No Action Needed Sync two SQL Server databases
Mar
17
comment User Password Expiry date is null in user_users?
See also Using Data Dictionary Views to Find Information About Users and Profiles.
Jan
4
awarded  Yearling
Dec
17
revised Prevent auto commit of DROP without SET AUTOCOMMIT OFF
improve post structure, add new 12c table recovery feature description
Nov
8
awarded  Custodian
Nov
5
reviewed Reviewed MySQL improve query syntax
Nov
5
revised MySQL improve query syntax
Improve formatting, fix title, minor tweaks
Nov
5
awarded  Custodian
Nov
5
reviewed Edit Linked Server Security under SQL Agent Job Context
Nov
5
revised Linked Server Security under SQL Agent Job Context
edit tags, improve formatting, minor tweaks