Database - RAC/Scalability (MOSC)

MOSC Banner

Standy Database clinprt fail to add temp files

edited Sep 4, 2017 5:03AM in Database - RAC/Scalability (MOSC) 5 commentsAnswered

After we have cloned prod to ROPROD using the cerner scripts, the database(ROPROD) will not let us add Temp files to the temp tablespace.

Error Code/Message: Database error: ORA-01157: cannot identify/lock data file 4097 - see DBWR trace file ORA-01110: data

Connected as sysdba in read-only mode

SQL>

ALTER TABLESPACE TEMP ADD TEMPFILE '+DG_CISRPT_REDO_01' SIZE 500M AUTOEXTEND ON NEXT 250M MAXSIZE 30720M;

ORA-00604: error occurred at recursive SQL level 1

ORA-16000: database open for read-only access

ORA-06512: at line 1066

ORA-16000: database open for read-only access

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center