![]() RMAN> configure channel device type ‘SBT_TAPE’Ģ> parms ‘ENV=(NB_ORA_CLIENT=myserver01),SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64’ Today though, I came across a post referring to an undocumented method of performing the needed actions with a tape backup.Įssentially, one just needs to configure a tape channel and run the command. Unfortunately, all Oracle references I have found only provide instructions for disk backups. Which, though I find the usage of “catalog” a bit unfortunate given the fact that there is also a repository referred to as a “catalog”, the command is quite handy. The CATALOG command enables you to add records about RMAN and user-managed backups that are currently not recorded in the RMAN repository, or to remove records for backups that are recorded. Posted in 10gR2, 11g, 11gR2, 9i, errors, note to self | Tagged cursors, ORA-1000, oracle open cursors | Leave a Comment » Note that using a query that doesn’t specify ‘opened cursors current’ such as one that pulls data from v$open_cursor will provide cached cursors as well thus giving a misleading answer. This can be altered to focus in on a single user:įrom v$sesstat a, v$statname b, v$open_cursor c *sigh*Ī note to self post for queries to use to check cursor counts presently in use and to troubleshoot ORA-1000: maximum open cursors exceeded: For him, the following purge worked:īut the data remained and thus the datafile still wouldn’t resize.Īnd the datafile resized with ease. ![]() Which says that things don’t always show in dba_extents, one must also check dba_segments – which showed the bin remnants of prior objects.Īh yes, flashback. Puzzled, I went to master Google and found this post by Connor McDonald: ![]() Select owner, segment_name, segment_type from dba_extents where tablespace_name=’MY_TABLESPACE’ ORA-03297: file contains used data beyond requested RESIZE value ORA-06502: PL/SQL: numeric or value error ORA-00604: error occurred at recursive SQL level 1 In reality, the tablespace could be dropped as it is no longer in use, but we’ll be using it again soon so I just wanted to reclaim a large portion of space.Īlter database datafile ‘/u02/mydatafile.dbf’ resize 1000m Doing some cleaning and relocating shrunk this down to what should be zero. The short history is that we have a tablespace that was filled with 150G.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |