RMAN: restore the spfile

$sqlplus /nolog;
SQL>connect / as sysdba;
SQL>startup nomount;
SQL>exit;
$rman target / nocatalog
RMAN>set dbid=147749264
RMAN>run
{
allocate channel d1 type disk;
set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘$ORACLE_BASE/oradata/rman_backup/control%F’;
Restore spfile from autobackup;
Release channel d1;
}
Here is the error info: RMAN-06564: rman must use the t0 clause when the instance is started with spfile
This error info implies that you were using default SPFILE [...]

nohup error

$nohup ./rmanbkp.sh
nohup: cannot run command ‘./rmanbkp.sh’: Permission denied
$chmod +x rmanbkp.sh
$nohup ./rmanbkp.sh
nohup: appending output to ‘nohup.out’
nohup: cannot run command ‘./rmanbkp.sh’: No such file or directory
The first line in rmanbkp.sh was
#!/usr/bin/sh
It might be a shell problem. Check ksh path
$which ksh
/bin/ksh
Change it to
#!/bin/ksh
Or, it might be a path problem. Check sh path
$which sh
/bin/sh
Change it to
#!/bin/sh
Reference:
1. http://docs.jach.hawaii.edu/JAC/JACUN/008.0/node42.html
2. http://www.gammon.com.au/forum/?id=8009&page=1

RMAN: can’t open target

$rman target / catalog
rman: can’t open target % ERROR INFO
Because there is another rman file in the system (use which to see the file location as follows). The ORACLE rman is in $ORACLE_HOME/bin.
$which rman
/usr/X11R6/bin/rman
Two ways to solve this problem:
1) Put $ORACLE_HOME/bin at the very beginning of $PATH in your environment
2) run [...]

Common Problems

Some silly problems may incur everyday:

Wrong spelling. ex. “contraint” -> “constraint”
Missing parenthesis
Make sure all the commands in the scripts have the right path, for example, the RMAN case
Correct shell choice

Oracle 9i: How to Create Dictionary Managed Tablespace

When we tried to change tablespace storage paramters in a DBCA created database, we may get the following error information because the storage settings for locally managed tablespaces cannot be altered.
ORA-25143: default storage clause is not compatible with allocation policy.
Or, if you want to create a tablespace dictionary managed, you might get this error information:
ORA-12913: [...]