2,011 reputation
2821
bio website arsanukaev.blogspot.com
location Grozny, Chechen Republic, Russia
age 28
visits member for 3 years, 10 months
seen 1 min ago

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.


3h
awarded  Disciplined
5h
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.
5h
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?
Aug
22
reviewed No Action Needed Copying datadir directory enough for backing up a database with InnoDB tables?
Aug
21
comment SQL Server Database is corrupted
Chances are that your database file was damaged too. I would try to perform complete database recovery (if possible) from backup.
Aug
21
answered Oracle sys password lost
Aug
21
reviewed No Action Needed How can I use parameters of type Int32 from an environment for an integration services package in a SQL Server 2008 job?
Aug
21
comment Delete all the data from all tables
The question obviously has "oracle" tag.
Aug
21
comment Delete all the data from all tables
Or better TRUNCATE instead of DELETE FROM – there's really no need to generate extra redo vectors in the redo log if all you want to do is just get rid of the data.
Aug
21
reviewed No Action Needed How to create a Postgres trigger to ensure field is non-updateable
Aug
21
reviewed No Action Needed Denormalization Strategies: When is it appropriate to create redundancy for faster querying?
Aug
21
answered oracle tablespaces
Aug
19
reviewed No Action Needed MySQL: What are the pros and cons of running with engine=Memory vs on a memory-mapped filesystem?
Aug
19
reviewed No Action Needed Convert yymmdd to datetime using ssis derived column
Aug
19
reviewed No Action Needed How to append value of column with double quotes (add quotes around string)