Can not startup Oracle using RMAN after a shutdown ?

[hungng89]

Hi Everyone
I just install TDP for ORACLE 5.4

RMAN> run
2> {
3> allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> backup database;
5> }

allocated channel: t1
channel t1: sid=318 instance=PROD1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0

Starting backup at 12-NOV-10
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on t1 channel at 11/12/2010 12:39:57
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel t1: starting piece 1 at 12-NOV-10
channel t1: finished piece 1 at 12-NOV-10
piece handle=19lsqlst_1_1 tag=TAG20101112T123956 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:01:07
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on t1 channel at 11/12/2010 12:39:57
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

From some advices on the www
i try to shut down the database

RMAN> shutdown
^C
user interrupt received
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of shutdown command at 11/12/2010 12:52:34
ORA-01013: user requested cancel of current operation

It take so long so i cancel the current operation and retry shutdown immediate , and try to startup mount;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of shutdown command at 11/12/2010 12:52:46
ORA-01012: not logged on

RMAN> startup mount;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 11/12/2010 12:53:22
ORA-01012: not logged on

But i can't shutdown or startup the database

Does any one has some advices ?

Thanks and Best regards

 

[hogmaster]

Hi
Not being a oracle expert at all, but the information in your post suggests that the firts backup was run with a database that was not in archivelog mode. the DB does not allow a backup to be done if it can not be used for restore.
Further more the shutdown you did without a working logfile means that Oracle db is not allowed to start because it can not determine the state of the db.
No data is lost (yet).
Contact a Oracle DBA and he can sort this out, It is not too complicated. however I do belive that you need help from a DBA before you lose data.

Good luck