IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
When I run Restore step for Oracle XTTS V4, i got ” Error in executing xttstartupnomount.sql ” absurd error.
If you want to learn NEW Oracle XTTS V4 Cross platform database migration utility, you can read following article.
https://ittutorial.org/new-oracle-xtts-v4-reduce-transportable-tablespace-downtime-using-cross-platform-incremental-backup/
Error was taken in this Restore step.
[DEVECI]/backup/v4ttsTarget $> $ORACLE_HOME/perl/bin/perl xttdriver.pl --restore
============================================================
trace file is /backup/v4ttsTarget/restore_Oct8_Tue_11_15_30_701//Oct8_Tue_11_15_30_701_.log
=============================================================
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Start rollforward
--------------------------------------------------------------------
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.
Total System Global Area 8.5516E+10 bytes
Fixed Size 2262656 bytes
Variable Size 1.4764E+10 bytes
Database Buffers 7.0599E+10 bytes
Redo Buffers 151117824 bytes
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Error:
------
Error in executing xttstartupnomount.sql
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
[DEVECI]/backup/v4ttsTarget $
To solve this problem, You should remove remote_os_authent, background_dump_dest and user_dump_dest parameter in the parameter file (Pfile or SPFile), then Restart database.
SQL> alter system reset remote_os_authent scope=spfile; System altered. SQL> alter system reset background_dump_dest scope=spfile; System altered. SQL> alter system reset user_dump_dest scope=spfile; System altered. SQL>
After database Restart, try Run Restore step again. Problem will be solved.
nohup $ORACLE_HOME/perl/bin/perl xttdriver.pl --restore &
============================================================ trace file is /backup/v4ttsTarget/restore_Oct8_Tue_23_37_02_565//Oct8_Tue_23_37_02_565_.log ============================================================= -------------------------------------------------------------------- Parsing properties -------------------------------------------------------------------- -------------------------------------------------------------------- Done parsing properties -------------------------------------------------------------------- -------------------------------------------------------------------- Checking properties -------------------------------------------------------------------- -------------------------------------------------------------------- Done checking properties -------------------------------------------------------------------- -------------------------------------------------------------------- Start rollforward -------------------------------------------------------------------- -------------------------------------------------------------------- End of rollforward phase -------------------------------------------------------------------- [MehmetSalihTarget]/backup/v4ttsTarget $
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/
