Random Posts
Blog Archive
ORACLE DBA
Search This Blog
Blog Archive
Thirupal Boreddy. Powered by Blogger.
My Blog List
Followers
Lorem 1
Technology
Circle Gallery
‹
›
Shooting
Racing
News
Lorem 4
Startup nomount
run
{
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/u01/app/oracle/admin/tsm_rman/_tdpo.opt)';
set until time "TO_DATE('04/OCT/2011 11:10:00 ','DD/MON/YYYY HH24:MI:SS')";
restore controlfile;
release channel t1;
}
alter database mount;
$date
run
{
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/u01/app/oracle/admin/tsm_rman/_tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/u01/app/oracle/admin/tsm_rman/_tdpo.opt)';
set until time "TO_DATE('04/OCT/2011 11:10:00 ','DD/MON/YYYY HH24:MI:SS')";
restore database;
recover database;
release channel t1;
release channel t2;
}
alter database open resetlogs;
run
{
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/u01/app/oracle/admin/tsm_rman/
set until time "TO_DATE('04/OCT/2011 11:10:00 ','DD/MON/YYYY HH24:MI:SS')";
restore controlfile;
release channel t1;
}
alter database mount;
$date
run
{
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/u01/app/oracle/admin/tsm_rman/
allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/u01/app/oracle/admin/tsm_rman/
set until time "TO_DATE('04/OCT/2011 11:10:00 ','DD/MON/YYYY HH24:MI:SS')";
restore database;
recover database;
release channel t1;
release channel t2;
}
alter database open resetlogs;
Restore Database
run {
allocate channel ch1 type 'SBT_TAPE' MAXOPENFILES 1 parms 'ENV=(NB_ORA_CLIENT=, NB_ORA_POLICY=, NB_ORA_SCHED=Schedule Name)';
BACKUP ARCHIVELOG FROM SEQUENCE 3863 UNTIL SEQUENCE 3970 DELETE INPUT;
release channel ch1;
}
allocate channel ch1 type 'SBT_TAPE' MAXOPENFILES 1 parms 'ENV=(NB_ORA_CLIENT=
BACKUP ARCHIVELOG FROM SEQUENCE 3863 UNTIL SEQUENCE 3970 DELETE INPUT;
release channel ch1;
}
Archive log backup with Log sequence
Subscribe to:
Comments (Atom)
QUERY FOR CPU USAGE
select a.target_name as HOST, to_char(a.rollup_timestamp,' dd-Mon-yy::hh24:mi') as "DAY-TIME", sum(c.cpu_count) as ...