Find a Large files in Solaris 10

# find /ssaerp/bse/tmp -type f -size +2000000k



/ssaerp/bse/tmp/tmp037818494
/ssaerp/bse/tmp/tmp058108092
/ssaerp/bse/tmp/tmp066170195
/ssaerp/bse/tmp/tmp014385733




# du -h /ssaerp/bse/tmp/tmp037818494
 1.1G   /ssaerp/bse/tmp/tmp037818494



# rm   /ssaerp/bse/tmp/tmp037818494

Magazine Locked By Host System

In backup exec, go under devices tab,


select your tape drive from the list and right-click it with mouse. There should be an option "unlock" or "unlock device".

When you select this, backup exec will send info for tape drive to unlock itself.

After this go to tape drive itself, and select unlock right/left magazine under "operations"

This is handy tool for making tape drive more secure.

Backup exec 2010 job in Queued

   Windows Server 2008

    Backup Exec 2010

Queued State means Backup Exec is not able to communicate with the Tape Library OR the Drive.

1  : Restart BE Services.
2  : Go to the Media TAB
3  : Right Click on the Drive and disable it, right click and delete it. Follow this step on all the Drives and the Medium changer.
4  : Restart Backup Exec Services.

We are forcing Backup Exec to see the TAPE Drives, also make sure that the TAPE Drives are listed in the Device Manager.

1  : Go to the Media TAB. Right click the Server Name and pause it, unpause it again after 4 to 5 seconds

Installation Windows 2012 Server on HP Blade System C7000

Go to Internet Explorer.

Login as Admin
Password

Click on Front View of Server

Click on iLO option

Perform Flashback Query

Restore Dropped Tables from the Recycle Bin

The recycle bin is enabled by default.

SQL> ALTER SYSTEM SET recyclebin = ON;

To disable for the entire database (not recommended):

SQL> ALTER SYSTEM SET recyclebin = OFF;

To enable the recycle bin for a session:

SQL> ALTER SESSION SET recyclebin = ON;

To disable the recycle bin for a session:

SQL> ALTER SESSION SET recyclebin = OFF;


Show recyclebin contents

To see the objects in the recyclebin:

SHOW RECYCLEBIN

Clear recyclebin

To remove all dropped objects from the recyclebin (current user):

PURGE RECYCLEBIN;

To remove all dropped objects from the recyclebin (system wide):

PURGE DBA_RECYCLEBIN;

Tables can also be droped without sending them to the recyclebin. Example:

DROP TABLE t1 PURGE;
Examples

Drop a table:

SQL> DROP TABLE t1;
      drop the table:

SQL> FLASHBACK TABLE t1 TO BEFORE DROP;

Migrating SQL Server to Oracle 11.2 using SQL Developer 3.2

Environment:

Microsoft SQL Server 2008
Oracle Database 11.2 on Linux 32-bit
SQL Developer 3.2


Download driver for JDBC.
http://www.oracle.com/technetwork/developer-tools/sql-developer/thirdparty-095608.html

Tools Menu --> Preferences --> Database -->Third Party JDBC Drivers -->
add Entry --> C:\jdbc\jtds-1.2.jar