Oracle Recovery - Cronologia

WikiSysop il 08:28, 22 set 2017

2017-09-22T08:28:40Z

← Versione meno recente		Versione delle 08:28, 22 set 2017
Riga 52:		Riga 52:
	---------------------------------------------------------------------------------------------------------------------		---------------------------------------------------------------------------------------------------------------------
	[[Categoria:Database]]		[[Categoria:Database]]
			[[Categoria:Oracle]]

WikiSysop il 10:48, 26 ott 2015

2015-10-26T10:48:41Z

← Versione meno recente		Versione delle 10:48, 26 ott 2015
Riga 24:		Riga 24:
	If you have no other backup of the control file except in a RMAN backup set, and you need the control file to perform a restore operation, use the following PL/SQL program to extract the control file from the backup set. Run this program from SQL*Plus while connected as SYSDBA to the target database:		If you have no other backup of the control file except in a RMAN backup set, and you need the control file to perform a restore operation, use the following PL/SQL program to extract the control file from the backup set. Run this program from SQL*Plus while connected as SYSDBA to the target database:

	<~~code~~>		<pre>
	DECLARE		DECLARE
	devtype varchar2(256);		devtype varchar2(256);
Riga 49:		Riga 49:
	END;		END;
	/		/
	</~~code~~>		</pre>
	---------------------------------------------------------------------------------------------------------------------		---------------------------------------------------------------------------------------------------------------------
	[[Categoria:Database]]		[[Categoria:Database]]

WikiSysop il 10:48, 26 ott 2015

2015-10-26T10:48:07Z

← Versione meno recente		Versione delle 10:48, 26 ott 2015
Riga 24:		Riga 24:
	If you have no other backup of the control file except in a RMAN backup set, and you need the control file to perform a restore operation, use the following PL/SQL program to extract the control file from the backup set. Run this program from SQL*Plus while connected as SYSDBA to the target database:		If you have no other backup of the control file except in a RMAN backup set, and you need the control file to perform a restore operation, use the following PL/SQL program to extract the control file from the backup set. Run this program from SQL*Plus while connected as SYSDBA to the target database:

			<code>
	DECLARE		DECLARE
	devtype varchar2(256);		devtype varchar2(256);
	done boolean;		done boolean;
	BEGIN		BEGIN
	devtype := dbms_backup_restore.deviceallocate('devtype', params=>'');		devtype := dbms_backup_restore.deviceallocate('devtype', params=>'');
	# Replace 'devtype' with the device type you used when creating the backup: NULL or		# Replace 'devtype' with the device type you used when creating the backup: NULL or
Riga 46:		Riga 47:
	# repeat the restorebackuppiece statement for each backup piece in the backup set.		# repeat the restorebackuppiece statement for each backup piece in the backup set.

	END;		END;
	/		/
			</code>

	---------------------------------------------------------------------------------------------------------------------		---------------------------------------------------------------------------------------------------------------------
	[[Categoria:Database]]		[[Categoria:Database]]

WikiSysop: /* restore from plsql */

2015-10-26T10:46:32Z

restore from plsql

← Versione meno recente		Versione delle 10:46, 26 ott 2015
Riga 14:		Riga 14:
	---------------------------------------------------------------------------------------------------------------------		---------------------------------------------------------------------------------------------------------------------

	Restoring the Control File from a Backup Set Without Using RMAN		Restoring the Control File from a Backup Set Without Using RMAN

	You must use a non-standard procedure to restore a control file from an RMAN backup set in the following situations:		You must use a non-standard procedure to restore a control file from an RMAN backup set in the following situations:

	You are using a pre-8.0.5 version of RMAN to restore a database when more than one database with the same name is registered in the recovery catalog (see "Restoring When Multiple Databases Share the Same Name" for a discussion of this problem).		You are using a pre-8.0.5 version of RMAN to restore a database when more than one database with the same name is registered in the recovery catalog (see "Restoring When Multiple Databases Share the Same Name" for a discussion of this problem).

	You are not using a recovery catalog, and your only control file backup is in an RMAN backup set.		You are not using a recovery catalog, and your only control file backup is in an RMAN backup set.

	If you have no other backup of the control file except in a RMAN backup set, and you need the control file to perform a restore operation, use the following PL/SQL program to extract the control file from the backup set. Run this program from SQL*Plus while connected as SYSDBA to the target database:		If you have no other backup of the control file except in a RMAN backup set, and you need the control file to perform a restore operation, use the following PL/SQL program to extract the control file from the backup set. Run this program from SQL*Plus while connected as SYSDBA to the target database:

	DECLARE		DECLARE
	devtype varchar2(256);		devtype varchar2(256);
	done boolean;		done boolean;
	BEGIN		BEGIN
	devtype := dbms_backup_restore.deviceallocate('devtype', params=>'');		devtype := dbms_backup_restore.deviceallocate('devtype', params=>'');
	# Replace 'devtype' with the device type you used when creating the backup: NULL or		# Replace 'devtype' with the device type you used when creating the backup: NULL or
Riga 46:		Riga 46:
	# repeat the restorebackuppiece statement for each backup piece in the backup set.		# repeat the restorebackuppiece statement for each backup piece in the backup set.

	END;		END;
	/		/

	---------------------------------------------------------------------------------------------------------------------		---------------------------------------------------------------------------------------------------------------------

WikiSysop il 10:45, 26 ott 2015

2015-10-26T10:45:36Z

← Versione meno recente		Versione delle 10:45, 26 ott 2015
Riga 9:		Riga 9:


			==restore from plsql==
			da: http://docs.oracle.com/cd/A87860_01/doc/server.817/a76990/rmanreco.htm#441496

			---------------------------------------------------------------------------------------------------------------------

			Restoring the Control File from a Backup Set Without Using RMAN

			You must use a non-standard procedure to restore a control file from an RMAN backup set in the following situations:

			You are using a pre-8.0.5 version of RMAN to restore a database when more than one database with the same name is registered in the recovery catalog (see "Restoring When Multiple Databases Share the Same Name" for a discussion of this problem).

			You are not using a recovery catalog, and your only control file backup is in an RMAN backup set.

			If you have no other backup of the control file except in a RMAN backup set, and you need the control file to perform a restore operation, use the following PL/SQL program to extract the control file from the backup set. Run this program from SQL*Plus while connected as SYSDBA to the target database:

			DECLARE
			devtype varchar2(256);
			done boolean;
			BEGIN
			devtype := dbms_backup_restore.deviceallocate('devtype', params=>'');
			# Replace 'devtype' with the device type you used when creating the backup: NULL or
			# sbt_tape. If you used an sbt_tape device and specified a 'parms' option on the RMAN
			# allocate channel command, then put that parms data in the 'params' operand here.

			dbms_backup_restore.restoresetdatafile;

			dbms_backup_restore.restorecontrolfileto('/tmp/foo.cf');
			# This path specifies the location for the restored control file. If there are multiple
			# control files specified in the init.ora file, copy the control file to all specified
			# locations before mounting the database.

			dbms_backup_restore.restorebackuppiece('handle',done=>done);
			# Replace 'handle' with the your backup piece handle. This example assumes that the
			# backup set contains only one backup piece. If there is more than one backup piece in
			# the backup set (which only happens if the RMAN command set limit kbytes is used), then
			# repeat the restorebackuppiece statement for each backup piece in the backup set.

			END;
			/

			---------------------------------------------------------------------------------------------------------------------
	[[Categoria:Database]]		[[Categoria:Database]]

WikiSysop: Creata pagina con 'UNTIL TIME Recovery SQL> shutdown immediate; SQL> startup mount; —No restore b/c OS or other means are used to restore necessary files— SQL> recover database...'

2014-09-09T12:06:54Z

Creata pagina con 'UNTIL TIME Recovery SQL> shutdown immediate; SQL> startup mount; —No restore b/c OS or other means are used to restore necessary files— SQL> recover database...'

Nuova pagina

UNTIL TIME Recovery

SQL> shutdown immediate;
SQL> startup mount;
—No restore b/c OS or other means are used to restore necessary files—
SQL> recover database UNTIL TIME '2006-08-15:14:07:00'
The time format must be in the format YYYY-MM-DD:HH24:MM:SS irrespective of NLS_DATE_FORMAT
SQL> alter database open resetlogs;

[[Categoria:Database]]