Home
All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

RE: RMAM duplicate database - until when?

Lawie, Duncan

2006-12-22

Replies:
I don't believe I can safely subtract one from the SCN and expect it to be in an existing log - and I get the same error as with the higher number
 
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 3 was not restored from a sufficiently old backup
ORA-01110: data file 3: '/data/oracle/TESTDBE30/u01/sysaux01.dbf'
 
Now that error doesn't make sense, as the file 3 has a higher SCN than 1 or 2 ...
 
SQL> select FILE#, CHECKPOINT_CHANGE# from v$datafile_header order by 1;
 
     FILE# CHECKPOINT_CHANGE#
---------- ------------------
         1           45670185
         2           45670185
         3           45670188
...
 
Note that recovery works if I use the checkpoint_change# for file 3.  But this database was pretty static when it was backed up.



From: Rajeev Prabhakar [mailto:rprabha01@gmail.com]
Sent: 21 December 2006 18:25
To: duncan.lawie@credit-suisse.com
Cc: oracle-l@freelists.org
Subject: Re: RMAM duplicate database - until when?

On your source db, get the scn info :
 
select max(next_change#)-1 from v$archived_log;
 
-Rajeev

 
On 12/21/06, Lawie, Duncan <duncan.lawie@credit-suisse.com> wrote:
List,

I'm suffering at the hands of the rman cloning code.

I'm doing a
"backup database incremental level zero plus archivelog"

I've shown an output from the "list backup" at the bottom of the email.

What I want to do is

run {
set until scn XXX
duplicate target database to TESTDBE30;
}

Where XXX is the last SCN in the backup.

How do I find this?

rc_backup_archivelog_details will tell me the next_change# of the archivelog - but that isn't the last SCN in the current file is it?


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4280    Incr 0  108.34M    DISK        00:00:51     20 Dec 11:37:23
       BP Key: 4286   Status: AVAILABLE  Compressed: YES  Tag: TAG20061220T113632
       Piece Name: /app/oracle/TESTRAC80/admin/rman/whole_db_online_backup_TESTRAC80_70_26i5duq0_1_1_20061220
List of Datafiles in backup set 4280
File LV Type Ckp SCN    Ckp Time        Name
---- -- ---- ---------- --------------- ----
1    0  Incr 45670185   20 Dec 11:36:33 /data/oracle/TESTRAC80/u01/system01.dbf
.
.
.
8    0  Incr 45670188   20 Dec 11:36:34 /data/oracle/TESTRAC80/u01/soeindex.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4306    27.50K     DISK        00:00:02     20 Dec 11:37:53
       BP Key: 4313   Status: AVAILABLE  Compressed: YES  Tag: TAG20061220T113742
       Piece Name: /app/oracle/TESTRAC80/admin/rman/whole_db_online_backup_TESTRAC80_72_28i5dusf_1_1_20061220

List of Archived Logs in backup set 4306
Thrd Seq     Low SCN    Low Time        Next SCN   Next Time
---- ------- ---------- --------------- ---------- ---------
1    3004    45670151   20 Dec 11:36:03 45670267   20 Dec 11:37:29

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4307    2.00K      DISK        00:00:02     20 Dec 11:37:53
       BP Key: 4314   Status: AVAILABLE  Compressed: YES  Tag: TAG20061220T113742
       Piece Name: /app/oracle/TESTRAC80/admin/rman/whole_db_online_backup_TESTRAC80_73_29i5dusf_1_1_20061220

List of Archived Logs in backup set 4307
Thrd Seq     Low SCN    Low Time        Next SCN   Next Time
---- ------- ---------- --------------- ---------- ---------
2    2952    45670149   20 Dec 11:34:03 45670270   20 Dec 11:35:31

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4323    Full    15.98M     DISK        00:00:02     20 Dec 11:38:00
       BP Key: 4325   Status: AVAILABLE  Compressed: NO  Tag: TAG20061220T113758
       Piece Name: /app/oracle/TESTRAC80/admin/rman/whole_db_online_backup_TESTRAC80_c-2618574194-20061220-02
Control File Included: Ckp SCN: 45670323     Ckp time: 20 Dec 11:37:58
SPFILE Included: Modification time: 14 Dec 19:11:16

Duncan Lawie
DBE - Oracle
020 788 3 9229
"Problems cannot be solved at the same level of awareness that created them." -- Albert Einstein

==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

--
http://www.freelists.org/webpage/oracle-l



==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================