Restoring Production server backup on Testing server

[Former Member]

Dear Friends,

We are using BRtools for taking Backup in our production servers. We want to restore our production server backup to our testing server which is working in the same network.

We tried brrestore command and we got success in restoring database backup, but we got an error while restoring archive backup.

Error : ORA-283 recovery session canceled due to errors.

We need a help to fix this error.

Thanks in advance.

G.G. Karthickbabu

[Former Member]

Hi,

Recreate control file and try to do recovery and open the database.

Regards,

Sachin Rane.

[former_member204746]

check alert_SID.log file for more details.

[Former Member]

Eric Brunelle,

Thanks for your earliest reply.

We already checked that log.

Log details given below:

Fri Mar 20 11:13:42 2009

Adjusting the default value of parameter parallel_max_servers

from 80 to 65 due to the value of parameter processes (80)

Fri Mar 20 11:13:42 2009

Starting ORACLE instance (normal)

Fri Mar 20 11:13:42 2009

Specified value of sga_max_size is too small, bumping to 1358954496

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

IMODE=BR

ILAT =10

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.2.0.

System parameters with non-default values:

processes = 80

sessions = 96

event = 10191 trace name context forever, level 1

sga_max_size = 1358954496

shared_pool_size = 654311424

shared_pool_reserved_size= 64408780

filesystemio_options = setall

control_files = E:\ORACLE\Q00\ORIGLOGA\CNTRL\CNTLRQ00.DBF, E:\ORACLE\Q00\ORIGLOGB\CNTRL\CNTRLQ00.DBF, E:\ORACLE\Q00\SAPDATA1\CNTRL\CNTRLQ00.DBF

control_file_record_keep_time= 30

db_block_size = 8192

db_cache_size = 654311424

compatible = 10.2.0

log_archive_dest = E:\oracle\Q00\oraarch\Q00arch

log_buffer = 14274560

log_checkpoint_interval = 0

db_files = 254

log_checkpoints_to_alert = TRUE

dml_locks = 4000

undo_management = AUTO

undo_tablespace = PSAPUNDO

undo_retention = 43200

recyclebin = off

remote_os_authent = TRUE

remote_login_passwordfile= EXCLUSIVE

job_queue_processes = 1

background_dump_dest = E:\ORACLE\Q00\SAPTRACE\BACKGROUND

user_dump_dest = E:\ORACLE\Q00\SAPTRACE\USERTRACE

core_dump_dest = E:\ORACLE\Q00\SAPTRACE\BACKGROUND

optimizer_features_enable= 10.2.0.1

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = Q00

open_cursors = 800

optimpeek_user_binds = FALSE

pga_aggregate_target = 629145600

workarea_size_policy = AUTO

statistics_level = typical

PMON started with pid=2, OS id=980

PSP0 started with pid=3, OS id=2100

MMAN started with pid=4, OS id=592

DBW0 started with pid=5, OS id=2868

LGWR started with pid=6, OS id=1696

CKPT started with pid=7, OS id=2480

SMON started with pid=8, OS id=2776

RECO started with pid=9, OS id=540

CJQ0 started with pid=10, OS id=908

MMON started with pid=11, OS id=2680

MMNL started with pid=12, OS id=1788

Fri Mar 20 11:13:43 2009

ALTER DATABASE MOUNT

Fri Mar 20 11:13:48 2009

Setting recovery target incarnation to 1

Fri Mar 20 11:13:48 2009

Successful mount of redo thread 1, with mount id 1544563303

Fri Mar 20 11:13:48 2009

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Fri Mar 20 11:13:49 2009

ALTER DATABASE OPEN

ORA-1589 signalled during: ALTER DATABASE OPEN...

Fri Mar 20 11:15:09 2009

ALTER DATABASE RECOVER database using backup controlfile until cancel

Fri Mar 20 11:15:09 2009

Media Recovery Start

Fri Mar 20 11:15:10 2009

Media Recovery failed with error 1110

ORA-283 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...

Fri Mar 20 11:16:02 2009

alter database open resetlogs

Fri Mar 20 11:16:02 2009

ORA-1122 signalled during: alter database open resetlogs...

Fri Mar 20 11:27:46 2009

ALTER DATABASE RECOVER standby database

Fri Mar 20 11:27:46 2009

Media Recovery Start

Fri Mar 20 11:27:46 2009

Media Recovery failed with error 1665

ORA-283 signalled during: ALTER DATABASE RECOVER standby database ...

Please help us to fix this problem.

Regs,

G.G.Karthickbabu

[Former Member]

Try to read

Regards.

[Former Member]

Hi,

Completed: ALTER DATABASE MOUNT
Fri Mar 20 11:13:49 2009
ALTER DATABASE OPEN
ORA-1589 signalled during: ALTER DATABASE OPEN...
Fri Mar 20 11:15:09 2009
ALTER DATABASE RECOVER database using backup controlfile until cancel 
Fri Mar 20 11:15:09 2009
Media Recovery Start

Please do not open the database until recovery is completed. Then finally open the database with resetlogs.

Hope this helps.

Manoj