PDA

View Full Version : Return code = 433


Tom Tay
07-06-2012, 05:58 PM
After adding datafiles at primary server and running dbvisit oracle_database command at primary server


Encountered this problem when running dbvisit oracle_database command at standby server


==> Scheduler message sent.
New datafile(s) have been added to the primary database.
Dbvisit will recreate standby controlfile.
Starting Standby Database oracle_database...
Standby Database oracle_database started nomount
201207061326 - ORA-01507: database not mounted
Dbvisit Standby terminated.
Return code = 433

Please advise
Thanks

Arjen Visser
07-06-2012, 09:14 PM
Hi Tom,
What version of Dbvisit Standby are you running?

Can you try startting the standby database on the standby server with command:
dbv_oraStartStop start oracle_database

If this is not successful, there will be more information in the trace file as to why the standby database could not be mounted. The trace file is usually in /usr/tmp and ends with .trc.
You can grep for the word "ORA-01507: database not mounted".

Tom Tay
07-07-2012, 04:14 PM
The dbvisit version is 6.0.30.8890

$ dbv_oraStartStop start oracle_database
================================================== ===========
Dbvisit Standby Database Technology (6.0.30.8890) (pid 458940)
dbv_oraStartStop started on oracle_database
: Sat Jul 7 11:44:41 2012 ()
================================================== ===========

Database oracle_database
on oracle_database
is already started. Please shut it down first.

From trc log,20120707 11:43:00 main::cmn_cat-> SQL> SQL> SQL> SQL> select name, controlfile_type,open_mode from v$database
20120707 11:43:00 main::cmn_cat-> *
20120707 11:43:00 main::cmn_cat-> ERROR at line 1:
20120707 11:43:00 main::cmn_cat-> ORA-01507: database not mounted


In there is error at line1
select name, controlfile_type,open_mode from v$database

Thks
*

Tom Tay
07-07-2012, 04:16 PM
Additional Information

The line error stop at "controlfile_type"

Arjen Visser
07-07-2012, 08:26 PM
It looks like the standby database is started, so try a restart:

dbv_oraStartStop restart oracle_database

Is there enough disk space on the standby server to add the new datafile?

Tom Tay
07-07-2012, 10:43 PM
Already restart as shown and enough diskspace.
But still encountered same problem

dbv_oraStartStop restart oracle_database=================================== ==========================
Dbvisit Standby Database Technology (6.0.30.8890) (pid 372832)
dbv_oraStartStop started on standby2 : Sat Jul 7 18:28:51 2012 ()
================================================== ===========

Shutting down standby Database oracle_database ...
Standby Database oracle_database shutdown successfully.
Starting Standby Database oracle_database...
Standby Database oracle_database started .

================================================== ===========
dbv_oraStartStop ended on standby2: Sat Jul 7 18:28:56 2012
================================================== ===========

$ dbvisit oracle_database=================================== ==========================
Dbvisit Standby Database Technology (6.0.30.8993) (pid 368694)
dbvisit started on standby2: Sat Jul 7 18:29:52 2012 ()
================================================== ===========

Log file(s) for oracle_database from primary1 will be applied to standby2...
New datafile(s) have been added to the primary database.
Dbvisit will recreate standby controlfile.
Starting Standby Database oracle_database...
Standby Database oracle_database started nomount.
201207071829 - ORA-01507: database not mounted
Dbvisit Standby terminated.
Return code = 433

(Tracefile required if contacting Dbvisit Standby support:
/usr/tmp/368694_dbvisit_oracle_database_201207071829.trc (server:standby2))
$

Arjen Visser
07-07-2012, 11:36 PM
Can you upload the trace file /usr/tmp/368694_dbvisit_oracle_database_201207071829.trc (server:standby2)

Thanks

Tom Tay
07-08-2012, 02:55 AM
Here is the attachment

368694_dbvisit_HCAPLIVE_201207071829.trc

Please advise .

Thks

Arjen Visser
07-08-2012, 07:29 PM
Thanks for the trace file. There is an issue with the RMAN showall command on Oracle 9i in your environment and this is preventing Dbvisit Standby from restoring the controlfile. This will be fixed in the next release.

The current workaround is to manually restore the new standby ctl file that has been shipped to standby. This file should be present on standby as /usr/local/dbvisit/logs/standby_HCAPLIVE.ctl

Steps to perform on standby
====
SQL>shutdown abort;
SQL>startup nomount;

>rman nocatalog
RMAN>connect target /
run {
allocate channel c1 type disk;
restore controlfile from '/usr/local/dbvisit/logs/standby_HCAPLIVE.ctl';
release channel c1;
}

Then restart the standby database
====
dbv_oraStartStop restart HCAPLIVE

Tom Tay
07-08-2012, 09:07 PM
After running the given steps as shown, I am still having same problem.

Please help.
Thanks

SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

RMAN> connect target /

connected to target database: HCAPLIVE (not mounted)
using target database controlfile instead of recovery catalog

RMAN> connect target /
run {
allocate channel c1 type disk;
restore controlfile from '/usr/local/dbvisit/logs/standby_HCAPLIVE.ctl';
release channel c1;
}


RMAN-00571: ================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ================================================== =========
RMAN-06167: already connected

RMAN> 2> 3> 4> 5>
allocated channel: c1
channel c1: sid=11 devtype=DISK

Starting restore at 08-JUL-12

channel c1: restoring controlfile
channel c1: restore complete
replicating controlfile
input filename=/oracle/HCAPLIVE/redo1/control01.ctl
output filename=/oracle/HCAPLIVE/redo2/control02.ctl
Finished restore at 08-JUL-12

released channel: c1

RMAN>
RMAN> exit

Anna Macnaughtan
07-08-2012, 09:14 PM
Apologies, one more step is required - you need to delete the standby controlfile shipped by Dbvisit from the primary. Otherwise Dbvisit detects the file and attempts to recreate it again:

rm /usr/local/dbvisit/logs/standby_HCAPLIVE.ctl

Then run "dbv_oraStartStop restart HCAPLIVE" on the standby to restart your standby, and run Dbvisit again.

Tom Tay
07-08-2012, 09:39 PM
I have encountered "Return code = 488"


Please help
Thks

$ dbv_oraStartStop restart HCAPLIVE


$ dbvisit HCAPLIVE
================================================== ===========
Dbvisit Standby Database Technology (6.0.30.8993) (pid 274684)
dbvisit started on hcsps2: Sun Jul 8 17:27:00 2012 ()
================================================== ===========

Log file(s) for HCAPLIVE from HCSPS1 will be applied to hcsps2...
201207081726 - Some datafiles may be corrupted or not renamed in the
controlfile. Consult v$_datafile and v$_datafile_header views and verify if the
following datafiles are present on the server:
file#=116
v_datafile.name=/hcap_data/CIM_TABSP1_037.dbf
v_datafile.checkpoint_change=1531736302
v_datafile.bytes=0
v_datafile_header.name=
v_datafile_header.checkpoint_change=0
v_datafile_header.bytes=0
, else please contact Dbvisit support.
Dbvisit Standby terminated.
Return code = 488

Anna Macnaughtan
07-08-2012, 10:24 PM
To add a new datafile to the standby database please run:
>sqlplus / as sysdba
SQL> alter database create datafile '/hcap_data/CIM_TABSP1_037.dbf' as '/hcap_data/CIM_TABSP1_037.dbf';

Then run Dbvisit on the standby to apply archive logs.

Tom Tay
07-08-2012, 10:26 PM
Additional information
I think that it is the new datafile added at the primary server.

Anna Macnaughtan
07-08-2012, 10:49 PM
Yes the datafile /hcap_data/CIM_TABSP1_037.dbf has been added to the primary database. The new standby control file now contains a record of this file. You need to create this file in the standby database manually by running the command:
SQL>alter database create datafile '/hcap_data/CIM_TABSP1_037.dbf' as '/hcap_data/CIM_TABSP1_037.dbf';

Tom Tay
07-09-2012, 12:07 AM
Yes.. It is solved.

Thank for the help.