When Oracle opens the database, it accesses all of the datafiles associated with the database. Once it has accessed the database datafiles, Oracle makes sure that all of the database datafiles are consistent.Oracle opens the online datafiles and online redo log files. If a tablespace was offline when the database was previously shut down, the tablespace and its corresponding datafiles will still be offline when you reopen the database.
To open the database, you can just use the startup command
SQL> startup mount
If the database is mounted, you can open it with the alter database open command
SQL> alter database open
Related Post :-
0 comments:
Post a Comment