in Oracle 11g
ORA-00600: internal error code, arguments: [kzsviver:1], [], [], [], [], [],
alter user xyz identified by values is null in pl sql block <<<<<<<<
example .....
my_text :=
'Alter user '
|| pwd.username
|| ' identified by values '
|| ''''
|| l_old_password
|| '''';
-- dbms_output.put_line(my_text);
EXECUTE IMMEDIATE (my_text);
Search This Blog
Total Pageviews
Thursday, 19 May 2011
Validate corruption via RMAN 11g
oracle@apt-amd-02:~> rman
Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 19 09:31:35 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /
connected to target database: ORCL (DBID=1267852645)
RMAN> validate database check logical;
Starting validate at 19-MAY-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=58 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00002 name=/opt/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00001 name=/opt/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00003 name=/opt/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00004 name=/opt/app/oracle/oradata/orcl/users01.dbf
input datafile file number=00005 name=/opt/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00008 name=/opt/app/oracle/oradata/orcl/tsapexu01.dbf
input datafile file number=00007 name=/opt/app/oracle/oradata/orcl/tsapexf01.dbf
input datafile file number=00006 name=/opt/app/oracle/oradata/orcl/anujtest.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:02:06
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 14032 101125 9202958
File Name: /opt/app/oracle/oradata/orcl/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 69631
Index 0 13990
Other 0 3467
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2 OK 0 22319 106254 9202956
File Name: /opt/app/oracle/oradata/orcl/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 27420
Index 0 25986
Other 0 30515
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 OK 0 1 28800 9202958
File Name: /opt/app/oracle/oradata/orcl/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 28799
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4 OK 0 1710 27200 9178356
File Name: /opt/app/oracle/oradata/orcl/users01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 23370
Index 0 1357
Other 0 763
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 0 1689 12804 9089116
File Name: /opt/app/oracle/oradata/orcl/example01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6607
Index 0 1261
Other 0 3243
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 328 1280 7522828
File Name: /opt/app/oracle/oradata/orcl/anujtest.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 803
Index 0 0
Other 0 149
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7 OK 0 6273 6400 8527760
File Name: /opt/app/oracle/oradata/orcl/tsapexf01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8 OK 0 2648 12800 8826300
File Name: /opt/app/oracle/oradata/orcl/tsapexu01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 4606
Index 0 2615
Other 0 2931
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
including current control file for validation
including current SPFILE in backup set
channel ORA_DISK_1: validation complete, elapsed time: 00:00:02
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE OK 0 2
Control File OK 0 600
Finished validate at 19-MAY-11
RMAN>
Recovery Manager complete.
oracle@apt-amd-02:~> !sql
sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 19 09:38:41 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SELECT * FROM v$database_block_corruption;
no rows selected
Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 19 09:31:35 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /
connected to target database: ORCL (DBID=1267852645)
RMAN> validate database check logical;
Starting validate at 19-MAY-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=58 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00002 name=/opt/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00001 name=/opt/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00003 name=/opt/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00004 name=/opt/app/oracle/oradata/orcl/users01.dbf
input datafile file number=00005 name=/opt/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00008 name=/opt/app/oracle/oradata/orcl/tsapexu01.dbf
input datafile file number=00007 name=/opt/app/oracle/oradata/orcl/tsapexf01.dbf
input datafile file number=00006 name=/opt/app/oracle/oradata/orcl/anujtest.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:02:06
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 14032 101125 9202958
File Name: /opt/app/oracle/oradata/orcl/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 69631
Index 0 13990
Other 0 3467
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2 OK 0 22319 106254 9202956
File Name: /opt/app/oracle/oradata/orcl/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 27420
Index 0 25986
Other 0 30515
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 OK 0 1 28800 9202958
File Name: /opt/app/oracle/oradata/orcl/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 28799
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4 OK 0 1710 27200 9178356
File Name: /opt/app/oracle/oradata/orcl/users01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 23370
Index 0 1357
Other 0 763
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 0 1689 12804 9089116
File Name: /opt/app/oracle/oradata/orcl/example01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6607
Index 0 1261
Other 0 3243
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 328 1280 7522828
File Name: /opt/app/oracle/oradata/orcl/anujtest.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 803
Index 0 0
Other 0 149
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7 OK 0 6273 6400 8527760
File Name: /opt/app/oracle/oradata/orcl/tsapexf01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8 OK 0 2648 12800 8826300
File Name: /opt/app/oracle/oradata/orcl/tsapexu01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 4606
Index 0 2615
Other 0 2931
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
including current control file for validation
including current SPFILE in backup set
channel ORA_DISK_1: validation complete, elapsed time: 00:00:02
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE OK 0 2
Control File OK 0 600
Finished validate at 19-MAY-11
RMAN>
Recovery Manager complete.
oracle@apt-amd-02:~> !sql
sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 19 09:38:41 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SELECT * FROM v$database_block_corruption;
no rows selected
Subscribe to:
Posts (Atom)
Oracle DBA
anuj blog Archive
- ▼ 2011 (362)