Oracle

Show Oracle Database DBID

, , No Comment

The database ID or DBID is a unique identification number computed when the database is created. To find out this number, you can either: 1) Login to RMAN,  it will display the DBID upon connection to the…

Read Post →

RMAN-06172: no autobackup found

, , No Comment

While performing disaster recovery I get the error RMAN-06172 as below. RMAN> restore spfile to pfile ‘/oracle/app/oracle/product/10.2.0/db_1/dbs/initARJU.ora’ from ‘/backup1/snap/june/ctl_sp_bak_c-448149146-20080607-00’; Starting restore at 27-AUG-08 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=36 devtype=DISK RMAN-00571: ==================================================== RMAN-00569: =============== ERROR…

Read Post →

Changeing an Oracle database character set

, , No Comment

Check what character set you are using at the moment. SQL> select value from v$nls_parameters where parameter=’NLS_CHARACTERSET’; Shutdown the database. SQL> shutdown immediate; Startup in mount mode. SQL> startup mount; Restrict the database. SQL> alter…

Read Post →