Again let's talk about backups. There are two types of backup:
• Saying backups cold. In this case the base is inaccessible to users and it performs a simple file copy appropriate to restore in case of trouble.
• The hot backup. Aurrez you understand, it is a backup open database while user continues to work on their preferred base. It is usually this type of configuration found in production mode or can not afford to stop a database to save.
However, in some cases (Bureau study, Publisher, test environment, ..) it may be desirable to set up a backup strategy without it becoming too complicated.
Again, a bit of thought...
2 Purge listener.log
Tonight I decided to talk about the listener.log. For information on your server, you have a
"LISTENER" that listens for connection requests to the ORACLE
database.
Listener.log file keeps track
of these requests. This can be useful in case of trouble.
Firstly if you want to disable
this trace, simply add the following line listener.ora file.
TRACE_LEVEL_LISTENER = OFF
I recall that the file in
question is located in the directory / ORACLE_HOME / Network / Admin
Listener.log file when it is
in the directory / ORACLE_HOME / Network / log
If you do not monitor this
file, it may grow to substantial...
2 Multiplexer Control Files Oracle (control-files)
Multiplexer Oracle control files.How to add control files in Oracle.How to multiplex the control files with a spile.How to add a control file with a PFILE.It is strongly recommended to multiplex control files also called ctl files (control-files).Multiplexing can be implemented in the creation of the database or subsequently.We'll add a control file in the next destination E: \ DATABASE \ -> CONTROL04.CTL.Add an Oracle control file with a static parameter file PFILE.Edit the PFILE is appointing initSID.ora, complete control file parameter by adding the path + name of the new control file. CONTROL_FILES = ('Coracledba\oradata\test_database\control.ctl' ...
7 Move Oracle Control File
Move an Oracle control file.
How to Move an Oracle Control File E:\DATABASE\CONTROL03.CTL to F:\DATABASE\CONTROL03.CTL?.
Two methods depending on the configuration PFILE or SPFILE in place.
If you use the static parameter file PFILE.
Edit the PFILE is appointing initSID.ora, change the setting in there CONTROL_FILES modifying the file path control. E: \ DB1 \ CONTROL03.CTL to F: \ DB1 \ CONTROL03.CTL
CONTROL_FILES = ('C:\Oracledba\oradata\test_database\control.ctl'
'D:\DATABASE\CONTROL02.CTL'
'F:\DATABASE\CONTROL03.CTL')
SQL> shutdown immediate;
Then Cut / Paste the file control (or HOST MOVE) E:\DATABASE\CONTROL03.CTL...
Subscribe to:
Posts (Atom)