1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Help about Oracle Database 10g Express Edition

Discussion in 'General' started by quailan, Aug 31, 2010.

  1. quailan

    quailan Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi All,

    - I use GRID Software then cannot access localhost:8080/apex
    I check then the services run :

    OracleMTSRecoveryService
    OracleServiceXE
    OracleXEClrAgent

    - I run backup then :

    - Help me, I want to backup database then restore on new PC.
    - I down Oracle Enterprise Manager 10g Grid Control to Manager (such as Backup, Restore) but I don't know about use it

    Pls help me, thanks so much :p
     
  2. quailan

    quailan Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    I view log then :

    Recovery Manager: Release 10.2.0.1.0 - Production on Tue Aug 31 13:46:11 2010

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Windows XP Version V5.1 Service Pack 2
    CPU : 2 - type 586
    Process Affinity : 0x00000000
    Memory (Avail/Total): Ph:620M/1015M, Ph+PgF:1911M/2442M, VA:2003M/2047M
    Starting with debugging turned off

    connected to target database: XE (DBID=2590949078, not open)

    RMAN> set echo on;
    2> shutdown immediate;
    3> startup mount;
    4> configure controlfile autobackup format for device type disk clear;
    5> configure retention policy to redundancy 2;
    6> configure controlfile autobackup on;
    7> sql "create pfile=''C:\ORACLEXE\ORADATA\XE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SPFILE2INIT.ORA'' from spfile";
    8> backup as backupset device type disk database;
    9> configure controlfile autobackup off;
    10> alter database open;
    11> delete noprompt obsolete;
    12>
    echo set on

    using target database control file instead of recovery catalog
    database dismounted
    Oracle instance shut down

    connected to target database (not started)
    Oracle instance started
    database mounted

    Total System Global Area 285212672 bytes

    Fixed Size 1287016 bytes
    Variable Size 117443736 bytes
    Database Buffers 163577856 bytes
    Redo Buffers 2904064 bytes

    RMAN configuration parameters are successfully reset to default value

    new RMAN configuration parameters:
    CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
    new RMAN configuration parameters are successfully stored

    new RMAN configuration parameters:
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    new RMAN configuration parameters are successfully stored

    sql statement: create pfile=''C:\ORACLEXE\ORADATA\XE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SPFILE2INIT.ORA'' from spfile

    Starting backup at 31-AUG-10
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=35 devtype=DISK
    channel ORA_DISK_1: starting full datafile backupset
    channel ORA_DISK_1: specifying datafile(s) in backupset
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/31/2010 13:47:13
    RMAN-10035: exception raised in RPC:
    ORA-19583: conversation terminated due to error
    ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
    ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 651
    RMAN-10031: RPC Error: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.BACKUPDATAFILE

    Recovery Manager complete.

    Pls help me :( :( :(
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You cannot backup an open database in NOARCHIVELOG mode. If you startup and mount the database you can back it up with RMAN successfully so remove the 'alter database open;' statement and your backup should run.
     
    quailan likes this.