Amigo,
agracedeço muito a sua ajuda.
Muito obrigado. Ta aí o alert.log
Eduardo
Thu Jun 28 15:59:37 2007
Starting control autobackup
Control autobackup written to DISK device
handle '/oracle/products/10.2.0/db_1/dbs/c-4039426532-20070628-09'
Completed: alter tablespace "CONTAS_PUBLICAS_T" offline immediate
Thu Jun 28 15:59:42 2007
The input backup piece /u01/orclbackup/5likn3o7_1_1 is in compressed format.
Thu Jun 28 16:03:24 2007
Full restore complete of datafile 12
/u01/oradata/cjfdes/CONTAS_PUBLICAS_t01.dbf. Elapsed time: 0:00:04
checkpoint is 4843218
Thu Jun 28 16:04:25 2007
ALTER TABLESPACE "CONTAS_PUBLICAS_T" ONLINE
Thu Jun 28 16:04:25 2007
ORA-1113 signalled during: ALTER TABLESPACE "CONTAS_PUBLICAS_T" ONLINE...
Thu Jun 28 16:05:51 2007
alter tablespace "CONTAS_PUBLICAS_T" online
Thu Jun 28 16:05:51 2007
ORA-1113 signalled during: alter tablespace "CONTAS_PUBLICAS_T" online...
Thu Jun 28 16:15:05 2007
Thread 1 cannot allocate new log, sequence 604
Private strand flush not complete
Current log# 2 seq# 603 mem# 0: /u01/oradata/cjfdes/redo02.log
Thread 1 advanced to log sequence 604
Current log# 3 seq# 604 mem# 0: /u01/oradata/cjfdes/redo03.log
Thread 1 cannot allocate new log, sequence 605
Private strand flush not complete
Current log# 3 seq# 604 mem# 0: /u01/oradata/cjfdes/redo03.log
Thread 1 advanced to log sequence 605
Current log# 1 seq# 605 mem# 0: /u01/oradata/cjfdes/redo01.log
Thu Jun 28 16:15:14 2007
Starting control autobackup
Control autobackup written to DISK device
handle '/oracle/products/10.2.0/db_1/dbs/c-4039426532-20070628-0a'
Thu Jun 28 16:15:45 2007
The input backup piece /u01/orclbackup/9gil9icc_1_1 is in compressed format.
Thu Jun 28 16:19:55 2007
alter tablespace "CONTAS_PUBLICAS_T" online
Thu Jun 28 16:19:55 2007
ORA-1113 signalled during: alter tablespace "CONTAS_PUBLICAS_T" online...
Thu Jun 28 16:20:37 2007
The input backup piece /u01/orclbackup/9gil9icc_1_1 is in compressed format.
Thu Jun 28 16:24:15 2007
Full restore complete of datafile 12
/u01/oradata/cjfdes/CONTAS_PUBLICAS_t01.dbf. Elapsed time: 0:00:04
checkpoint is 65938701
Thu Jun 28 16:24:23 2007
alter tablespace "CONTAS_PUBLICAS_T" online
Thu Jun 28 16:24:23 2007
ORA-1113 signalled during: alter tablespace "CONTAS_PUBLICAS_T" online...
Thu Jun 28 17:00:54 2007
alter database recover datafile 12
Media Recovery Start
ORA-279 signalled during: alter database recover datafile 12...
Thu Jun 28 17:12:50 2007
*************************************************************
Warning: Recovery session ended without issuing ALTER DATABASE RECOVER
CANCEL
*************************************************************
Thu Jun 28 17:14:19 2007
Thu Jun 28 17:14:19 2007
alter tablespace "CONTAS_PUBLICAS_T" online
Thu Jun 28 17:14:19 2007
ORA-1113 signalled during: alter tablespace "CONTAS_PUBLICAS_T" online...
Thu Jun 28 17:14:54 2007
alter tablespace "CONTAS_PUBLICAS_T" offline immediate
Thu Jun 28 17:14:54 2007
Starting control autobackup
Control autobackup written to DISK device
handle '/oracle/products/10.2.0/db_1/dbs/c-4039426532-20070628-0b'
Completed: alter tablespace "CONTAS_PUBLICAS_T" offline immediate
Thu Jun 28 17:14:57 2007
alter database recover datafile 12
Media Recovery Start
ORA-279 signalled during: alter database recover datafile 12...
Thu Jun 28 17:14:57 2007
alter database recover cancel
Thu Jun 28 17:14:57 2007
Media Recovery Canceled
Completed: alter database recover cancel
Thu Jun 28 17:15:04 2007
Thread 1 cannot allocate new log, sequence 606
Private strand flush not complete
Current log# 1 seq# 605 mem# 0: /u01/oradata/cjfdes/redo01.log
Thread 1 advanced to log sequence 606
Current log# 2 seq# 606 mem# 0: /u01/oradata/cjfdes/redo02.log
Thread 1 cannot allocate new log, sequence 607
Private strand flush not complete
Current log# 2 seq# 606 mem# 0: /u01/oradata/cjfdes/redo02.log
Thread 1 advanced to log sequence 607
Current log# 3 seq# 607 mem# 0: /u01/oradata/cjfdes/redo03.log
Thu Jun 28 17:15:12 2007
Starting control autobackup
Control autobackup written to DISK device
handle '/oracle/products/10.2.0/db_1/dbs/c-4039426532-20070628-0c'
Thu Jun 28 17:38:13 2007
ALTER DATABASE RECOVER datafile 12
Thu Jun 28 17:38:13 2007
Media Recovery Start
ORA-279 signalled during: ALTER DATABASE RECOVER datafile 12 ...
Thu Jun 28 17:38:20 2007
ALTER DATABASE RECOVER CONTINUE DEFAULT
Thu Jun 28 17:38:20 2007
Media Recovery Log /u01/archlog/1_552_623218471.dbf
Errors with log /u01/archlog/1_552_623218471.dbf
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Thu Jun 28 17:38:20 2007
ALTER DATABASE RECOVER CANCEL
Thu Jun 28 17:38:20 2007
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
Thu Jun 28 17:39:14 2007
alter tablespace "CONTAS_PUBLICAS_T" offline immediate
Thu Jun 28 17:39:14 2007
Starting control autobackup
On 6/29/07, Ricardo Marques Silvério <[EMAIL PROTECTED]> wrote:
>
> copie o trecho do alert.log que trata deste restore.
>
[As partes desta mensagem que não continham texto foram removidas]
