| | Recover a dropped/deleted table from RMAN Backup
From 10g Onwards you can recover the dropped table from recyclebin, suppose the table is not available in recycle bin also flashback database in not enabled.
But you are having a recent RMAN backup containing that particular missing/deleted/dropped table.
you can recover the table by
1. create a duplicate database from production database ... | | More... 08/11/10 | | | | |
|
| | Drop wrongly added Datafile in Tablespace(10gR2)
Unfortunately, you can't. Prior to Oracle Database 10g Release 2, your only clean option for removing a datafile is to drop the entire tablespace and then rebuild it without that particular file. If the tablespace contains data, you have to go through the time-consuming and laborious process of storing the ... | |  More... 08/11/10 | | | | |
|
| | test
ops$oracle.PONP> @?/rdbms/admin/addmrpt
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
3392966083 PONP 1 PONP
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB ... | | More... 06/16/10 | | | | |
|
| | ADDM
ops$oracle.PONP> @?/rdbms/admin/addmrpt
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
3392966083 PONP 1 PONP
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB ... | | More... 06/16/10 | | | | |
|
| | Two databases with the same name on one server
You can run 2 Oracle instances with the same database name. To do that set the following
parameter(s):
Instance 1:
*.lock_name_space=DB1
*.sp_name=DB1
Instance 2:
*.lock_name_space=DB2
*.sp_name=DB2
In your oratab you would have two entries, one for DB1 and another one for DB2. db_name would be the same for both. | | More... 02/17/09 | | | | |
|
| | how to create a log file if lost?
1-Now you are facing a problem that the db doesn't open
2-log on the db as sys dba
run>cmd>sqlplus username/password as sysdba
3-alter database clear logfile group (number of the lost group file);
such as
alter database clear logfile group 2;
4- open the database
alter database open;
| |  More... 01/13/09 | | | | |
|
| | 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 | | | | |
|
| | How to upgrade Oracle 10.2.0.3 to 10.2.0.4
1. Shutdown database running on older version
2. Edit oratab and change ORACLE_HOME to 10.2.0.4 for the database being upgraded
3. Start the database
4. Run the upgrade assistant
$ORACLE_HOME/bin/dbua
... that's it
| |  More... 07/14/08 | | | | |
|
| | How to drop Oracle database
Dropping database from sqlplus
1. Shutdown the database
SQL> shutdown immediate;
2. Mount exclusive and put in restricted mode
SQL> startup nomount;
SQL> alter database mount exclusive;
SQL> alter system enable restricted session;
3. Drop database
SQL> drop database; | | More... 06/04/08 | | | | |
|
|
Page 1 | 2 >> |