ORA-959 during backup

[Chucks_k]

Hi all,

Has anyone come across an ORA-959 error during a hotbackup (the error occurred when the backup began and ended). We are using a Oracle 9i db. And the db actually houses the RMAN catalog

Thanks in advance for your help,
Nikesh.

[SANJAY_G]

ORA-00959 tablespace 'string' does not exist

Cause: A statement specified the name of a tablespace that does not exist.

Action: Enter the name of an existing tablespace. For a list of tablespace names, query the data dictionary.


I am wondering you are still using conventional OS hotbackups though you are runnning on 9i. RMAN is the way to go.

[SANJAY_G]

oooopss. missed that you are actually using RMAN. Can you copy/paste complete rman error?

[Latyr]

Could be helpful if you post as well your RMAN script and if you precise what you are doing.
One important thing to know RMAN can not backup its own catalog.

[marist89]

Originally posted by Chucks_k
Hi all,

Has anyone come across an ORA-959 error during a hotbackup (the error occurred when the backup began and ended). We are using a Oracle 9i db. And the db actually houses the RMAN catalog

Thanks in advance for your help,
Nikesh.

You were doing a scripted hot-backup without RMAN on the RMAN catalog? Or you were doing a hot backup with rman without a catalog?

[marist89]

Originally posted by Latyr

One important thing to know RMAN can not backup its own catalog.

Why not? Use rman with nocatalog option and keep details in the control file.