| | MySQL change user password
mysqladmin -u root password [newpassword]
mysqladmin -u root -p [oldpassword] [newpassword]
- or -
mysql -u root -p
mysql> use mysql;
mysql> update user set password=PASSWORD("NEWPASSWORD") where user='root';
mysql> flush privileges;
mysql> quit
| | More... 10/30/08 | | | | | | | | |
|
| | How to enable Data Guard for Oracle standby database
Assumptions:
- This is what was done to switch to data guard from manual log shipping on existing standby database
- This is a physical standby
- Maximum Performance mode
- Recovery lag 24 hours
- No role transition is used, just a failover from production to standby database
- Primary database is called PROD and ... | |  More... 10/28/08 | | | | | | | | |
|
|
| | How to drop RMAN catalog
The drop command has to be run twice to drop RMAN catalog, i.e. (replace RMANDB with the database where you have RMAN schema installed):
rman catalog rman/rman@RMANDB
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Oct 7 13:55:42 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to recovery catalog database
RMAN> drop ... | | More... 10/07/08 | | | | | | | | |
|
| | How to create RMAN catalog schema
1. Run the following commands in sqlplus:
$ sqlplus "/ as sysdba"
SQL> create user rman identified by rman
default tablespace tools
temporary tablespace temp
quota unlimited on tools;
SQL> grant connect, resource, recovery_catalog_owner to rman;
SQL> exit;
2. Run the following rman commands:
rman catalog rman/rman
RMAN> create catalog tablespace tools;
RMAN> exit; | | More... 10/07/08 | | | | | | | | |
|
| | How to purge Oracle recycle bin
To purge recyclebin for a specific user, login as that user and run:
SQL> PURGE dba_recyclebin;
To purge everything:
SQL> PURGE dba_recyclebin;
| |  More... 10/06/08 | | | | | | | | |
|
| | How to get list of backed up data files from RMAN catalogue schema
To get a list of datafiles with sizes in Kb for the current incarnation of a database (in this example TESTDB) directly from RMAN catalogue database - login as the catalogue schema owner and run the query below:
select d.NAME || ',' || d.BYTES/1024 as name_kb
from RC_DATAFILE d, RC_DATABASE_INCARNATION i
where d.DB_NAME ... | | More... 09/10/08 | | | | | | | | |
|
| | How to run two instances with the same database name in one ORACLE_HOME
If you cloned a database and need to run both instances with the same db_name from one $ORACLE_HOME i.e.:
*.db_name=TESTDB
use the following parameters in your pfile or spfile:
*.lock_name_space=ANOTHERDB
*.sp_name=ANOTHERDB
Where ANOTHERDB is the name of the cloned sid.
Note: this has been tested with Oracle 10.1 only | |  More... 09/09/08 | | | | | | | | |
|
|
|
<< 1 | 2 | 3 | Page 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 >> |