2,106 reputation
2823
bio website arsanukaev.blogspot.com
location Grozny, Chechen Republic, Russia
age 29
visits member for 3 years, 11 months
seen Dec 22 at 15:13

A programmer (loves Haskell, Erlang, Scheme)

A DBA (mostly Oracle)

Oracle Database Administrator Certified Associate

Passed Oracle Database OCP exam recently

One of my best answers: "Practical use of curried functions?"

On Twitter.


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
Nov
5
reviewed No Action Needed Pros and cons in combining current data and historical data in the same table
Nov
5
reviewed No Action Needed Error Grouping By Multiple Columns using CASE
Nov
5
reviewed No Action Needed MySQL data to Postgres every X time
Nov
5
reviewed No Action Needed Domain group as single login, but still many different database users?
Nov
2
answered How to install oracle 11g XE and use the data files of another instance (like Postgres)?
Oct
31
awarded  Disciplined
Oct
31
comment ORACLE restore - how to restore specific .bkp file?
Also notice that in my example we made sure that the control file is sufficiently old, otherwise Oracle would attempt to recover the data files up to and including the latest change in database which is probably not what you want. So first, restore the sufficiently old control file (possibly from the controlfile autobackup), then place your database, archive log and differential backup files to Recovery Area on disk and say CATALOG RECOVERY AREA, so that backups are added to RMAN repository (control file), and, finally, RESTORE DATABASE, RECOVER DATABASE, ALTER DATABASE OPEN RESETLOGS.
Oct
31
comment ORACLE restore - how to restore specific .bkp file?
Probably your database is in ARCHIVELOG mode and the backups you're restoring from was taken online (hot backup), and there are archive logs which need to be applied to the data files you restored to make them consistent with your current control file. This is called the roll forward phase. Or you have differential database backups which should also be applied to the restored data files. In either case, you need to say RECOVER DATABASE just after RESTORE DATABASE, to apply all the changes made to the database since the last backup, only then you can open with RESETLOGS.
Oct
4
awarded  Famous Question
Sep
6
comment oracle tablespaces
Did you try to set quota to 0 on USER tablespace before importing data? For example, alter user YOURUSERNAME quota 0 on tablespace users. If the user doesn't have the necessary quota on the tablespace where the data should be imported from the dump file, then the data is imported in default tablespace set for the user, e. g. alter user YOURUSERNAME default tablespace newtbs. Check this out docs.oracle.com/cd/E11882_01/server.112/e22490/…
Sep
3
comment Mysql performance tunning
Better be asked on dba.se
Aug
28
comment Oracle Buffer Pool TARGET_SIZE is different from CURRENT_SIZE, but RESIZE_STATE is STATIC
Does querying v$memory_resize_ops and dba_hist_memory_resize_ops reveal anything interesting?
Aug
24
comment While altering tablespace shows error tablespace does not exist
Can you check if select name, dump(name) from v$tablespace where name = upper('example') gives the same name (EXAMPLE) as in your first query?